Overview
This course on Advanced Pivot Tables in Excel aims to enhance the skills of intermediate to advanced users. By the end of the course, learners will be able to combine data from multiple worksheets, manipulate pivot tables, group and ungroup data, apply different pivot table layouts and styles, and format error values and empty cells. The teaching method involves a follow-along tutorial with practical exercises to reinforce learning. This course is intended for individuals with prior knowledge of pivot tables and Excel looking to further develop their data analysis skills.
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