Login
Excel Yourself/The Complete Macro Series
Buy now

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

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
        Recorded to Remarkable 2020.pdf
        • 474 KB
        Recorded To Remarkable 2020.xlsm
        • 140 KB
        Recorded To Remarkable 2020 completed.xlsm
        • 145 KB
        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
            Interaction and debugging 2020.pdf
            • 487 KB
            Interactive Macros 2020.xlsm
            • 155 KB
            Interactive Macros 2020.xlsm
            • 155 KB
            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
                VBA Variables 2020.pdf
                • 442 KB
                VBA Variables_2020.xlsm
                • 122 KB
                VBA Variables recording
                • (1h 33m 31s)
                • 307 MB
                VBA 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 - Activating Sheet When File is Opened.pdf
                        • 261 KB
                        Bonus 4 - OpenControl.xlsb
                        • 15.7 KB
                        Bonus 4 - Open on Sheet video
                        • 3 mins
                        • 14.6 MB

                        Event Macros

                        Event Macros- automating your macros
                          Automating Macros 2020.pdf
                          • 540 KB
                          Automation Using Events 2020.xlsm
                          • 216 KB
                          Automating with Events recording
                          • (1h 15m 06s)
                          • 253 MB
                          Automation Using Events 2020 completed.xlsm
                          • 219 KB
                          Event Macros: Quiz

                            Function Macros

                            Function Macros
                              Function Macros 2020.pdf
                              • 657 KB
                              Function Macros 2020.xlsm
                              • 121 KB
                              Function Macros recording
                              • (1h 05m 01s)
                              • 217 MB
                              Function Macros 2020 No Conditional Format completed.xlsm
                              • 123 KB
                              Function Macros: Quiz

                                Macro Workshop 1

                                Macro Workshop 1
                                  Macro Workshop 1 - 2020.pdf
                                  • 522 KB
                                  Macro Workshop 1 - 2020.xlsm
                                  • 131 KB
                                  Macros Workshop 1 recording
                                  • (1h 12m 09s)
                                  • 288 MB
                                  Macro Workshop 1 - 2020 - completed.xlsm
                                  • 141 KB
                                  Macro Workshop 1: Quiz

                                    Bonus - Macro Workshop 2

                                    Macro Workshop 2
                                      Bonus - Macro Workshop 2.pdf
                                      • 791 KB
                                      Bonus - Macro Workshop 2.xlsm
                                      • 602 KB
                                      Bonus - Macro Workshop 2 recording
                                      • (1h 03m 34s)
                                      • 205 MB
                                      Bonus - Macro Workshop 2 complete.xlsm
                                      • 53.2 KB

                                      Creating an Excel Add-in

                                      Creating an Excel Add-in
                                        Creating an Excel Add-in
                                          Report_Add-ins 2020.pdf
                                          • 771 KB
                                          Report_Add_In_2020.xlsm
                                          • 846 KB
                                          Report Add-in recording
                                          • (1h 08m 27s)
                                          • 256 MB
                                          Report_Add_In_2020_complete.xlam
                                          • 846 KB

                                          More Bonus Content

                                          Bonus 5 - PivotTable Listing Macro.pdf
                                          • 189 KB
                                          Bonus 5 - PivotTable Listing Macro.xlsb
                                          • 336 KB
                                          Bonus 5 - PivotTable Listing video
                                          • 5 mins
                                          • 19.8 MB
                                          Bonus 6 - Stop Clearing the Clipboard.pdf
                                          • 178 KB
                                          Bonus 6 - Stop_Clear_Clipboard.xlsb
                                          • 14.9 KB
                                          Bonus 6 - StopClearClipboard video
                                          • 6 mins
                                          • 21.1 MB
                                          Bonus 7 - Excel VBA to Remove Filters.pdf
                                          • 123 KB
                                          Bonus 7 - RemoveFilter.xlsb
                                          • 123 KB
                                          Bonus 7 - RemoverFilters video
                                          • 5 mins
                                          • 29 MB