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 450 public webinars to thousands of people worldwide.
All sessions include a detailed pdf instruction manual and an example 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.
The price for paid webinars is $25 each.
May 2024 Special Offer – Essential Macros Bundle AU$60 – all four of May’s live webinars (over 5 hours of training) plus the online courses – link below has more details.
Essential Macros Bundle – More Details – AU$60
| Date | Webinar Details | Price | Registration Link |
|---|---|---|---|
| Thu 16 May 2024 | FREE - Macros 1 - Recorded Macros - Tips, Tricks & Traps It is easy to create a recorded macro. It is not so easy to create a flexible and re-usable recorded macro. Learn the techniques that can allow you to record effective macros that can handle different ranges and changes to sheet names. Macros can speed up your work and reduce the time taken for tedious tasks, as well as adding functionality to Excel. This is the first in a series of webinars dedicated to macros. Future sessions will expand on the techniques taught in this session. Session includes bonus macros that you can use straight away to save time and effort. | FREE | Register |
| Tue 21 May 2024 | Macros 2 - Recorded to Remarkable Recorded macros have many limitations. Almost all of those limitations can be removed by editing the recorded macros and adding programming code. This creates macros that are more useful, flexible and easier to maintain. This webinar focuses on the most common VBA code added to recorded macros. Basic error handling is included. A worked example is used to demonstrate all of the techniques. (This session assumes you have completed the Macros 1 session or that you are comfortable with recording macros) Macros can speed up your work and reduce the time taken for tedious tasks, as well as adding functionality to Excel. This session will help you take Excel to the next level. This is the second in a series of webinars dedicated to macros. Future sessions will expand on the techniques taught in this and the first session. Session includes a manual, bonus macros that you can use straight away to save time and effort. | AUD25 | Register |
| Thu 23 May 2024 | Macros 3 - Interaction & Debugging Techniques Recorded macros can’t interact with the user. Macros that interact with the user are more user-friendly and flexible. Learn the techniques that allow you to use one-way and two-way communication with the user whilst your macro is running. Debugging involves removing errors from your code. As you build more complex macros you will need to improve your debugging skills. Discover the built-in features in Excel that make this important process easier. You need to have done the Macros 1 and 2 webinars or at least be familiar with editing recorded macros to get the most from this session. | AUD25 | Register |
| Tue 28 May 2024 | Macros 8 - VBA Variables This session covers variables in depth and expands on previous sessions. Learn how to make the most of variables in your VBA code. There are so many advantages to using variables, but you need to get a good understanding of them to get the most out of them. This session covers - variable types, as well as when, how and why to use them - shortcuts that can reduce the typing involved with variables - useful examples to demonstrate variable usage - building user messages - selecting separate sheets based on user input - combining data sheets based on a criteria | AUD25 | Register |