Capstone Project

1- Introduction to PivotTables 2- Navigating the areas of a PivotTables 3- Analyze Data with multiple fields 4- Demo: Working with multiple fields 5- Change PivotTable Default Name 6- Summary Aggregations 7- Show values as % of Grand Total 8- Show values as % of Row Total 9- Show values as % of Column Total 10- Show values as % of Parent Row Total 11- Showing running totals 12- Time Intelligence calculations 13- Show ranking 14- Introduction to calculated fields 15- Calculated Fields 2 16- Calculated Fields 3 17- PivotTables Styles 18- Customize PivotTable Styles 19- PivotTables Layouts 20- PivotTables Layout options 21- PivotTables Fields Pane 22- Sorting PivotTables 23- Filtering PivotTables 24- Filtering PivotTables with Slicers 25- Connecting slicers to multiple PivotTables 26- Filter Table with Timelines 27- Grouping Data with PivotTable 28- Working with PivotCharts 29- Working with modern charts 30- Applying conditional formatting 31- Working with Sparklines - Line 32- Working with Sparklines - Bar 33- Working with Sparklines - Win/ Loss 34- Show report filter pages 35- Show PivotTable values detail 36- Using GETPIVOTDATA function 37- Course Conclusion 38- Guided Project 1 39- Guided Project 2 40- Capstone Project 41- Course Overview 42- Welcome to the course 43- Datasets walkthrough