Advanced Excel VBA for Engineers and Scientists- Class

Tap into Excel VBA’s interactive side and develop powerful GUI driven tools for engineering and science.

Next Class: Check Dates

Advanced Excel VBA Methods for Engineers and Scientists Training

How our class will boost your Excel VBA skills.

Boost Excel VBA Training

Our 3-day class shows you how to create advanced GUI based engineering and science tools using Excel and VBA. It focuses on combining key Excel elements, VBA, ActiveX, events, and userforms to develop various GUI based tools.

Engineers and scientists will find these type apps extremely useful in the areas of model control, data processing, and complex problem analysis. Other key topics include file / folder control; multi-source data processing; text file command; dashboards; and automating Solver and the Analysis ToolPak.

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

Take a video tour of what you'll learn.

Video Play
  • Review of the Excel VBA language, VBA Editor, debugging, and objects
  • How to use Excel VBA to control Windows workbooks, files, and folders
  • Advanced model and analysis problem construction integrating trade studies, Solver, and UDFs
  • Advanced report automation using VBA, PivotTables, and Excel's data tools
  • Using loops and logic to process advanced engineering / science data
  • Advanced chart automation covering formatting, limit lines, curve fits, combined charts, and multi-chart layout on the worksheet
  • How to process engineering / science data in folders, multiple workbooks, and on multiple worksheets
  • Constructing advanced UIs using userforms, events, the Ribbon, file / folder pickers, and ActiveX controls
  • Constructing advanced worksheet UIs using VBA, events, shapes, worksheets, cells, Data Validation, and ActiveX controls
  • Constructing advanced engineering / science dashboards using Excel VBA, shapes, pictures, cells, and charts
  • Using Excel VBA to build advanced engineering / science diagrams on the worksheet
  • Using SQL, ADO, and VBA to control and query databases, text files, and workbooks
  • Basics of using Excel VBA to control Word, PowerPoint, and Outlook for report generation purposes

Some key topics we cover in class.

Intermediate Excel Training 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 Object Review (Discussed Where Needed)

Using Excel VBA to Control Folders and Parameter / Data Workbooks

Advanced Model and Analysis Problem Construction, Trade Studies, and Solver Automation

Rapid Report Generation Using Excel's Data Tools and Excel VBA

Using Loops and Logic to Process Advanced Engineering / Science Data

Advanced Engineering / Science Chart Automation

Day-2

Storing Your Program Settings in the Windows Registry

Creating Advanced UIs from Worksheets, Controls, Events, File / Folder Pickers, and Ribbon

Advanced UI Construction Using VBA Userforms, Controls, Events, and Add-Ins

Creating and Reading Engineering / Science Text Files with Excel VBA

Searching for Engineering / Science Data in Workbooks, Worksheets, and Folders

Day-3

Advanced Diagram Automation for Engineers and Scientists

Advanced Excel VBA Dashboard Design for Engineers and Scientists

Advanced Status Tool Design for Engineers and Scientists

Using SQL and ADO to Control Databases, Text files, and Workbooks

Using Excel VBA to Automate PowerPoint, Word, and Outlook

Additional Class Information

Prerequisites for our advanced 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