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, with no pre-recorded content.
Questions are answered live.

My Excel webinars started in 2012. I have presented over 400 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.
All webinars start at 1PM Sydney Australia time.
The price for paid webinars is $25 each.

Day/DateName / TopicsPriceLinks
Thu 14 Mar 2024FREE - Excel Dashboard #1 - Guidelines

This is the first session is a series of five webinars on Excel dashboards. The other four sessions are paid sessions.

In this free session we will focus on chart and dashboard guidelines plus some techniques used to create better dashboards.

We will also look at creating a bullet chart which is a better alternative to a gauge or dial chart.

The session will cover
- general chart guidelines
- questions to ask yourself to develop better charts
- best charts to use
- charts and formats to avoid
- using text boxes on dashboards
- how to create small charts
- chart templates
- lining up and re-sizing charts
- useful number formats for dashboard charts
- using the #N/A error with charts
- how to create a bullet chart
As always I will share a few other tips.
FREERegister
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