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.