Excel Live Webinar Registrations

Photo by Samantha Borges on Unsplash
You can learn new Excel skills and techniques in your lunch hour. Learn how to save time in doing common tasks.
Since 2012 I have presented over 480 public webinars to thousands of people worldwide.
All webinars include a detailed pdf instruction manual and an example Excel file.
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.
Day / Date / Time | Webinar Details | Price | Registration Link |
---|---|---|---|
Tue 18 Feb 2025 Start time 1pm AEDST (Sydney time) | NEW! Excel Budget Scenarios Learn how to convert a budget into a multiple scenario budget. This sessions takes the budget from the Budget Challenge session and converts it into a multiple scenario solution. Techniques shared: - the structure to make the conversion easier - using the OFFSET and MATCH functions to extract the correct scenario - helper cells to simplify formulas - keyboard shortcuts to speed up the conversion - finding cells based on colour - sheet grouping - useful but comes with a warning - data tables to capture the important metrics from each scenario - adding even more scenarios As always there will be few general tips along the way. | AUD25 | Register |
Thu 20 Feb 2025 Start time 1pm AEDST (Sydney time) | Excel Budget Template - Subscription version This session is based on the subscription version of Excel. In this webinar I will share a budget structure I have used successfully to create a budget that allows a couple of levels or reporting. I have updated the template with new dynamic array functionality. This structure has some flexibility and incorporates a number of advanced Excel features that work well together. The budget template is scalable and can be applied to numerous structures. If you have a Jul-Jun financial year you might want to get a head start on next year's budget/forecast. The Budget Template session outcomes will include • discover a scalable, flexible Excel budget structure • learn formulas that can easily consolidate budgets from multiple sheets, making uploads into accounting systems easier • find out about a little-used function that can make allocations easier to create • see how to use tables to add structure and flexibility to your Excel files • a range name trick that involves formatted tables • adding validations to your budgets • using new dynamic arrays within a budget structure As always, you will also pick up a few other tips and tricks along the way. This is a longer than normal session (1.5 hours) and covers many advanced topics that can simplify your budget process. | AUD25 | Register |
Tue 25 Feb 2025 Start time 1pm AEDST (Sydney time) | Three Statement Budget - Dynamic Arrays (75 min) This session examines how you can create a combined Profit & Loss, Balance Sheet and a Cash Flow budget. This session uses the subscription version of Excel with dynamic arrays. We will focus on reviewing existing formulas and structures. The techniques covered include - display and format techniques for budgets - functions used EDATE, IF, SUMIFS, INDEX, MATCH - dynamic array function used SEQUENCE - using dynamic array formulas - using centralised logic calculations - different budget assumption calculations - handling single or monthly assumptions - getting a flexible starting position for the balance sheet - using a workings sheet - loan schedule - handling GST - validations that handle error cells | AUD25 | Register |
Thu 27 Feb 2025 Start time 1pm AEDST (Sydney time) | Budget and Power Query This session requires the subscription version of Excel. Discover how to use Power Query to solve two major issues in multi-file budget systems. Example uses a P&L budget. If you have a Jul-Jun financial year you might want to get a head start on next year's budget/forecast. These techniques have been applied to a budget, but could also be used for forecasting and reporting. Learn how to - quickly create a budget template to speed up development time - use dynamic arrays to create formulas - link all budget files to central tables that expand - create dynamic drop down lists - compile multiple Excel budget files into a single budget layout - create a normalised budget listing ready for use in pivot tables and formula-based reports - how to use folders for versions and easily update the folder in your compilation file. This is a practical, hands-on application of Power Query in a budgeting setting. | AUD25 | Register |
The next free session will be held in mid-March 2025. |