Excel VBA Data Analysis for Engineers and Scientists - Class

Stop wasting hours manually assembling engineering and science reports in Excel, do it in seconds. Learn to design scalable Excel VBA data tools that calculate, format, integrate, and chart data from multiple data sources, files, and folders.

Next Class: Check Dates

Excel VBA Data Analysis for Engineers and Scientists

Use VBA to process tough data problems.

Class overview.

Our 2-day class shows you hands-on how to combine Excel's "off-the-shelf" data capabilities with VBA to build adaptive, scalable engineering and science data tools. It focuses on using key Excel / VBA elements together to rapidly calculate, reorganize, format, chart, and report various types of engineering and science data.

It also demonstrates how to create high-powered report tools that process, integrate, and chart data stored in multiple folders, databases, text files, and workbooks.

Also discussed is how to use VBA to read stacked non-standard worksheet / text file datasets and how to automatically email reports to your associates using VBA and Outlook.

Join us and we will show you all you need to know to turn Excel and VBA into a rapid data processing machine that meets your exact needs.

Customers
View Customers >

Some key topics we cover in class.

Newsletter Signup
Newsletter Signup >

Prerequisites for our Excel VBA training.

Class syllabus, training, and price options.

Virtual Signup

View the dates and signup for our hands-on live virtual training.
Virtual Signup: $595.00 >

Public Signup

View the dates and signup for our hands-on in-person public training.
In-Person Signup: $695.00 >

Manual Information

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

How we run the class: 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.
Class PDF

Download Class Brochure

Day-1

Excel VBA Language and Editor Review (Discussed Where Needed)

Using Functions in VBA to Analyze and Calculate Engineering / Science Data

Controlling Workbooks, Worksheets, Folders, and Files with Excel VBA

Automating and Looping Excel's Data Tools for Large Scale Data Processing

Dynamically Shaping and Formatting Engineering / Science Worksheet Tables

Building Loops and Logic to Analyze Complex Engineering / Science Datasets

Using Excel VBA to Build, Fill, and Lookup Data in Engineering / Science Report Tables

Day-2

Controlling and Processing Text Data with Excel VBA

Using VBA, SQL, and ADO to Control / Integrate Database, Workbook, and Text file Data

Filtering and Integrating Data Using VBA and Excel's Query Tools

Large Scale Multi-Workbook, Worksheet, and Text File Processing Using VBA

Building Automated Chart Reports with Excel VBA

Designing Worksheet UIs to Control Your Data Tools and Email Your Reports

Class time, manual, and repeats.

If you need to contact us about our class.

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 >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved