Building & Deploying Add-ins Master Class

A master class from the Financial Analysis VBA Certificate Master Class series

An Extension of Australia’s premier Excel VBA course for finance professionals

This one-day master class builds on earlier training, especially on the Ribbon, Context Menus & Handling Events Master Class, to demonstrate how to effectively deploy add-ins within an organisation that add custom functions, standard tools and automation.

Course Content

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Modes of Study

  • In class mode: 8 hours on a single day.
  • Public offerings starting in Sydney in 2016.
  • Private offerings also available.

Prerequisite Master Class

  • Master Class 3: Ribbon, Menus and Handling Events is a pre-requisite for attendance at this master class. This is to avoid the duplication of the ribbon and context menu customisation content covered therein.

Key Outcomes

  • Gain advanced skills in key subject areas, such as creating custom functions to extend Excel;
  • Limitations on custom functions;
  • Optimising custom functions;
  • Adding tools to automate and simplify complex tasks;
  • Storage of user and application settings: registry versus add-in workbook;
  • Responding to key Workbook and Worksheet events, key Add-In events;
  • Document level and application level Ribbon customisations;
  • Deployment and installation of your add-in;
  • Up to 8 hours of continuing professional education.

Each Master Class Delivers

  • Core knowledge for the specialised subject area;
  • Re-usable examples demonstrating proven methodologies;
  • Guidance on how to avoid real-world issues and problems; and
  • Advanced techniques to build powerful and robust solutions without needless complexity.

Who Benefits

Those who have previously completed the Financial Analysis VBA Certificate or Financial Analysis Systems Certificate looking for support & guidance to extend their knowledge in building robust tools for deployment within a workgroup or organisation.

Benefits for the Employer

  • A reduction in the effort required by staff to expand into key advanced topics;
  • Access to proven and effective strategies for advanced application and code building; and
  • A development path for key staff involved in creation of automated processes within an organisation.

Detailed Course Outline & Other Information

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Downloadable course brochure with detailed course outline in PDF format (93kb).

Find a suitable course by reviewing the article Which Course Would Best Suit me?

Find an offering in the Course Calendar.