Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Advanced Pivot Tables Tutorial in Excel

Simon Sez IT via YouTube

Start learning Write review
Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course builds advanced PivotTable skills in Excel, covering data import and cleaning, combining data from multiple worksheets, grouping, report layouts, styles, and custom number formatting. It assumes prior experience with Excel and PivotTables and includes follow-along exercises.

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

Reviews

Start your review of Advanced Pivot Tables Tutorial in Excel

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.