Home > Excel Class Guide > Adv Excel VBA Design Engr/Sci

Advanced Excel VBA Design for Engineers / Scientists Class

Advanced Excel VBA Methods for Engineers and Scientists Training

Next Class: 8/17/2022

More Dates >

Learn about Excel VBA's interface capabilities and create powerful UI driven data processing, modeling, and analysis tools for engineering and science.

See What You Master
Close
Push your Excel VBA skills to the redline.

How our class can help you.

Our 3-day class shows you how to use Excel and VBA to produce hi-tech UI based tools for engineering and science. Excel and VBA have amazing "off the shelf" user interface elements that can be rapidly employed to help solve technical problems.

Coupling Excel's UI features with VBA's ability to control calculations, data, charts, databases, workbooks, userforms... allows a host of high-powered tools to be developed.

Possibilities include model tools that upload data, run Solver, perform trade studies, and then carpet plot it all or data processing tools that scan folders, analyze 100's of workbooks, chart their data, and then email the report. Amazing visual tools can also developed that display various statuses, chart data, draw diagrams, hide and show pictures...etc.

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.

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 advanced Excel VBA topics covered in class.

Advanced Excel VBA Preview

Click to enlarge, scroll < > if hidden.

Detailed class syllabus.

Class Syllabus Dates / Signup

Available: Public >, Virtual >, Onsite >

How we run the class: We focus our Excel VBA class on what our customers need. When class begins, we analyze those needs and shift our outline appropriately. We will stress topics or add topics that our customers want. No two classes are ever the same with EMAGENIT.

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

Additional Classes:
Class Syllabus Dates / Signup

Excel VBA skills needed for the class.

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

  • Used the Excel VBA language in a basic capacity
  • Used variables, loops, and logic before and know how they basically operate
  • Used objects, properties and methods before in code to control a program
  • Used Excel drawing shapes and built charts manually
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM, Match, COUNTIF, COUNTA...
  • Used Excel's data processing tools like Autofilter, Sort, Remove Duplicates, and PivotTables

The class details.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: 8:30 - 5:00 PM PT

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