Master advanced pivot table techniques in Excel with this comprehensive 2.5-hour tutorial. Dive deep into importing data from various sources, cleaning and manipulating data, combining information from multiple worksheets, and exploring different pivot table layouts and styles. Learn to group and ungroup data, format error values and empty cells, and apply custom number formatting. Follow along with downloadable exercise files to practice creating, manipulating, and customizing pivot tables for powerful data analysis. Suitable for intermediate to advanced Excel users looking to enhance their pivot table skills and streamline complex data operations.
Overview
Syllabus
- Introduction to Advanced PivotTables
- PivotTables Recap
- Importing data from a text file
- Importing data from Access
- Exercise 01
- Cleaning Data
- Tabular Data
- Exercise 02
- Creating and Manipulating a PivotTable
- Combining Data from Multiple Worksheets
- Grouping and Ungrouping
- Report Layouts
- Formatting Error Values and Empty Cells
- Exercise 03
- PivotTable Styles
- Custom Number Formatting
- Exercise 04
Taught by
Simon Sez IT
