Excel VBA for Engineers and Scientists - Class

Solve multi-step engineering and science problems with the click of a button. Learn the fundamentals of using Excel VBA to automate calculations; perform data processing; model; and create rapid reporting tools.

Next Class: Check Dates

Excel VBA Fundamentals for Engineers and Scientists Training

Bring the power of VBA to your problems.

Class overview.

Our 2-day class shows you hands-on how to leverage Excel VBA to build automated engineering and science tools that solve multi-step problems fast.

It covers essential topics like how to debug and use modules; how to use and type the VBA language; how to design programs; and how to use objects, properties, and methods in VBA to command key Excel elements.

Also discussed is how to perform a variety of key tasks with Excel VBA including automating calculations; controlling workbooks; building, formatting, and reorganizing tables; basic model control; automating chart reports; and processing worksheet / text file data.

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

Customers
View Customers >

Some key topics we cover in class.

Newsletter Signup
Newsletter Signup >

Prerequisites for our Excel VBA training.

Class syllabus, training, and price options.

Virtual Signup

View the dates and signup for our hands-on live virtual training.
Virtual Signup: $595.00 >

Public Signup

View the dates and signup for our hands-on in-person public training.
In-Person Signup: $695.00 >

Manual Information

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

Onsite Details

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

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