Advanced Excel VBA Methods for Engineers and Scientists Training

Advanced Excel VBA Methods for Engineers and Scientists Training

Engineers and scientists learn to rapidly create adaptive, scalable, UI based Excel VBA tools for modeling, data processing, and database communication.

Our hands-on advanced Excel VBA training shows in-depth how to:

  • Use the VBA Editor, Excel VBA language, and debug tools to create advanced apps.
  • Use Excel VBA to create advanced models, trade studies, and automate Solver.
  • Perform multi workbook, worksheet, text file, and folder data processing.
  • Construct UI's using events, shapes, worksheets, userforms, ActiveX, and the Ribbon.
  • Use SQL and ADO to control and query databases, text files, and workbooks.
  • Automate advanced chart construction and data reports.
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

Full Excel VBA Language, Object, and Error Trap Review for Engineers and Scientists (Discussed Throughout Class)

Processing Complex Worksheet Data Patterns and Outputting to Different Worksheets / Workbooks

Searching for Data in Folders, Workbooks, and Worksheets Then Processing It

Excel Chart Automation and Report Workbook Generation

How to Use Excel VBA to Control Models, Analysis Problems, Trade Studies, and Solver

Day-2

Advanced User Interface (UI) Construction Using VBA Userforms, ActiveX, and Events

Advanced Worksheet Based User Interface (UI) Construction Using ActiveX, Events, and Cells

Automating Technical Illustrations on the Worksheet Using Excel VBA

Using the Ribbon, Custom Toolbars, File / Folder Pickers, and the Windows Registry in Advanced Excel UI's

Day-3

Automating Excel's Data Tools with Excel VBA (Rapid Report Generation)

Using SQL, ADO, and VBA to Control and Query Databases, Text files, and Workbooks

How to Create Advanced Report Tools Using Excel VBA, PowerPoint, Word, and Outlook

Advanced Custom Worksheet Function (UDF) Design for Models and Analysis Problems

Excel Add-In Design for Userform Based Apps and UDF Design / Analysis Libraries

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