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

YouTube

Microsoft Excel PivotTables Explained

Simon Sez IT via YouTube

Start learning Write review
Corporate Finance Institute Ad

Build the Finance Skills That Lead to Promotions, Not Just Certificates

Learn More → Scrimba Ad

Get 20% off all career paths from fullstack to AI

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course teaches how to create and customize Microsoft Excel PivotTables for analyzing large datasets. It covers field arrangement, totals, value summaries, grouping, formatting, layouts, styles, filtering, and a hands-on exercise.

Syllabus

- Intro
- PivotTables Explained
- Creating PivotTables from Scratch
- Pivoting the PivotTable Fields
- Subtotals and Grand Totals
- Number Formatting
- Show Values As and Summarize Values By
- Grouping PivotTable Data
- Formatting Error Values and Empty Cells
- Choosing a Report Layout
- Applying PivotTable Styles
- Exercise 06

Taught by

Simon Sez IT

Reviews

Start your review of Microsoft Excel PivotTables Explained

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.