Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Reports and Data Analysis with Excel Pivot Tables
Introduction
Introduction to Pivot Tables (3:11)
Introduction to the Course
Training Data
Correctly Structure Data (8:17)
Using Tables as a Data Source (3:25)
Creating Excel Pivot Tables
Introduction to Creating your First Pivot Table
Create a Pivot Table (6:15)
Create PivotTable with More Than One Dimension (4:17)
More than One Measure (5:23)
Change Number Formats (7:35)
Changing the Custom Number Format
Change Region and Language (3:07)
Pivot Table Menu Options
Introduction to Pivot Table Menu Options
Pivot Table Menu Options (10:18)
Pivot Table Design (4:54)
Changing the Method of Aggregation
Changing the Method of Aggregation
Method of Aggregation (8:17)
Sorting Data in a Pivot Table (4:48)
Trend - Time Analysis with Pivot Tables
Introduction to Time Analysis
Time Analysis with Pivot Tables (9:11)
Create Management Reports (3:35)
Custom Time Formulas (8:09)
Using Sparklines to Analyse trends (3:53)
Filtering Pivot Tables
Introduction to Filtering Data
Filter Text Fields (9:21)
Top 10 Analysis (4:11)
Using the Report Filter (3:26)
Using Slicers to Filter Data (5:18)
Using Slicers to Filter Multiple Pivot Tables (4:45)
Show Value As Calculations
The Show Value As Calculations
Percentage Calculation (5:32)
Show Value As Percentage of Parent Row Total (2:24)
Difference From and Ranking (6:32)
Pareto Analysis (7:29)
Percentatge of Calculation (2:20)
Frequency Analysis
Introduction to Frequency Analysis
Employee Master
Frequency Analysis (6:04)
Custom Calculations
Creating Custom Calculations
Create a Custom Calculation (3:33)
Conclusion
Conclusion
Changing the Method of Aggregation
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock