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

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

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.