Paid Live Webinar $25 (includes live event, pdf manual and Excel file plus the recording) - a tax invoice will be sent.
PivotTables allow you to summarise and report on large data sets in seconds.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 using Power Query
- the basics of creation
- pivot charts
- filtering with slicers
You will probably pick up a few other tips and tricks along the way.