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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

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

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.