Login
Excel Yourself/Bonus - Macro Essentials
Enrollment is closed

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 

  • $5

Bonus - Macro Essentials

  • Closed

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

Contents

Bonus Content

Over 25 minutes of bonus macro videos.

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
Bonus 5 - More Hiding Sheets Macros.pdf
Bonus 5 - Hiding Examples.xlsb
Bonus 5 - Hiding Sheets Video
Bonus 6 - Outside Borders in Excel.pdf
Bonus 6 - Macro Outside Borders.xlsb
Bonus 6 - Macro Outside Borders video