Advanced Excel VBA Training

Since 1998

Advanced Excel VBA Training for Engineers and Scientists

Engineers and Scientists

Click Dates|Signup
All Dates | Signup

Learn how to build advanced dashboard, data analysis, and modeling tools in Excel VBA for engineering and science.

Coupling Excel's worksheets, charts and other built-in features with VBA allows advanced software to be constructed with minimal time and money. Our Excel training gives you the essential knowledge on how to couple these environments to build those advanced tools.

Questions? 1.866.924.6244   Customers >

We cover Excel for Mac.

Learn More >

 Excel for Mac Training

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts

About our advanced Excel VBA training for engineers & scientists.

[Class Preview Coming in April]

Our 3-day hands-on live advanced Excel VBA training for scientists and engineers shows you from an engineering and science perspective how to build powerful data analysis, data integration, dashboard and modeling tools using Excel VBA. Our VBA training starts off with a complete review of how to use objects in VBA and how to create them using Class modules. Next it discusses advanced command and control of ranges, cells, worksheets and workbooks using Excel VBA and how these methods can be used to build sophisticated data analysis, modeling and dashboard tools. Using VBA to automate Pivot Tables and queries is also covered. Our training then explores how to control the file and folder system of Windows and loop through folders looking for various files. Also covered are advanced data processing methods for reading technical data this is arranged in non-standard, adjustable, or stacked formats on the worksheet. Scanning for hard to find information such as non-standard, double rowed data headers is also covered. In addition to scanning worksheet data, our VBA training also covers how to read and write to databases and text files integrating their data with information stored on worksheets. Advanced table lookups between worksheets is also covered. After discussing data control, our VBA training provides an in depth review of how to use and control ActiveX controls on userforms and worksheets using VBA and events. It then shows how to put it all together and design, build and program advanced dashboards on worksheets, charts and userforms with a full review of using events that apply to those elements. Last, how to control other programs like PowerPoint, Word and interface with other languages like VB.Net, FORTRAN and C is covered.

Over 20+ years of Excel training experience.
Our Excel training covers what you need to succeed. How do we know? We use the same knowledge to design software for customers like NASA and BMW.
Microsoft Excel Essentials for Engineers and Scientists

The key skills learned in our advanced Excel VBA training for engineers & scientists.

Key Excel VBA skills learned:

Did you know you can take this training live online?
Can't make the public event, no problem, we broadcast it as a live, hands-on webinar. Use the All Dates | Signup button above to take the online webinar. Learn more >
Excel Online Webinars

The skills you need for our advanced Excel VBA training.

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

Free repeats with our Excel training.
All of our Excel training comes with Free Repeats. Our Excel classes have a lot to learn in them. Learn More >
Microsoft Excel Training Free Repeats

The topics covered in our advanced Microsoft Excel VBA training for engineers & scientists.

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

Day-1

Full Advanced Excel VBA Language, Object and Error Trap Review for Engineers and Scientists

Advanced Range Control and Worksheet Formatting for Scientists and Engineers

Advanced Workbook and Worksheet Control for Scientists and Engineers

Advanced Excel VBA Data Processing Techniques for Engineers and Scientists

Day-2

Advanced Excel VBA Data Processing Techniques for Engineers and Scientists (Continued)

Windows Registry, Folder and File System Control for Engineers and Scientists Using Advanced Excel VBA

Advanced VBA Methods for Controlling Windows and Excel's Built-In Dialog Boxes

Advanced Excel VBA Userform and ActiveX Control Construction Techniques for Engineers and Scientists

Day-3

Advanced Engineering and Science Dashboard Design on the Excel Worksheet

Advanced Excel VBA Strategies to Control Excel's Advanced Data Features

Using SQL, ADO and DAO in Engineering and Science Programs to Control Data Sources

Advanced Text File Control Techniques for Engineers and Scientists

Using Advanced Excel VBA to Control Other Languages and Programs

Developing Advanced Engineering and Science Models Using Excel VBA

Having trouble deciding on a class?
We have a page that can help. Learn more about our classes on our Excel Classes Guide and Skills page. >
Microsoft Excel Essentials for Engineers and Scientists

The details about our advanced Microsoft Excel VBA training.

  • Audience:   Engineers, scientists and technicians
  • Duration:   8:30 AM - 4:30 PM
  • # of Days:   3-days
  • Instruction Type:   Hands-on, live, instructor taught training
  • Manual Included:   2200 + page Microsoft Excel Aided Engineering and Science manual full of Excel tips, how-to-do topics and Excel examples included with the training
  • Excel Versions   2007-2016, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training as many times as you like, no date or limit
  • Personal Examples:   We review our attendees personal examples in our training instruction
  • Available Training Formats:
Advanced Excel VBA Self-Study Manual
Learn More >
Advanced Excel VBA Self Study
Our full manual is free in our training.

More Training Options

Public / Online / Onsite

Public Events
Schedule / Signup
Microsoft Excel Data Analysis for Engineers / Scientists Microsoft Excel Essentials Training for Engineers / Scientists Beginning Excel VBA Training for Engineers / Scientists Intermediate Excel VBA Training for Engineers / Scientists Microsoft Excel Dashboards Training for Combined Audience Microsoft Excel-Aided Engineering and Science Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Upcoming 2018 Excel Public Events Schedule
Microsoft Excel Data Analysis for Engineers / Scientists
Available Onsite Only
Microsoft Excel Essentials Training for Engineers / Scientists
Next Date:
See Schedule
Beginning Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule
Intermediate Excel VBA Training for Engineers / Scientists
Available Onsite Only
Microsoft Excel Dashboard Training
Next Date:
See Schedule
Microsoft Excel-Aided Engineering and Science
Available Onsite Only
Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Available Onsite Only

If you need to contact us about our advanced Excel VBA training.

Contact us directly through email or phone.

Contact us by form.

Click to View Form
Facebook Contact Us Newsletter
Need Help? Please call us at 1.866.924.6244

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved