International experts in Excel

These courses are for you if you want to:

• Complete tasks faster by automating them.
• Make it easier for others to use your spreadsheet.
• 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 formulae 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 |
  Review objects, properties and methods, work productively in VBE, learn debugging techniques, know correct range object techniques, build custom dialog boxes, automatically display custom toolbars, discover more events, run other programs, know data types and scope, learn various useful features.
• Macros advanced         | venues |
  Digitally sign projects, use Windows API functions, discover more about forms and controls, protect applications from corruption, employ user-defined data types, build reusable libraries with classes, create a Windows help file, have a macro place controls on a worksheet, discover yet more event procedures, learn more debugging techniques, write code to edit code, learn various useful macros, design well.

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.
• FREE and UNLIMITED email hotline support for twelve months following each course.
• A free 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.
• 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 introductory course or are competent in its agenda items.
• Macros advanced
  For those wanting 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.