Login
Excel Yourself/Macro Essentials Course
Buy now

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 

  • $59

Macro Essentials Course

Start with the basics and progress to real programming. 
Buy now

Contents

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
    • 216 KB
    Preview
    Recorded Macros 2020.xlsm
    • 214 KB
    Preview
    Recorded Macros tips and tricks 2020.pdf
    • 606 KB
    Preview
    Macros1 Recording tips recording
    • (1h 07m 41s)
    • 234 MB
    Preview
    Recording Macros Quiz

      Recorded to Remarkable

      Recorded to Remarkable
        Macros 2 Recorded to Remarkable 2020.pdf
        • 474 KB
        Macros 2 Recorded To Remarkable 2020.xlsm
        • 140 KB
        Macros 2 Recorded To Remarkable 2020 completed.xlsm
        • 145 KB
        Macros 2 Recorded to Remarkable recording
        • (1h 33m 39s)
        • 326 MB
        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
            • 487 KB
            Interactive Macros 2020.xlsm
            • 155 KB
            Macros 3 Interaction and Debugging recording
            • (1h 29m 51s)
            • 320 MB
            Interactive Macros 2020 completed 20200820.xlsm
            • 168 KB
            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
                • 442 KB
                Macros_8_Variables_2020.xlsm
                • 122 KB
                Macros 8 VBA Variables Video
                • (1h 33m 31s)
                • 307 MB
                Macros_8_Variables_2020_completed_20200825.xlsm
                • 131 KB
                VBA Variables: Quiz

                  Bonus Content

                  Bonus 1 - Maximum Autofit column width
                    Bonus 1 - Auto Width Maximum video
                    • 5 mins
                    • 23.5 MB
                    Bonus 1 - Example file with Auto Width Limit macro
                    • 14.5 KB
                    Bonus 2 - Constants
                      Bonus 2 - Constant video
                      • 4 mins
                      • 13.2 MB
                      Bonus 2 - Example file with Constant macro
                      • 14.2 KB
                      Bonus 3 - Ranges
                        Bonus 3 - Example file with macro code
                        • 14.2 KB
                        Bonus 3 - Ranges Video
                        • 8 mins
                        • 32.5 MB
                        Bonus 4 - OpenControl.xlsb
                        • 15.7 KB
                        Bonus 4 - Activating Sheet When File is Opened.pdf
                        • 261 KB
                        Bonus 4 - Open on Sheet video
                        • 3 mins
                        • 14.6 MB