Complete tasks faster by automating them.
Make it easier for others to use your spreadsheets.
Make it easier on yourself too by automating your work.
Save time by not having to remember a long sequence of steps.
Reduce errors by having a Visual Basic macro faithfully repeat the same steps each time.
Build your own functions to simplify long formulas and give others access to specialised calculations.
Stop wishing for features Excel doesn’t have: create them yourself.

Create a simple macro

• Create a simple macro to speed up a repetitive task
• Edit the macro
• Add a macro button to the Quick Access Toolbar

Automate an import application

• Recap range names, which are essential for macros
• Structure your macros into separate simple procedures
• Step through macros
• Create a procedure to run others
• Create an on-sheet button to run a macro
• Use If statements
• Prompt for the input of a month number
• Allow the user to cancel a prompt
• Check whether an input is valid
• Prompt the user to select a file
• Display messages

Loop to delete records

• Use a For¡­Next loop to process through rows
• Learn the different ways of looping

Discover objects, properties, and methods

• Understand the logic of objects, property and methods
• Discover the Object Browser
• Know how to work with the Range object to create reliable macros
• Work with collection objects

Create user-defined functions

• Build your own functions to simplify long formulas
• Create an add-in to make your user-defined functions available to all

Prerequisites

Create basic formulas and apply formatting.

• Be assured the advice you get is well-proven and utilised.
• Feel free to ask questions.
• Get time away from the office and constant interruptions.
• Enjoy a friendly environment where you don’t feel you’re holding others up.
• Instantly apply what you’ve learned on return to work.