Advanced Excel VBA Design for Engineers and Scientists

Advanced Excel VBA Methods for Engineers and Scientists Training

Next Class: Check Dates

Push Excel to the redline and create hi-tech Excel VBA apps that solve complex engineering and science projects.

  Learn how to use Excel and VBA's extensive GUI capabilities to create powerful interface driven data processing, modeling, and analysis tools in minimal time.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8 Example9 Example10

Class overview.

What makes our training different?

Our 3-day class  shows you how to use Excel and VBA to produce powerful GUI driven tools for engineering and science. It focuses on how to combine the worksheet, ActiveX controls, shapes, pictures, userforms, events, and VBA to develop high-powered UIs that control things like calculations, models, charts, trade studies, and data processing.

Other key topics discussed include controlling folders and files; scanning multiple folders / workbooks for data; text file reading and writing, controlling databases; uploading / downloading / storing problem parameters; running batch file problems; and auto running Solver and the Analysis ToolPak.

Also reviewed is how to use shapes, pictures, charts, and VBA to develop powerful dashboard tools that display various statuses, KPIs, chart data, and technical diagrams. Join us and our class will show you how to push Excel VBA to the redline and create advanced tools that will solve your toughest tasks.

Onsite Classes Designed for Your Problems

Some key topics we cover in class.

Prerequisites for our Excel training.

Excel Manuals

Class time, duration, manual, and repeats.

Class syllabus and training options.

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 Object Review for Engineers and Scientists (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

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

EMAGENIT All Rights Reserved