Advanced Excel VBA Training

Advanced Excel VBA Training

Use advanced Excel VBA to create powerful, adaptive, UI powered data processing, analysis, and dashboard Excel apps.

Our hands-on advanced Excel VBA training covers:

  • The VBA Editor, Excel VBA language, debugging, and error traps.
  • Advanced data processing and automation of formulas, forms, and charts.
  • Processing data in multi workbooks, worksheets, text files, and folders.
  • UI construction on worksheets and userforms using ActiveX, events, and shapes.
  • Querying databases, text files, and workbook data using SQL and ADO.
  • Advanced report generation and controlling Word, PowerPoint, and Outlook.
Play Video
Close

Detailed training syllabus.

Class Syllabus Dates / Signup

How we run the class: 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

Excel VBA Language, Object, and Error Trap Review (Discussed Throughout Class)

Processing and Formatting Advanced Data Sets on the Worksheet

Using VBA to Create Advanced Excel Charts and Chart Report Sheets

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

Advanced Excel VBA Methods for Controlling Reports and Analysis Problems

Day-2

Developing Advanced User Interfaces (UI's) With VBA Userforms, ActiveX Controls, Images, and Events

Using the Ribbon, Custom Toolbars, File / Folder Pickers, and the Windows Registry In Your UI's

Developing Advanced Forms and Project Status Tables Using VBA, ActiveX Controls, Data Validation, and Worksheet Events

Creating Gantt Charts and Calendar Style Reports Using Shapes, the Worksheet, ActiveX Controls, and Excel VBA

Combining the Worksheet, ActiveX Controls, and Data Validation With VBA to Construct Automated Dashboards

Day-3

Rapid Data Report Construction by Automating Excel's Data Tools With Excel VBA

How to Use Excel VBA to Control Text Files and Integrate Their Data With Your Excel Tools

How to Use SQL and ADO to Control and Query Data in Databases, Workbooks, and Text Files

Controlling Word, PowerPoint, and Outlook With VBA for Report Generation Purposes

Creating, Packaging, and Distributing Excel Add-Ins for Userform Based Excel Apps

Class Syllabus Dates / Signup
Additonal Classes:

Free Repeats for Our Training

Learn More >

Free repeats on our Excel classes

US Military and DOD Discounts

Learn More >

EMAGENIT US Military Discounts

Excel VBA skills needed for the training.

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

The training details.

If you need to contact us about our training.

Phone Number: 1.805.498.7162

Business Hours: 8:30 - 5:00 PM PT

email: question@emagenit.com

Contact us by form.

Click to View Form
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2021

EMAGENIT All Rights Reserved