This course on Excel Pivot Tables aims to teach learners how to easily create, modify, and update Pivot Tables and charts. The course covers organizing data in tables, data organization techniques, data mining, custom sort commands, merging data using XLOOKUP, setting up Pivot Tables, building reports, formatting, drilldowns, refreshing, designing for reports and charts, working with calculated fields, items, grouping, turning on Power Pivot, adding data, establishing relationships, using the RELATED function, and integrating Pivot Tables. The course is designed for anyone who uses Excel and wants to harness the power of Pivot Tables for data analysis and visualization.
Overview
Syllabus
Start
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
