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 fast.
  • Covers essential topics like modules; the VBA Editor; debugging; objects, properties, and methods; and how to type and use Excel VBA.
  • Other Excel VBA topics include automating calculations; controlling workbooks / worksheets; formatting; and basic modeling.
  • Also discussed is automating chart reports; processing worksheet / text file data; and how to design programs and their interfaces.
  • Join us and our class will show you industry proven Excel VBA design methods, design strategies, and much more >.

Next Class: 12/19/2022

More Dates >

Black Friday Sale

See the must know topics you will learn.

See What You Master
Close

No time to attend, get a manual instead.

Covers how to use Excel VBA to perform essential tasks like automated calculations, data processing, charting, and reporting.

  • Explains in detail how to use the Excel VBA language, VBA Editor, and VBA modules and perform code debugging.
  • 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 / pasting data; automating calculations; creating / formatting reports; and building charts.
  • 1000's of lines of useful code, over 100 real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >
  • Buy a manual now, apply the price towards a class later. Manuals are included with our classes.

Key Excel VBA topics covered in class.

Excel VBA Preview

Class examples.

Pricing and class options.

virtual learning

Online Virtual Learning

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

Public In-Person Learning

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