Date: | 18/11/2021 |
---|---|
Time: | 1:00 PM AEDST |
Event: | FREE Excel PivotTable Essentials |
Topic: | Excel PivotTable Essentials |
Public: | Public |
Registration: | Click here to register. |
Excel PivotTable Essentials
NO CHARGE
Duration: 1 hour
This updated session will cover the basics of pivot table creation as well as solving some common frustrations. Topics covered include
- pivot cache what it is and why it is important
- data rules that make creating pivot tables easier
- format as table and why you need to use it
- populating missing entries in the data – manually and with Power Query
- the basics of creation
- pivot charts
- filtering with slicers
- grouping
As always, I will share a few general tips along the way.