Home > Excel Class Guide > Excel VBA for Engr/Sci
Excel VBA Fundamentals for Engineers and Scientists Training

Excel VBA for Engineers & Scientists

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

  • Live, Hands-On, Industry Topics
  • Bring your problems
  • Limited class size
  • Taught by an engineer
Dates / Sign Up >

Class overview.

Our 2-day class shows you 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.  Key Topics >

Example1 Example2 Example3 Example4 Example5 Example3 Example4 Example5
Winter Sale
Bolt

Key Topics

Bolt

Some key topics we cover in class.

See What You'll Learn!
See What You Master
Close
Bolt

Can't Attend? Get the Manual.

Bolt

Supercharge your Excel projects! Our manual gives you the knowledge to automate calculations, build reports, process data, and build powerful models using Excel VBA.

  • Explains in detail how to use the Excel VBA language and also how to use the VBA Editor, VBA modules, and code debugger.
  • Covers how to control key Excel elements with VBA like workbooks, worksheets, ranges, shapes, formats, functions, and Excel's data tools.
  • Shows how to use Excel VBA to perform tasks like copying and pasting data; automating calculations; creating and formatting reports; filling tables, and building various charts.
  • Covers how to automate illustrations using shapes and build UIs to run your code and models.
  • Buy the manual now and apply its price to a class later. Just let us know when purchasing a class. The manual comes with the class.
See the Manual >
Bolt

Class Syllabus

Bolt
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

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

Bolt

Required Class Skills

Bolt

Select this Excel VBA training if you or your group have:

Bolt

Class Details

Bolt

Duration, #days, and audience details about our class.

Bolt

Contact Us

Bolt

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 >

Click to View Form
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved