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

Overview

Learn how to create and manipulate PivotTables in Microsoft Excel 2021/Excel 365. The course covers creating PivotTables from scratch, pivoting fields, adding totals, formatting numbers, choosing report layouts, applying styles, and more. The teaching method includes step-by-step tutorials and exercises to practice the learned skills. This course is intended for individuals looking to enhance their data analysis and reporting skills using Excel PivotTables.

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

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.