Advanced Excel VBA Training for General Audience

Advanced Microsoft Excel VBA Training
< < < Scroll Picture > > >
Close
Check Onsite > Check Public > Check Online >

Next Class: See Schedule

Play Video Dates / Signup
Class Syllabus

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

Our 3-day hands-on advanced Excel VBA training shows you how to build UI driven data processing, analysis, and dashboard tools by using VBA with worksheets, formulas, Excel's data tools, userforms, ActiveX controls, shapes, charts, events, and databases emphasizing adaptability and upgradeability.

Questions? 1.805.498.7162   Customers >

Free Repeats

Learn More >

Free repeats on our Excel classes

US Military Discounts

Learn More >

EMAGENIT US Military Discounts

Quick look at the training.

Our 3-day hands-on training shows you how to use advanced Excel VBA to create powerful cost saving UI powered data processing, analysis, and dashboard Excel apps. Key topics include:

Excel VBA skills needed.

 

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

Detailed 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

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

Processing and Formatting Advanced Data Sets on the Worksheet Back >

Using VBA to Create Advanced Excel Charts and Chart Report Sheets Back >

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

Advanced Excel VBA Methods for Controlling Reports and Analysis Problems Back >

Day-2

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

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

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

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

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

Day-3

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

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

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

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

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

The training details.

If you need to contact us.

Contact us directly through email or phone.

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