Excel Webinar Registrations

Turn your lunch hour into a CPD hour

Excel Live Webinar Registrations

Learn new Excel skills and techniques in your lunch hour.
Webinars are presented live.

My Excel webinars started in 2012. I have presented over 450 public webinars to thousands of people worldwide.

All sessions include a detailed pdf instruction manual (no PowerPoint slides) and an example file.
Session materials can be downloaded before the session.
All registrants receive access to the recording the day after the session.

The next sessions, including free sessions, are listed below.
Join the Free Registration List to always be registered for free sessions.
All webinars start at 1PM Sydney Australia time.
The price for paid webinars is $25 each.

Day/DateName / TopicsPriceLinks
Tue 19 Mar 2024Dashboard #2 - Formulas & Functions
This is the old school technique of creating dashboards in Excel.
We will create summary reports from the data and from those summary reports we will extract the chart data which we will then base our charts on.

We will look at techniques to create small charts and how we can combine those on a dashboard.

The session includes
- formula basics
- formulas that work with dates
- automating headings
- SUMIFS function
- INDEX function
- formats for dashboards
- using templates
As always, I will share other tips and tricks along the way.
AUD25Register
Thu 21 Mar 2024Dashboard #3 - Sparkline & Conditional Formats
This is the third in the series and focuses on Sparkline charts as well as using Conditional Formatting with dashboards. Sparkline charts are small charts that are specifically designed for dashboards.

We will add ticks and crosses using conditional formats to identify measures (good and bad) that may need review.

The Chart Data sheet structure has already been populated so we will review some of the formulas used in its creation.

The session includes
- reviewing report formulas
- MATCH function
- dynamic arrays
- handling high score is bad vs low score is bad in a formula
- default settings you may need to change for Sparkline charts
- controlling the display of ticks and crosses
- formats for dashboards

As always, I will share other tips and tricks along the way.
AUD25Register
Tue 26 Mar 2024Dashboard #4 - PivotChart & Slicers
This session is based on the subscription version of Excel.
This is the fourth in the series and focuses on creating a dashboard using PivotCharts with Slicers.

PivotTables are extremely powerful and allow you to summarise large data sets very quickly without using any formulas. PivotCharts are charts that are based on PivotTables and are extremely interactive. This dashboard will use Slicers to add interactivity to the dashboard so that users can change the dashboard.

The session includes
- how a PivotTable works
- creating a PivotTable that works well with a chart formats for large values
- making PivotCharts display better for dashboards
- making changes to PivotTables to improve headings
- sorting and Top 10 reports
- use Slicers to control filters on multiple PivotTables
- using the GETPIVOTDATA function with dynamic arrays to create specific reports/charts

As always, I will share other tips and tricks along the way.
AUD25Register
Wed 27 Mar 2024Dashboard #5 - Dynamic Arrays
This session is based on the subscription version of Excel.
This is the fifth in the series and focuses on creating a dashboard using dynamic arrays.

This session requires the subscription version of Excel.

This session covers.
- Creating and using spill ranges
- New functions SEQUENCE, UNIQUE, SORT, TEXTBEFORE, DROP, TAKE and VSTACK
- Using a single SUMIFS for detail and total calculations
- Handling current and prior year data
- Creating spill ranges that make drive dynamic charts
- Using range names to shorten formulas
- Using chart templates
As always, I will share other tips and tricks along the way.
AUD25Register
The next free session will be held in April 2024 and will be on Dynamic Arrays.