Microsoft Excel specialists

Macro-writing in Excel using Visual Basic for Applications

These courses are for you if you want to:

  • 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.
  • Create icons and shortcut key macros that are of universal benefit.
  • Stop wishing for features Excel doesn’t have: create them yourself.
  • Extract data from external data sources.
  • Have Excel run other programs such as Outlook for emailing.
  • Prevent others making a mess.

Course content overview:

  • Macros introduction         | venues |
    Create a simple macro, create an import application, work with range objects, program the flow, understand objects and variables, create custom functions, handle errors, run macros automatically with events, put controls on a worksheet.
  • Macros next step         | venues |
    Create dialog boxes to avoid user-corrupted input cells, ensure no entries are missed and make input clearer.
    Use ADO to transfer data to and from databases (the example uses an Access database).
    Send emails via Outlook.
    Process data much faster with arrays.
    Include tables and charts into Word.
    Improve your understanding of objects, properties, methods, events, arguments and functions.
    Master the full VBE environment to work productively.
  • Macros advanced         | venues |
    Enhance VBA with Windows API functions such as to prompt for a folder or to wait for an external program to finish.
    Create custom ribbons.
    Create your own objects by use of classes and benefit from ease of code reuse.
    Create advanced dialog boxes.
    Learn conventions and good design for ease of understanding and reliability.
    Discover lots of miscellaneous useful instructions and features.
  • Speed up with macros - introduction 1-day         | venues |
    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.

Course structure:

  • Macros introduction
    Duration: two days. Format: fully hands-on - computers are supplied.
  • Macros next step
    Duration: two days. Format: fully hands-on - computers are supplied.
  • Macros advanced
    Duration: one day. Format: fully hands-on - computers are supplied.

What you get for each course:

  • The best possible advice and training from international company AbleOwl, who have specialised solely in Excel and spreadsheets for over twenty years.
  • Assimilation of good spreadsheet design practices. All AbleOwl courses apply ESP conventions. ESP(Excel Standardisation Programme). That means you will more quickly understand and navigate the workbooks used, whichever AbleOwl courses you attend.
  • A well-written, full-colour, indexed course manual that explains each of the course agenda items in detail.
  • A USB flash drive that contains all spreadsheets covered in the course examples. You can modify the spreadsheets for your own use.
  • A free PDF copy of each of our monthly publications: Instant, In-depth and Visual Basic Excel Sheets. Then, select your preferred magazine and receive a free three-month subscription to it.
  • The GenieMini add-in, to speed up many common tasks and to help apply conventions and good practices.
  • Multiple-place discount: 10% off for three or more places booked on the same course.
  • Refreshments and lunch included in the price.
  • A course certificate upon request.

Who should attend:

  • Macros introduction
    For Excel users new to writing Visual Basic macros and those who have only limited experience of Visual Basic macros.
  • Macros next step
    For those who need to create more advanced and user-friendly applications. This course is suitable for intermediate-level Excel users who have either attended our two-day Macros introduction course or are competent in its agenda items.
  • Macros advanced
    For those who want to complete their VBA knowledge and productively write maintainable and robust applications. This is an advanced-level course suitable for those competent in most of the agenda items covered on the two-day Macros next step course.

Learn in a positive environment



  • 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.

The courses cover Microsoft Excel releases XP(2002) through 2013.
Where there are differences among the covered releases, they are pointed out.


Course cancellation policy:



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.