Home > Excel Class Guide > Excel VBA for Engr/Sci

Excel VBA for Engineers / Scientists Class

Excel VBA Fundamentals for Engineers and Scientists Training

Learn the fundamentals of using Excel VBA to automate calculations; perform data processing; model; and create rapid reporting tools.

Our 2-day class shows you how to leverage Excel VBA to build automated tools that solve multi-step problems at the click of a button.

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

Next Class: 10/24/2022

More Dates >

See What You Master
Close
Solve problems with a click.
Free Repeats
Repeat your Excel workshop with us for an entire year for free.
Free Repeats
NASA Project
See how we helped NASA with the Mars Rover using Excel.
NASA
Discounts
We provide discounts to active / retired US Military and DOD.
Discounts
Customers
View our customers like Apple, Boeing, and the US Army.
Customers

Key Excel VBA topics covered in class.

Excel VBA Preview

Click to enlarge, scroll < > if hidden.

Pricing and class options.

virtual learning

Online Virtual Learning

  • Price: $595.00
  • Live, hands-on, talk to the instructor training
  • Bring your own problems to class
  • Online Details >
Dates / Signup >
virtual learning

Public In-Person Learning

  • Price: $695.00
  • Live hands-on training
  • Bring your own problems to class
  • We can supply a computer
Dates / Signup >
corporate learning

Onsite Hands-On Learning

  • We come to you and solve your problems
  • We cover in person in the USA and Canada
  • We cover the world virtually using your time zone
Details >

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

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

Additional Classes:
Microsoft Excel
for Engineers / Scientists
Excel Data Analysis
for Engineers / Scientists
Excel VBA
for Engineers / Scientists
Excel VBA Data Analysis
for Engineers / Scientists
Advanced Excel VBA Design
for Engineers / Scientists
Mixed Langauge Programming
with Excel VBA / Fortran
Microsoft Excel for Engineers / Scientists Excel Data Analysis for Engineers / Scientists Excel VBA for Engineers / Scientists Excel VBA Data Analysis for Engineers / Scientists Advanced Excel VBA Design for Engineers / Scientists Mixed Language Programming with Excel VBA and Fortran

Excel VBA skills needed for the class.

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

  • Never programmed or not programmed in over a year
  • Just used the Record Macro tool to obtain VBA code
  • Programmed but have not used objects before or minimally
  • Used Microsoft Excel and know its operational capabilities
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM
  • Used Excel data processing tools like Sort, Autofilter, Advanced Filter, Group, and Remove Duplicates
  • Have built charts manually

The class details.

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 >

Contact us by form.

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

Copyright © 2002-2022

EMAGENIT All Rights Reserved