Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us


Related Courses
Macros introduction
Macros next step
Macros advanced


Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’

Macro-writing courses

Speed up with macros - introduction 1-day

     Duration: 1 day  
     Format: Fully hands-on  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  

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


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.


AbleOwl has a number of different presenters, all of whom are Excel specialists.

See dates of all courses  

A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.