This is a three-part series of webinar recordings. Each session is about 90 minutes long. The sessions take you through the following topics
Format as table – why and how to use it
Filtering – tips and tricks
Sorting – tips, trick and traps
Data Validation – limiting entries in cells
Introduction to Pivot Tables – creating reports with no formulas
Slicers – how to filter a Pivot Table
Functions – SUM, SUMIFS, TIFS, IF, XLOOKUP and IFERROR
Conditional formats – formats that automatically update
Introduction to Charts and Sparklines – tips and tricks on creating useful graphs
Custom Lists – save time and effort with commonly used lists
Along the way there will be lots of shortcuts and advice on creating effective spreadsheets.
Level: Intermediate
Duration: 4.5+ hours
Price: AU$25
The session materials
a pdf manual which you can print out and make notes in.
This is used for all three sessions.
Excel file to work through during the session
The completed daily files are seen in each session's section