Advanced Course in VBA Programming for Excel

High-level VBA programming - training contents

Our intensive advanced VBA training for programming Excel teaches you to program advanced applications to automatize reporting and Excel modelling as well as extending Excel features by programming add-ins and functions. This advanced VBA training is intended for participants already familiar with the foundations of VBA, and VBA programmers and developers.

You will learn how to use selected areas of the following Excel VBA features, functions and concepts:

  • Interacting with other Office programs, add-ins and programs through coding VBA macros (Powerpoint, Word, Access, Outlook, Visio, Project, Solver, Autodesk, SAP, ThinkCell)
  • Import and consolidate data from other sources (Excel files, Office, internet, databases)
  • Accessing and importing database data (using ADO and SQL)
  • Accessing Internet websites through code (JSON, XML, etc)
  • Using arrays for quick data manipulation object-oriented programming (creating classes and handling errors)
  • VBA object-oriented programming (destroying objects, default properties, collections)
  • Programming techniques (recursion, optional arguments)
  • Advanced language constructions (by reference, by value, enumeration, types, conversions)
  • Package program code as add-ins for distribution to clients and colleagues
  • Adding menu controls
  • Automate pivot tables and chart production
  • Automate Power Pivot and Power Query
  • Excel VBA coding best practices
  • Handling different operating system and Excel versions, Windows API calls
  • Saving to cloud services (Dropbox, Drive, OneDrive) and as PDF documents
  • Sandboxing of files in Apple Mac Excel 2013/2016+ and AppleScript calls

We can also aid you in finding answers to specific questions, explore areas of particular interest and delve into VBA-related problems.