This is a three-part series of webinar recordings run over three consecutive days. Each session is about 1.5 hours long.

The sessions will 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

• Custom Lists – save time and effort with commonly used lists

• Introduction to Pivot Tables – creating reports with no formulas

• Slicers – how to filter a Pivot Table

• Functions – SUM, SUMIFS, SUBTOTAL, COUNTIFS, IF, VLOOKUP, IFERROR

• Conditional formats – formats that automatically update

• Introduction to Charts and Sparklines – tips and tricks on creating useful graphs

Along the way there will be lots of shortcuts and advice on creating effective spreadsheets.

Level: Intermediate
Duration: 4.5+ hours
Price: AU$25