Advanced MS Excel with VBA

DURATION: 16 hours (2 days)


Participants who want to attend this training should have basic knowledge in Microsoft Excel or have basic PC skills.

Course Description

Take your basic Microsoft Excel skills to the next level with this advanced MS Excel with VBA training.  This course takes you on a 2-day instructor-led workshop on the advanced capabilities of Microsoft Excel 2010, 2013 or 2016 with an introduction to VBA Programming concepts. 


At the end of the training, you should have a solid understanding of the more powerful functionalities of Excel to enable you to use it in a business environment.  This course involves examples and exercises led by our premiere Microsoft Excel trainers and practicing data analysts who will leave you with practical tips and tricks that you can use at work on a regular basis. 

Course Objectives

Upon completion of this course, participants will be able to:

  • Work with advanced formulas

  • Work with lookup functions

  • Create data tables

  • Validate cell entries

  • Work with data forms

  • Work with PivotTables

  • Export and import data

  • Query external databases

  • Work with Goal Seek and Solver

  • Work with scenarios

  • Work with views

  • Work with macros

  • Create interactive Web spreadsheets

  • Use Visual Basic Editor

  • Write basic programs in VBA

  • Work with custom dialog boxes

  • Use debugging and error-handling techniques

Who Should Attend

Any professional who uses Microsoft Excel and would like to familiarize themselves with the more advanced tools available to help them with their roles.  Highly recommended for finance executives, marketing analysts, business managers and anyone who would like to advance their MS Excel skills.