How to Create a Pivot Table in Excel2019-02-26T01:59:58+00:00

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!

SIGN UP

About the course

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
  • Download videos to your device and watch offline
  • 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

1.Pivot Intro04:28
2.Pivot Cache01:20
3. Altering the Data Source02:56
4. Unpivot data to a long boring list04:16
5. Moving row and column01:54
6. Expand and Collapse field03:02
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

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

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

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