Ultimate Pivot Tables Course

Master Pivot Tables in under 2 hours with our no-fluff course and begin to create power analysis and reports the same day as you sign up!

Companies are producing more data than ever, and this trend will only continue so the ability to deal with that data for the average professional is now a necessity rather than a ‘nice to have’.

Pivot Tables can make the challenge of dealing with your data seamless. In our ‘Rapid Pivot Tables’ course, you will learn ‘over the shoulder’ as we show you how to quickly summarise your data and create value add reports that will make a difference to your company.

What you will learn

We will teach you all you need to know about Pivot Tables

• Quick fixing your Data with Power Query
• Data Formatting
• Analysis with Grouping, Sorting, Filtering
• Summarising with Calculated Fields and ‘Show Value As’
• Slicers and Timelines to visually filter
• Turn data into useful Charts and Reports that can make an impact at work

All this in just over 30 video lessons ranging from 1 to 10 minutes!

Details Bellow

What you get in this Training Course

• 2 Hours Split Over 32 Video Lessons
• Compatible with Excel Office 365, Excel 2019/2016/2013/2010/2007
• Excel files with exercises that help you to learn the lessons with ease
• 6 months of support from Excel experts with a corporate background
• Track you progress and take your own notes
• 30-day money back guarantee
• Get a certificate of completion that you can display on Linkedin

Course Content

MODULE 1: INTRODUCTION & DATA PREPARATION

 1.Pivot Intro 04:28 2.Pivot Cache 01:20 3. Altering the Data Source 02:56 4. Unpivot data to a long boring list 04:16 5. Moving row and column 01:54 6. Expand and Collapse field 03:02

MODULE 2: LAYOUT AND FORMATS

 7. Format Error and Empty cells 02:06 8. Change Layout of Pivot Table 03:28 9. Place Pivot Table 03:01 10. Pivot Table Styles 02:01 11. Format Content in Pivot 02:01

MODULE 3: CORE PIVOT TABLE ANALYSIS

 12. Summarise Value by 01:48 13. Multiple Subtotal 02:02 14. Percentage of column total 03:02 15. Difference From value as percentage 02:25 16. Double click for detail 01:27 17. Running Total 01:58 18. Grouping Year Month Quarter 02:33 19. Sorting 01:52

MODULE 4: FILTERS AND SLICERS

 20. Filtering – Part 1 03:17 21. Filtering – Part 2 03:00 22. Slicer – Insert Style Property 04:31 23. One Slicer connected to Multiple Pivots 04:01 24. Timeline Slicer 04:40

 25. Calculated Field 04:21 26. Link Multiple Table into One Pivot – Part 1 01:42 27. Link Multiple Table into One Pivot – Part 2 02:21 28. Calculated Field with IF statement 03:28

MODULE 6: VISUALS AND REPORTS

 29. Conditional Formatting in Pivot – Part 1 03:26 30. Conditional Formatting in Pivot – Part 2 03:43 31. Putting it all together into a Dashboard 1 10:00 32. Putting it all together into a Dashboard 2 10:00