Excel VBA Fundamentals for Engineers and Scientists Training

Excel VBA Fundamentals for Engineers and Scientists Training

Engineers and scientists learn to use Excel VBA to automate repetitive calculations, build models, process data, automate charts, and format tables.

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

  • Use the VBA Editor, the Excel VBA language, and debug code.
  • Automate key Excel features and repetitive calculations.
  • Use Excel VBA to control worksheet models and perform technical calculations.
  • Use Excel VBA to track ranges and changing tables.
  • Process data in different worksheets, workbooks, and in text files.
  • Format tables, automate charts, and generate reports.
Play Video
Close

Detailed training syllabus.

Class Syllabus Dates / Signup

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

Visual Basic Editor, Module, and Procedure Review for Engineers and Scientists (Discussed Throughout the Class)

Excel VBA Language Review for Engineers and Scientists (Discussed Throughout the Class)

Using Excel VBA to Automate Calculations and Control Worksheet Models

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

How Engineers and Scientists Can Track, Shape, and Format Tables with Excel VBA

Using Excel VBA to Control Workbooks, Worksheets, and Text Files That Store Data

Day-2

Custom VBA Worksheet Function (UDF's) Design for Engineers and Scientists

Creating Rapid Reporting Tools by Automating Key Excel Data Tools with VBA

How to Scan, Shape, and Calculate Worksheet Data Using VBA Loops and Logic

Scanning for Engineering and Science Data in Multiple Workbooks and Worksheets

Excel VBA Chart Automation for Engineers and Scientists

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