Excel VBA for Engineers and Scientists - Class

Learn the fundamentals of using Excel VBA to perform calculations, control models, analyze data, build charts, and create reports. Class Examples >

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.

In addition to the basics, it discusses how to use VBA to command workbooks, worksheets, ranges, charts, filters, PivotTables... and other key Excel elements. Our training also covers how to automate calculations; build tables; control models; read and fill in forms; process data; and build custom functions.

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

What you'll learn in our class.

Excel Picture white
Close Examples
Forward... Forward...

Learn to use VBA, modules, the debugger, and Excel objects, properties, and methods in your macro code.

Learn to use VBA to command workbooks, create formulas, fill data in tables, and analyze datasets using worksheet functions.

Learn to use Excel VBA to control models, perform calculations, and create custom worksheet functions to rapidly analyze problems.

Learn to use VBA loops and logic to find workbooks, process worksheet data, and create report workbook / worksheets.

Learn to use VBA to read /write to text files, parse and control text, and perform string concatenation.

Learn to use Excel VBA to fill in forms, manage formulas, and perform various table lookups.

Learn to use Excel VBA to control Excel's built-in data features and use them to rapidly create reports.

Learn to use Excel VBA to consolidate chart data, automate chart construction, and format chart elements.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8
  • Review of the Excel VBA language, VBA Editor, debugging,  procedures, and modules
  • Automating common Excel elements used by engineers and scientists in VBA
  • How to track, read, and write to various range and cell configurations in your Excel VBA code
  • Using worksheet and VBA functions in your code to find, calculate, and lookup table data
  • Controlling and calculating model and analysis problems with Excel VBA
  • Automating worksheet formula construction and repetitive calculations with Excel VBA
  • Using loops and logic to process and calculate worksheet data and text files
  • How to control workbooks, worksheets, and formats with Excel VBA
  • How to automatically build, fill, and read forms and tables with Excel VBA
  • Automating Excel's data tools like Text Wizard, PivotTables, Sort, AutoFilter, Group...
  • Using Excel VBA to automatically build / format engineering and science charts
  • Designing basic user interfaces (UIs) to control your Excel tools
  • Constructing UDFs for calculation, numerical analysis, and data processing purposes

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

How to Track Ranges, Run Functions, and Lookup Data in VBA

Calculating Model and Analysis Problems with Excel VBA

Basics of Processing Worksheet Data with Loops and Logic

Controlling Text Data and Text Files in Your VBA Code

Controlling Workbooks, Worksheets, and Formats with VBA

Day-2

Using Excel VBA to Fill, Read, and Consolidate Worksheet Forms

Automating Excel's Data Tools to Rapidly Process Data

Automating Charts with Excel VBA

Building User Interfaces to Run Your Excel VBA Tools

Creating Custom Worksheet Functions (UDFs) in Excel VBA

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