Next Class: 5/31/2023
Why rewrite your verified Fortran code in another language? Learn to combine the UI and data abilities of Excel VBA with the speed of Fortran DLLs to create powerful modeling, data processing, and analysis tools.
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
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.
Day-1
Day-2
Day-3
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 >
Excel Training Services
Excel Classes - Business and Industry
- Beginning Excel for Business and Industry
- Intermediate Excel for Business and Industry
- Advanced Excel for Business and Industry
- Excel Dashboards for Business and Industry
- Beginning Excel VBA for Business and Industry
Excel Classes - Engineers / Scientists
- Microsoft Excel for Engineers for Scientists
- Excel Data Analysis for Engineers and Scientists
- Excel VBA for Engineers and Scientists
- Excel VBA Data Analysis for Engineers and Scientists
- Adv Excel VBA Design for Engineers and Scientists
- Calling Fortran DLLs from Excel VBA
Excel Software Design/Consulting
Microsoft Excel Manuals
- Microsoft Excel Solutions Handbook
- Creating Advanced Excel VBA Apps
- Excel VBA Handbook for Engineers and Scientists
- Excel VBA App Design for Engineers and Scientists
EMAGENIT Company Information
US Military
Copyright © 2002-2023
EMAGENIT All Rights Reserved
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.