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

Excel VBA for Engineers and Scientists

Excel VBA Fundamentals for Engineers and Scientists Training

Next Class: 6/20/2022

More Dates >

Explore powerful ways to use Excel VBA to rapidly build analysis, data processing, and reporting tools for engineering and science.

See What You Master
Close
One click. Problem solved.

How our training can help you.

Our 2-day workshop 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 we 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.
NASA
Discounts
We provide discounts to active / retired US Military and DOD.
Discounts
Customers
View our customers like Apple, Boeing, and the US Army.
Customers

Key Excel VBA topics covered.

Excel VBA Preview

Click to enlarge, scroll < > if hidden.

Detailed training syllabus.

Class Syllabus Dates / Signup

Available: Public >, Virtual >, Onsite >

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our 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, 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

Day-2

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 training.

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 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

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