Excel Webinar Registrations

Turn your lunch hour into a CPD hour

Excel Live Webinar Registrations

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 450 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 / TimeWebinar DetailsPriceRegistration Link
Thu 17 Oct 2024
Start time
1pm AEDST (Sydney time)
FREE - Financial Functions Part 1

Excel has many functions dedicated to financial calculations. These functions take three or more arguments and there are a few things you need to know to use them correctly.

Most involve loans or calculations associated with the time value of money.

This session will cover the following functions

- PV - Present Value
- PMT - loan payments
- CUMIPMT - cumulative interest for loan schedules
- RATE - interest rate
- FV - future value
- NPER - number of period
- Dynamic arrays - see how to use them for a loan schedule

The session has a loan model that calculates the "missing" value for a loan scenario.
FREERegister