Advanced Microsoft Excel VBA Methods
for Engineers and Scientists Training

Advanced Microsoft Excel VBA Methods for Engineers and Scientists Training
Play Video >

Since 1998

Close

In Person / Live Online

Next Date: Click Dates|Signup

All Dates | Signup

*Our live, hands-on, instructor led Excel online training is running as scheduled above. Excel in person training will hopefully resume in the near future.

Learn how to use advanced Excel VBA to create smart adaptive UI driven data, model, and analysis tools for engineering and science.

Our 3-day hands-on advanced Excel VBA training shows you how to combine VBA with Excel worksheets, shapes, charts, userforms, ActiveX controls, events, Excel's data tools, and databases to build adaptive UI driven data, modeling, and analysis tools.

Questions? 1.805.498.7162   Customers >

Excel Worksheet Layout
Scroll Picture > > >
< 1 > Delete

About our advanced Excel VBA methods training.

Our 3-day hands-on advanced Excel VBA training shows you how to build adaptive, smart, UI driven Excel tools for engineering and science. Key topics include:

The skills you need for our advanced Excel VBA methods training.

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

Our advanced Excel VBA methods for engineers and scientists 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, Object, and Error Trap Review for Engineers and Scientists (Discussed Throughout Class)

Processing and Formatting Advanced Engineering / Science Worksheet Data Sets

How to Use Excel VBA to Search for Engineering / Science Data in Folders

How to Create Advanced Engineering / Science Charts Using Excel VBA

Advanced Model / Analysis Problem Control Using VBA

Day-2

Creating User Interfaces (UI's) With VBA Userforms and ActiveX Controls

Constructing Worksheet Based User Interfaces (UI's) Using Worksheet Events, ActiveX, and Data Validation

Creating Engineering / Science Drawing Programs With Excel VBA

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

Day-3

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

Controlling and Reading Text Files and External Data Sources in Excel VBA

Creating Report Tools Using Excel VBA, PowerPoint, Word, and Outlook

Advanced Custom Worksheet Function Design (UDF) for Engineers and Scientists

Creating Excel Add-Ins for Userform Apps and UDF Rapid Design / Analysis Libraries

The details about our advanced Excel VBA methods training.

Advanced Excel VBA Methods for Engineers and Scientists Self Study Manual
Learn More >
Advanced Excel VBA Self Study
Our EAE manual is included in our training.

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
Contact Us Newsletter
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2020

EMAGENIT All Rights Reserved