Excel VBA Data Analysis
for Engineers and Scientists Training

Excel VBA Data Analysis for Engineers and Scientists

Since 1998

Available Onsite Only

About Our Onsites

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

Our Excel VBA data analysis training shows you how to combine VBA with key Excel elements to create powerful data tools that can analyze, organize, visualize, store and fuse engineering and science data.

Questions? 1.805.498.7162   Customers >

What is covered in our Excel VBA data analysis for engineers and scientists.

Our 2-day hands-on live Excel VBA data analysis focuses on how to turn Excel into an adaptive 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 engineering/science data in various worksheet table configurations, filters, colored cells, drawing shapes, pictures and charts.

The key skills learned in our Excel VBA data analysis for engineers and scientists.

Key Excel VBA skills learned:

The skills you need for our Excel VBA data analysis training.

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

Our Excel VBA data analysis for engineers and scientists training syllabus.

Important: We focus our Excel VBA data analysis training on what our customers need. When training begins, we analyze those needs and shift our 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 Excel VBA for Looping Through Workbooks and Worksheets

Data Fusion Purposes in Excel VBA to Control Text Files

Data Fusion Methods in Excel VBA to Control Databases

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

The details about our Microsoft Excel VBA data analysis training.

Excel VBA Fundamentals for Engineers and Scientists Self Study Manual
Learn More >
Excel VBA Fundamentals Self Study
Our full manual is free in our training.

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

Contact us directly through email or phone.

Contact us by form.

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

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2020

EMAGENIT All Rights Reserved