Excel VBA for Engineers and Scientists - Class

Learn the fundamentals of Excel VBA and apply them to automating calculations, models, data processing tasks, and reports.

Next Class: Check Dates

Excel VBA for Engineers and Scientists Training

How our class will boost your Excel VBA skills.

Boost Excel VBA Training

Our 2-day class shows you how to use Excel VBA to build powerful automated engineering and science tools. It covers the basics like how to use modules; the VBA Editor; type and debug VBA code; develop program logic; and use objects, properties, and methods.

Also discussed is how to use VBA to command workbooks, worksheets, charts, PivotTables, and other key Excel elements. Our training also covers how to automate calculations; build report tables; control models; process data; and build custom functions.

Read our detailed outline > below and see what you'll discover in our class.

Take a video tour of what you'll learn.

Video Play
  • Complete review of the Excel VBA language, VBA Editor, debugging,  procedures, and modules
  • Review of common Excel elements that engineers and scientists will want to automate with VBA
  • How to track, read, and write to various range and cell configurations in your Excel VBA code
  • Using Excel and VBA functions in your code to find, calculate, and lookup data
  • Controlling and calculating model and analysis problems with Excel VBA
  • Automating worksheet formula construction and repetitive calculations with Excel VBA
  • How to control workbooks, worksheets, and formats with Excel VBA
  • Using loops and logic to process and calculate worksheet data and text files
  • How to automatically build, fill in, and format report tables with Excel VBA
  • Automating Excel's data tools like Text Wizard, PivotTables, Sort, AutoFilter, Group...
  • Using Excel VBA to automatically build and format engineering and science charts
  • Designing basic user interfaces (UIs) to control your Excel tools
  • Constructing UDFs for calculation, numerical analysis, and data processing

Some key topics we cover in class.

Excel VBA Topics

4 ways to train.

Virtual Signup
Virtual

View the dates and signup for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup
In-Person

View the dates and signup for our hands-on in-person public training.
In-Person Signup >   Learn More >

Manual Information
Manual

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details
Onsite

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

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.
Class PDF

Download Class Brochure

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, Ranges, 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 Rapidly 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 Class Information

Prerequisites for our Excel VBA training.

Class time, manual, and repeats.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved