Pivot Tables

Do Pivot Tables look a bit too hard? Not sure you can master them? Yes, you can!
This 3-lesson short course takes you from zero to hero on Pivot Tables.

Lesson 1:

• What Pivot Tables actually do
• Creating your first Pivot Table (yay!)
• Slicing-and-dicing the data
• Showing different functions of values
• Style and formatting basics

Lesson 2:

• Multiple layer slicing-and-dicing
• Multiple values
• Useful Pivot Table options
• Filtering

Lesson 3:

• Drilldown
• Groups
• Calculated Fields
• Report Filter Pages
• Slicers and Timelines
• Pivot Charts

As always, each lesson has a practical exercise so that can have a go at the techniques learnt in the lesson.

---

Excel Version
You will need Excel for Office365 to take this course.