Advanced Microsoft Excel VBA Training

Since 1998

Advanced Microsoft Excel VBA Training for Business Professionals

Business Professionals

Click Dates|Signup
All Dates | Signup

Learn how to build enhanced, powerful, cost effective, data, dashboard and analysis tools for your business.

Our advanced Microsoft Excel VBA training for business professionals shows you how to build sophisticated data processing, data integration, charting and dashboard display tools using VBA along with userforms, ActiveX controls, shapes, charts, Pivot Tables, data sources and Microsoft Excel.

Questions? 1.866.924.6244   Customers >

We cover Excel for Mac.

Learn More >

 Excel for Mac Training

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts

About our advanced Excel VBA training.

[Class Preview Coming in April]

Our 3-day hands-on advanced Microsoft Excel VBA training for business shows you how to build advanced data processing, data integration and dashboard displays in Microsoft Excel using VBA. Our training starts off with a complete review of objects, how to use them in programming and how to design your own objects using Class modules. Next it discusses how to identify and control ranges, cells, worksheets and workbooks using advanced methods that apply to advanced dashboard and data tool design. Our training then dives into how to control the Window's folder and file system and loop through folders looking for various file types. Also covered are advanced VBA data processing techniques for reading complex table arrangements on the worksheet, reading corrupted or irregular data, tracking shifting header positions and automating pivot and query tables. In addition to processing worksheet data, our training also covers how to read and write to text files and databases. After discussing data analysis, our training provides an in depth review of userforms and how to control them along with how to control ActiveX controls on worksheets and userforms using VBA. It then begins the grand finale showing how to bring everything together to build advanced dashboards on worksheets providing a full review of how to use various key events. Last, advanced VBA methods for controlling PowerPoint, Word, Outlook, web pages and interfacing with VB.Net is covered.

Over 20+ years of Excel training experience.
Our Excel training covers what you need to succeed. How do we know? We use the same knowledge to design software for customers like NASA and BMW.
Microsoft Excel Essentials for Engineers and Scientists

The key skills learned in our advanced Microsoft Excel VBA training.

 

Key Excel VBA skills learned:

Did you know you can take this training live online?
Can't make the public event, no problem, we broadcast it as a live, hands-on webinar. Use the All Dates | Signup button above to take the online webinar. Learn more >
Excel Online Webinars

The skills you need for our advanced VBA training.

 

Select this Excel VBA training if you or your group have:

Free repeats with our Excel training.
All of our Excel training comes with Free Repeats. Our Excel classes have a lot to learn in them. Learn more >
Microsoft Excel Training Free Repeats

The topics covered in our advanced Microsoft Excel VBA training.

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

Day-1

Full Excel VBA Language and Object Review

Advanced Excel VBA Methodologies for Controlling Ranges, Data Validation and the Sort/Filter Tools

Controlling Workbooks and Worksheets Using Excel VBA

Using the FileSystemObject, Folders and File Object to Loop Through Workbooks in a Folder

Advanced VBA Methods for Working with Ranges and Imperfect Data

Day-2

Advanced VBA Techniques for Creating and Reading Complex Worksheet Table Patterns

How to Use Excel VBA to Control Text Files

How to Use SQL, ADO and DAO in Excel VBA to Control Databases and Other External Data Sources

Combining Excel VBA, the Shell Object, the FileSystemObject Object and the Windows Registry for File and Folder Management

How to Run VBA Procedures at a Certain Time or by Name

Controlling ActiveX Controls with VBA

Day-3

Developing Advanced Interfaces Using Userforms and Events

Developing Advanced Interfaces Using the Excel Worksheet, Shapes, Pictures and Events

How to Create Advanced Chart Reports Using Excel VBA

Excel VBA Strategies for Controlling Word, PowerPoint, Outlook and the Web

Introduction to Using VB.Net with Excel VBA

Having trouble deciding on a class?
We have a page that can help. Learn more about our classes on our Excel Classes Guide and Skills page. >
Microsoft Excel Essentials for Engineers and Scientists

The details about our advanced Microsoft Excel VBA training.

  • Audience:   Business professionals
  • Duration:   8:30 AM - 4:30 PM
  • # of Days:   3-days
  • Instruction Type:   Hands-on, live, instructor taught training
  • Manual Included:   2200 + page Microsoft Excel Aided Business manual full of Excel tips, how-to-do topics and Excel examples included with the training
  • Excel Versions   2007-2016, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training as many times as you like, no date or limit
  • Personal Examples:   We review our attendees personal examples in our training instruction
  • Available Training Formats:
Advanced Excel VBA Self Study
Learn More >
Advanced Excel VBA Business Self Study
Our full manual is free with our training.

More Training Options

Public / Online Events

Public Events
Schedule / Signup
Beginning Excel Training for Business Professionals Intermediate Excel Training for Business Professionals Advanced Excel Training for Business Professionals Beginning Excel VBA Training for Business Professionals Intermediate Excel VBA Training for Business Professionals Microsoft Excel Dashboard Training for Combined Audience Microsoft Excel-Aided
Business
Upcoming 2018 Excel Public Events Schedule
Beginning Excel Training for Business
Next Date:
See Schedule
Intermediate Excel Training for Business
Next Date:
See Schedule
Advanced Excel Training for Business
Next Date:
See Schedule
Beginning Microsoft Excel VBA Training for Business
Next Date:
See Schedule
Intermediate Microsoft Excel VBA Training for Business
Available Onsite Only
Microsoft Excel Dashboard Training
Next Date:
See Schedule
Microsoft Excel-Aided Business
Available Onsite Only

If you need to contact us about our advanced Excel VBA training.

Contact us directly through email or phone.

Contact us by form.

Click to View Form
Facebook Contact Us Newsletter
Need Help? Please call us at 1.866.924.6244

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved