| Date: | 10/09/2024—12/09/2024 |
|---|---|
| Time: | 1:00 PM AEST |
| Event: | Excel Level Two - Intermediate - 3 webinars |
| Topic: | Excel Level Two - Intermediate |
| Public: | Public |
| Registration: | Click here to register. |
Webinars – Excel Level Two – Intermediate Series (3 webinars)
Price: AU$25
Duration: 4 hours 30 min – over 3 consecutive days.
This is a three-part series of live webinars run over three consecutive days.
Each session will be about 90 minutes 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
- Introduction to Pivot Tables – creating reports with no formulas
- Slicers – how to filter a Pivot Table
- Functions – SUM, SUMIFS, COUNTIFS, IF, XLOOKUP, IFERROR
- Dynamic Arrays – the new way to calculate in Excel
- Conditional formats – formats that automatically update
- Introduction to Charts – tips and guidelines on creating useful graphs
- Sparklines– using cell-based charts
- 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.