Advanced Excel VBA Training
for Business Professionals

Advanced Microsoft Excel VBA Training for Business Professionals

Since 1998

Next Date: Click Dates|Signup

View 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.805.498.7162   Customers >

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
  • Full EAB Manual Included:   2200 + page Microsoft Excel Aided Business manual full of Excel tips, how-to-do topics and Excel examples included with the training. Details >
  • Excel Versions:   2007-2019, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training. Details >
  • Personal Examples:   We review our attendees personal examples in our training instruction
  • Available Training Formats:
Advanced Excel VBA Self Study Manual
Learn More >
Advanced Excel VBA Business Self Study
Our full EAB manual is free with our training.
Excel Worksheet Layout
> > > >
< 1 > Delete

Key topics covered in our advanced Excel VBA training.

A Complete Review of VBA Including Procedures, Loops, Logic, Arrays, Variables, Functions, Properties, Methods and Objects
A Complete Review of the Excel VBA Editor and Its Key Features
Learn How to Use CreateObject and GetObject to Connect to Other Programs and Libraries in VBA
Learn How to Use VBA to Build and Control Complex Range Configurations, Build Formulas and Apply Formats
Learn How to Use Various VBA Loops and Functions to Process, Parse, Filter, Lookup and Correct Data
Learn How to Use VBA to Scan Complex Tables, Irregular Data and Command Folders
Learn How to Use Excel Functions, VBA Functions and Things Like AutoFilter in Advanced Ways in VBA
Learn How to Use ADO, DAO and SQL in VBA to Query Databases, Workbooks and Text Files
Learn How to Use Userforms, ActiveX Controls and Events in VBA
Learn How to Develop Advanced Dashboards, Chart Reports, Use Built-In Dialog Boxes, Use the Windows Registry
Learn How to Control Word, PowerPoint, Outlook and Web Pages from Excel VBA
Learn How to Integrate VB.Net with Excel VBA

*Click to view. Scroll >>>>

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 the VBA language, different code modules, objects, properties, methods and how they are all used in programming. Next it discusses how to identify and control complex ranges, hard to find 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, file and registry system and how to loop through folders looking for various data files.

Next it discusses how to read different data configurations using various loops and process, clean, parse, concatenate, and replace data using a variety of different worksheet and VBA functions. Also covered are advanced VBA data processing techniques for reading complex table arrangements on the worksheet, tracking shifting header positions, figuring out table starts and stops, and automating pivot and query tables. In addition, our training also covers how to read and write to text files and control various databases, worksheet tables and text files using ADO, DAO and SQL.

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 both worksheets and userforms using VBA. It then begins the grand finale showing how to bring everything together to build advanced visual interfaces on worksheets while also providing a full review of how to use various key events to make them interactive. Creating advanced chart reports is also covered. Last, advanced VBA methods for controlling PowerPoint, Word, Outlook, web pages and interfacing with VB.Net is covered.

The skills you need for our advanced VBA training.

 

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

Our advanced Microsoft Excel VBA training syllabus.

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 Methods for Controlling Ranges, Names, Formulas and Data Validation

Advanced VBA Methods for Controlling Workbooks and Worksheets

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

Excel VBA Methods for Scanning, Analyzing and Fixing Worksheet Data

Day-2

How to Analyze Complex Worksheet Table Patterns and Data In Multiple Workbooks

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

Day-3

How to Create and Command Userforms and ActiveX Controls

Developing Advanced Interfaces Using the Excel Worksheet, ActiveX Controls, Shapes, Pictures, Ribbon 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

More Excel Training Options

Beginning Excel Training for Business Professionals

Syllabus / Signup >
Beginning Excel Training for Business
Next Date:
See Schedule

Intermediate Excel Training for Business Professionals

Syllabus / Signup >
Intermediate Excel Training for Business
Next Date:
See Schedule

Advanced Excel Training for Business Professionals

Syllabus / Signup >
Advanced Excel Training for Business
Next Date:
See Schedule

Beginning Excel VBA Training for Business Professionals

Syllabus / Signup >
Beginning Microsoft Excel VBA Training for Business
Next Date:
See Schedule

Intermediate Excel VBA Training for Business Professionals

Syllabus >
Intermediate Microsoft Excel VBA Training for Business
Available Onsite Only

Microsoft Excel Dashboard Training for Combined Audience

Syllabus / Signup >
Microsoft Excel Dashboard Training
Next Date:
See Schedule

Microsoft Excel-Aided
Business

Syllabus >
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.805.498.7162

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved