Learn how to create, modify, and update Pivot Tables and charts in Excel 2021. This course is designed for anyone who uses Excel and aims to harness the power of Pivot Tables to efficiently analyze large datasets. The course covers organizing data, data mining, custom sorting, merging data using XLOOKUP, setting up Pivot Tables, designing reports and charts, and utilizing Power Pivot. The teaching method includes step-by-step tutorials and practical exercises.
Overview
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
Taught by
Learnit Training
