Intermediate Microsoft Excel VBA Training

Since 1998

Intermediate Excel VBA Training for Engineers and Scientists

Engineers and Scientists

Onsite Only
Onsite Details

Learn how to create innovative data analysis, data fusion and data visualization tools for engineering and science.

Our intermediate Excel VBA training for engineers and scientists shows you how to use various Excel visual elements in unique ways coupled with VBA to create powerful data analysis tools that can compile, visualize and integrate data at the click of a button.

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 intermediate Excel VBA training for engineers & scientists.

Our 2-day hands-on live intermediate Excel VBA training for engineers and scientists focuses on how to turn Excel into an innovative data processing, data fusion and data visualization tool for engineering and science data. Our Excel VBA training starts off with showing you unique ways to control Excel cells, ranges and data tools in Excel VBA and how these elements can be used together to create high end data fusion and data analysis tools. Our Excel VBA training then focuses on how to use various loops, Excel worksheet/VBA functions, arrays and logical techniques to analyze technical data with a focus on reading unconventional worksheet data layouts, re-sizing moving data areas and locating hard to find information on a worksheet. Our training then discusses sophisticated data fusion techniques using VBA loops and logic to sift through data in multiple workbooks and worksheets from multiple folders. The data fusion discussion also covers methods for reading and writing to text files and databases and fusing that information together. Also covered is various data visualization methods showing how to use Excel VBA to visualize your collected engineering/science data in various worksheet table configurations, colored cells, drawing shapes, pictures and charts.

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 intermediate 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 intermediate 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 intermediate Microsoft Excel VBA training for engineers & scientists.

Important: We focus our intermediate Excel VBA training on what our customers need. When training begins, we analyze those needs and shift our intermediate 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

Using Objects in Excel VBA

Review of Key Excel Worksheet and VBA Functions Commonly Used in Data Fusion, Data Analysis and Data Visualization

Key Methods for Tracking Excel Ranges in Your VBA Code for Data Fusion, Data Analysis and Data Visualization Purposes

Using Excel VBA to Control Key Excel Operations and Tools Vital to Data Fusion, Data Analysis and Data Visualization

Methods for Using VBA Arrays and For...Next Loops to Perform Advanced Data Analysis

Day-2

Controlling the Windows Folder and File Systems, Registry; and Other Programs Using VBA

 Data Fusion Methods in VBA for Looping Through Workbooks and Worksheets

Data Fusion Purposes in VBA to Control Text Files

Data Fusion Methods in VBA to Control Databases

How to Assemble and Use Excel VBA to Control Charts, Drawing Shapes and the Worksheet for Data Visualization Purposes

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 intermediate Microsoft Excel VBA training.

  • Audience:   Engineers, scientists and technicians
  • Duration:   8:30 AM - 4:30 PM
  • # of Days:   2-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:
Beginning / Intermediate Excel VBA Self-Study Manual
Learn More >
Beginning/Intermediate 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 Advanced 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
Advanced Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule
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 intermediate 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