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.
- 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
- Multiple layer slicing-and-dicing
- Multiple values
- Useful Pivot Table options
- 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.
You will need Excel for Office365 to take this course.