Advanced Excel VBA for Business and Industry - Class

Unleash Excel VBA’s GUI and interactive abilities to create powerful analysis, data, and dashboard apps.

Next Class: Check Dates

Advanced Excel VBA Training

How our class will boost your Excel VBA skills.

Boost Advanced Excel VBA Training

Our 3-day class stresses how to develop VBA powered GUIs to control forms, data tools, models, databases, and reports.

It shows how to combine VBA with userforms, ActiveX controls, worksheets, shapes, charts, and events to produce highly interactive apps.

We also cover advanced data processing; using ADO and SQL; building chart reports; scanning folders for workbooks / text files; and folder / file control.

Also discussed is how to use shapes, pictures, charts, and VBA to develop powerful dashboard tools that display various statuses and KPIs.

Read our detailed outline > below and see everything you'll discover in our class.

Take a video tour of what you'll learn.

Video Play
  • Review of the VBA Editor, Excel VBA language, debugging, and error traps
  • Controlling the Windows folder system to store report and data workbooks
  • Advanced data processing methods using VBA, Excel's data tools, and PivotTables
  • Advanced worksheet data processing and report generation using Excel VBA loops and logic
  • Processing data in multiple folders, multiple workbooks, and on multiple worksheets
  • How to use VBA to build / format charts and layout multiple charts on a worksheet (chart report)
  • Using Excel VBA to create, write, read, parse, and clean text files
  • Creating UIs for your Excel tools using the worksheet, ActiveX controls, Ribbon, and file / folder Pickers
  • Creating UIs for your Excel tools using userforms, ActiveX controls, events, and VBA
  • Creating advanced dashboards on the worksheet using charts, shapes, events, ActiveX controls, and VBA
  • Creating and managing advanced model and analysis problems with Excel VBA
  • Using SQL, ADO, and UIs to query and integrate databases, workbooks, and text files
  • Using VBA to control Outlook emails and Word / PowerPoint for report generation purposes

Some key topics we cover in class.

Advanced Excel VBA Training Topics

4 ways to train.

Virtual Signup

View the dates, signup, and pricing for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup

View the dates, signup, and pricing for our hands-on in-person training.
In-Person Signup >   Learn More >

Manual Information

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.
Class PDF

Download Class Brochure


VBA Editor, Excel VBA Language, and Object Review (Discussed Where Needed)

Advanced Workbook and Folder Control Using Excel VBA

Advanced Report Methods Using VBA, Excel's Data Tools, and PivotTables

Advanced Worksheet Data Processing Using Excel VBA Loops and Logic

VBA Methods for Creating Text Files and Reading Text File Downloads

Searching for Data in Multiple Workbooks, Worksheets, and Folders Using VBA


Advanced Chart Report Generation Using Excel VBA

Using VBA to Store Program Settings in the Windows Registry

Creating Advanced UIs with Worksheets, Controls, Events, File / Folder Pickers, and Ribbon

Developing Advanced UIs Using VBA Userforms, ActiveX Controls, and Events

Assembling Advanced Worksheet Dashboards Using Excel VBA

Constructing Advanced Project Status and Calendar Tools Using Excel VBA


Creating and Managing Advanced Model and Analysis Problems with Excel VBA

Advanced Report Generation Using Excel VBA

Using SQL, ADO, and UIs to Query / Integrate Databases, Workbooks, and Text Files

Report Generation Using Word, PowerPoint, Outlook, and Excel VBA

Additional Class Information

Prerequisites for our class.

Class time, manual, and repeats.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved