The Complete Macro Series

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.

No previous programming is assumed. 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 11 hours of video with lots of examples and detailed explanations. The pdf manuals are all very detailed. There is bonus content not included in the live webinars. Most sections include a quiz.

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
error handling

The course also covers more advanced topics.

Event macros - macros that run automatically
Functions - create your own spreadsheet functions and reusable code
Two separate workshop sessions that use real world examples to demonstrate how to create macros
Create an Add-in to create audit reports for files

Level: Intermediate

Duration: 11+ hours
Price: AU$140

$139

The Complete Macro Series

Over 11 hours of video, detailed pdf manuals, example code, bonuses and quizzes.

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

Recorded to Remarkable 2020.pdf

Recorded To Remarkable 2020.xlsm

Recorded To Remarkable 2020 completed.xlsm

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

Interaction and debugging 2020.pdf

Interactive Macros 2020.xlsm

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

VBA Variables 2020.pdf

VBA Variables_2020.xlsm

VBA Variables recording

VBA 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 - Activating Sheet When File is Opened.pdf

Bonus 4 - OpenControl.xlsb

Bonus 4 - Open on Sheet video

Event Macros

Event Macros- automating your macros

Automating Macros 2020.pdf

Automation Using Events 2020.xlsm

Automating with Events recording

Automation Using Events 2020 completed.xlsm

Event Macros: Quiz

Function Macros

Function Macros 2020.pdf

Function Macros 2020.xlsm

Function Macros recording

Function Macros 2020 No Conditional Format completed.xlsm

Function Macros: Quiz

Macro Workshop 1

Macro Workshop 1 - 2020.pdf

Macro Workshop 1 - 2020.xlsm

Macros Workshop 1 recording

Macro Workshop 1 - 2020 - completed.xlsm

Macro Workshop 1: Quiz

Bonus - Macro Workshop 2

Macro Workshop 2

Bonus - Macro Workshop 2.pdf

Bonus - Macro Workshop 2.xlsm

Bonus - Macro Workshop 2 recording

Bonus - Macro Workshop 2 complete.xlsm

Creating an Excel Add-in

Report_Add-ins 2020.pdf

Report_Add_In_2020.xlsm

Report Add-in recording

Report_Add_In_2020_complete.xlam

The Complete Macro Series

The Complete Macro Series

Contents

Recording tips, trick and traps

Recorded to Remarkable

User Interaction & Debugging

VBA Variables

Bonus Content

Event Macros

Function Macros

Macro Workshop 1

Bonus - Macro Workshop 2

Creating an Excel Add-in

More Bonus Content