Home > Excel Class Guide > Excel VBA for Engr/Sci

Excel VBA for Engineers / Scientists Class

Excel VBA Fundamentals for Engineers and Scientists Training

Next Class: 8/15/2022

More Dates >

Learn the fundamentals of using Excel VBA to rapidly build analysis, modeling, data processing, and reporting tools for engineering and science.

See What You Master
One click. Problem solved.

How our class can help you.

Our 2-day class shows you how to leverage Excel VBA in engineering and science to build automated tools that solve your problems at the click of a button.

Coupling Excel's "pre-built " features with VBA provides you with a powerful rapid design environment. Automated tools can be made that perform a variety of tasks including automated calculations, formatting data tables, managing models, automating chart reports, and processing large multi-worksheet and workbook data sets.

Join us and our class will show you straight forward, industry proven techniques that will allow you to get your Excel VBA projects up and running with minimal build time.

Free Repeats
Repeat your Excel workshop with us for an entire year for free.
Free Repeats
NASA Project
See how we helped NASA with the Mars Rover using Excel.
We provide discounts to active / retired US Military and DOD.
View our customers like Apple, Boeing, and the US Army.

Key Excel VBA topics covered in class.

Excel VBA Preview

Click to enlarge, scroll < > if hidden.

Detailed class syllabus.

Class Syllabus Dates / Signup

Available: Public >, Virtual >, Onsite >

How we run the class: We focus our Excel VBA class on what our customers need. When class begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two classes are ever the same with EMAGENIT.


Excel VBA Language, VBA Editor, and Debugging Review for Engineers and Scientists (Discussed Where Needed)

Using Functions and Excel VBA to Find, Lookup, and Calculate Worksheet Data

Controlling and Calculating Model and Analysis Problems with Excel VBA

Controlling Workbooks, Worksheets, and Formats with Excel VBA

Processing and Calculating Engineering / Science Data Using Loops and Logic

Using Excel VBA to Control Text Files and Perform Worksheet Text Operations


Using Excel VBA to Generate Engineering / Science Reports on Worksheets

Automating Excel's Data Tools to Process Engineering / Science Data

Scanning for Engineering / Science Data in Workbooks and Worksheets

Excel VBA Chart Automation for Engineers and Scientists

Building Basic User Interfaces (UIs) to Run Your Excel VBA Tools

Designing a Rapid Modeling and Analysis Environment Using UDFs

Additional Classes:
Class Syllabus Dates / Signup

Excel VBA skills needed for the class.

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

  • Never programmed or not programmed in over a year
  • Just used the Record Macro tool to obtain VBA code
  • Programmed but have not used objects before or minimally
  • Used Microsoft Excel and know its operational capabilities
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM
  • Used Excel data processing tools like Sort, Autofilter, Advanced Filter, Group, and Remove Duplicates
  • Have built charts manually

The class details.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

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

You can email us at info@emagenit.com >

Contact us by form.

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

Copyright © 2002-2022

EMAGENIT All Rights Reserved