Macro Essentials Course

Macros allow you to automate tasks in Excel. Converting manual, time consuming repetitive processes into a button click. This allows you to speed up your work and also delegate tasks more easily.

This online course will take you through the basics of

recording and editing macros
adding user interaction
adding programming techniques like decision making and looping structures
using variables
debugging your code

You will learn a few basic programming techniques. Don't be put off, as it is easy to learn because VBA (the macro language) is easy to read and understand. You might even enjoy it! I know I still enjoy programming in VBA.

Over 5 hours of video with lots of examples and detailed explanations. Each module has its own detailed pdf manual (not a PowerPoint deck).

Level: Intermediate
Duration: 5+ hours
Price: AU$59

Macro Essentials Course

Start with the basics and progress to real programming.

Buy now

Recording tips, trick and 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.

Recording Macros

Preview

Recorded Macros 2020 crashed completed.xlsm

Preview

Recorded Macros 2020.xlsm

Preview

Recorded Macros tips and tricks 2020.pdf

Preview

Macros1 Recording tips recording

Preview

Recording Macros Quiz

Recorded to Remarkable

Macros 2 Recorded to Remarkable 2020.pdf

Macros 2 Recorded To Remarkable 2020.xlsm

Macros 2 Recorded To Remarkable 2020 completed.xlsm

Macros 2 Recorded to Remarkable recording

Recorded to Remarkable: Quiz

User Interaction & Debugging

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 be familiar with editing recorded macros to get the most from this session.

Interaction & Debugging

Macro 3 Interaction and debugging 2020.pdf

Interactive Macros 2020.xlsm

Macros 3 Interaction and Debugging recording

Interactive Macros 2020 completed 20200820.xlsm

User Interaction & Debugging: Quiz

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

VBA Variables

Macros 8 Variables 2020.pdf

Macros_8_Variables_2020.xlsm

Macros 8 VBA Variables Video

Macros_8_Variables_2020_completed_20200825.xlsm

VBA Variables: Quiz

Bonus Content

Bonus 1 - Maximum Autofit column width

Bonus 1 - Auto Width Maximum video

Bonus 1 - Example file with Auto Width Limit macro

Bonus 2 - Constants

Bonus 2 - Constant video

Bonus 2 - Example file with Constant macro

Bonus 3 - Ranges

Bonus 3 - Example file with macro code

Bonus 3 - Ranges Video

Bonus 4 - OpenControl.xlsb

Bonus 4 - Activating Sheet When File is Opened.pdf

Bonus 4 - Open on Sheet video