For some people that work with Excel, Pivot Tables present a great opportunity to seamlessly deal with Data analysis and reporting. The training has been created by our founder in conjunction with highly experienced corporate analysts who use Pivot Tables on a daily basis in a corporate environment and at just over two hours you will be using this training immediately.
Course Curriculum
(Click for details)
MODULE 1: INTRODUCTION & DATA PREPARATION
1.Pivot Intro 2.Pivot Cache 3. Altering the Data Source 4. Unpivot data to a long boring list 5. Moving row and column 6. Expand and Collapse field
MODULE 2: LAYOUT AND FORMATS
7. Format Error and Empty cells 8. Change Layout of Pivot Table 9. Place Pivot Table 10. Pivot Table Styles 11. Format Content in Pivot
MODULE 3: CORE PIVOT TABLE ANALYSIS
12. Summarise Value by 13. Multiple Subtotal 14. Percentage of column total 15. Difference From value as percentage 16. Double click for detail 17. Running Total 18. Grouping Year Month Quarter 19. Sorting
MODULE 4: FILTERS AND SLICERS
20. Filtering – Part 1 21. Filtering – Part 2 22. Slicer – Insert Style Property 23. One Slicer connected to Multiple Pivots 24. Timeline Slicer
MODULE 5: ADVANCED ANALYSIS
25. Calculated Field 26. Link Multiple Table into One Pivot – Part 1 27. Link Multiple Table into One Pivot – Part 2 28. Calculated Field with IF statement
MODULE 6: VISUALS AND REPORTS
29. Conditional Formatting in Pivot – Part 1 30. Conditional Formatting in Pivot – Part 2 31. PivotCharts Part 1 32. PivotCharts Part 2 – Linking and Slicers 33. PivotCharts Part 3 – Formatting 34. Dashboard 1 – What we will build 35. Dashboard 2 – Our Dataset 36. Dashboard 3 – Pie Chart 37. Dashboard 4 – Line Chart 38. Dashboard 5 – Bar Chart 39. Dashboard 6 – Map Chart 40. Dashboard 7 – Putting it all together 41. Outro