Advanced Excel VBA for Engineers and Scientists- Class

Learn to command the advanced features of Excel VBA to create powerful interface driven analysis, modeling, data, and visual display tools. Class Examples >

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 combine Excel and VBA elements to create advanced interface driven engineering and science apps.

Our class covers essential app topics like range tracking; using arrays; controlling folders / files; and creating events. Processing complex data patterns, advanced chart automation, and workbook / text file control are also discussed.

In addition, it covers in detail how to create advanced GUIs for your apps using VBA, userforms, ActiveX controls, charts, and other key Excel elements. Advanced model construction; automating trade studies and Solver; database control with ADO; and advanced report automation using Excel's data tools are also covered.

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 process advanced data patterns and automate Excel's Data Features and Analysis Toolpak to build advanced data tools.

Learn to control files, folders, and workbooks; build file pickers; control the Windows Registry; and scan / process data in multiple folders.

Learn to automate advanced charts; compile and load datasets into charts; and combine charts with shapes to build advanced data displays.

Learn to use VBA to create text files; analyze complex text file data sets; process dates /times, and build status displays.

Learn to build advanced interfaces to control your apps using VBA, sheets, charts, ActiveX, shapes, and events.

Learn to design advanced GUIs using VBA, userforms, ActiveX, and events and run them with custom Ribbon controls.

Learn to use Excel VBA to automate advanced modeling tools and Solver, perform trade studies, and build performance charts.

Learn to use Excel VBA and events to build, control, and dimension technical diagrams made from shapes and pictures.

Learn to use advanced interfaces along with SQL, ADO, and VBA to control and query databases, text files, and workbooks.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8 Example9
  • Tracking and creating objects, using various arrays, and running events in VBA
  • Methods of controlling workbooks, files, and folders in an advanced Excel app
  • Advanced report automation using Excel's data tools and the Analysis Toolpak
  • Using loops, logic, functions, and ranges to process complex worksheet data patterns
  • Using Excel VBA to read, write, parse, and output text file data
  • Advanced chart automation (formatting, limit lines, curve fits, combined charts, data labels...)
  • Automating advanced models; model uploads / downloads; UDFs; performing trade studies; automating Solver
  • Constructing advanced worksheet GUIs for your apps using VBA, events, shapes, worksheets, charts, and ActiveX controls
  • Creating advanced GUIs for your apps using VBA; userforms; events; the Ribbon; file / folder pickers; and ActiveX controls
  • How to process engineering / science data in multiple folders, workbooks, and worksheets
  • Using Excel VBA and shapes to build and dimension technical illustrations on the worksheet
  • Status tool design using Excel VBA, worksheets, shapes, and cells
  • Using SQL, ADO, and VBA to control and query databases, text files, and workbooks

Some key topics we cover in class.

Intermediate Excel Training Topics

4 ways to train.

Virtual Signup
Live Virtual

View the dates / signup for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup
Public In-Person

View the dates / signup for our hands-on public training in Nashville, TN.
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

Tracking Ranges, Using Arrays, and Controlling Objects

* Topics below discussed when needed in the class

Advanced Folder, File, and Workbook Control Using Excel VBA

Advanced Report Generation Using Excel's Data Tools and Toolpak

Using Loops, Logic, Functions, and Ranges to Process Complex Data Patterns

Advanced Chart Design and Automation

Creating, Reading, and Parsing Text Files with Excel VBA

Storing Your Program Settings in the Windows Registry

Day-2

Advanced Model Construction, Trade Study, and Solver Automation

Advanced GUI Construction on the Worksheet

Advanced GUI Construction Using Userforms

Searching for Data in Multiple Workbooks, Worksheets, and Folders

Day-3

Technical Diagram Automation Using the Worksheet, Shapes, and VBA

Status Tool Design Using the Worksheet, Shapes, and VBA

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

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