Paid Live Webinar $25 (includes live event, pdf manual and Excel file plus the recording)
Save money with the Webinar Pass ($20 webinars when you pre-pay).
PivotTables allow you to summarise and report on large data sets in seconds. This updated session will cover the basics of pivottable 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
- Power Query and how to fix bad data like missing entries
- the basics of creation
- filtering with slicers
You will probably pick up a few other tips and tricks along the way.