Module 1: Introduction to PivotTable
Module 2: Setting your Data Right
Module 3: Creating a PivotTable
Module 4: Optimizing on the features of Slicers
Module 5: Customizing a PivotTable and the Fields
Module 6: Investigating Your Data with PivotTable.
Based on the concepts and practical steps on the Pivot- Table created, you will now analyse a scenario.
Which products are not selling well?
What are the top 10 product categories?
Who are our top 5 sales person?
What is the average unit price for each category?
How many orders did we have for each category
Which categories make up over 50% of our total revenue?
Compare montly sales, MoM?
Monthly sales vs YTD sales
Module 7: Analysis with PivotTable Grouping
Module 8: Peforming Calculation within PivotTable
Module 9: Interpreting data with PivotCharts
Module 10: Analyzing Multiple Data Sources
Module 11: Creating Interactive Dashboard with PivotTable and PivotChart