Microsoft Excel VBA Data Analysis
for Engineers and Scientists Training

Excel VBA Data Analysis for Engineers and Scientists
Play Video >

Since 1998

Close

Available Onsite Only

About Our Onsites

Learn how to create adaptive upgradable data tools that process, fuse, and visualize engineering and science data.

Our 2-day hands-on training shows you how to combine VBA with the worksheet, text files, databases, Excel's data tools, charts, shapes, pictures and Windows folder system to create tools that process, organize, visualize, store, and fuse engineering and science data.

Questions? 1.805.498.7162   Customers >

About 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. Key topics include:

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

Excel VBA Language Review and Coding Strategies for Engineers and Scientists (Discussed Throughout Class)

Using Key Functions and the Analysis Toolpak in VBA to Process Engineering / Science Worksheet Data

Using Excel VBA to Process Complex Engineering and Science Data Patterns on the Worksheet

 Using Excel VBA to Build, Fill, and Format Engineering / Science Worksheet Tables

Using Excel VBA to Perform Worksheet Table Lookups and Create PivotTable Reports

Searching Folders, Open Workbooks, and Worksheets for Engineering / Science Data

Day-2

Shaping Engineering / Science Worksheet Tables With Excel VBA

Controlling Engineering / Science Text Files With Excel VBA

Querying Databases, Workbooks, and Text Files with Excel VBA, SQL, and ADO

Visualize Engineering / Science Data Using Excel VBA and Charts

Designing User Interfaces (UI's) on the Worksheet to Control and View Your Data

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