Excel 2021 Pivot Tables Tutorial

This course teaches Excel 2021/365 users to organize and prepare data, create and customize PivotTable reports and charts, and use XLOOKUP and Power Pivot to combine related tables. It also covers calculated fields, grouping, drilldowns, refreshing, and data-model relationships.

Syllabus

Start
Introduction
Organizing Data in Tables
More Data Organization Techniques
Data Mining
Custom Sort Command and Functions
Merge Data Using XLOOKUP
Pivot Tables - Setup
Pivot Tables - Building Reports
Pivot Tables - Formats, Drilldowns, and Refreshing
Pivot Tables - Designing for Reports and Charts
Pivot Tables - Cal Fields, Items, and Grouping
Power Pivot - Turning It On
Power Pivot - Adding Data and Establishing Relationships
Power Pivot - RELATED Function and Pivot Tables
Conclusion