Excel VBA Data Analysis for Engineers and Scientists - Class

Learn to combine VBA and Excel to develop hi-tech data tools that calculate, visualize, and integrate data from multiple sources.

Next Class: Check Dates

Excel VBA Data Analysis for Engineers and Scientists

How our class will boost your Excel VBA data skills.

Boost Excel VBA Data Training

Our 2-day class shows you how to combine Excel's "off-the-shelf" data capabilities with VBA to build adaptive, scalable 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 worksheet / text file datasets and how to automatically email reports using VBA and Outlook.

Read our detailed outline > below and see what you'll discover in our class.

Take a video tour of what you'll learn.

Video Play
  • Review of the VBA Editor, its debug tools, and the Excel VBA language
  • How to use worksheet and VBA functions in your macro code to analyze and calculate engineering / science data
  • Automating and looping Excel's data tools (PivotTables, AutoFilter, Analysis Toolpak...) for large scale data processing
  • Controlling the Windows folder system with VBA to store reports and read data
  • Building adaptive loops and logic to analyze engineering / science worksheet datasets
  • Using VBA to build, fill-in, shape, format, and calculate various engineering / science report tables
  • How to use Excel VBA to perform various table lookups and interpolation
  • How to use VBA to create, write, and modify text files
  • Using SQL, ADO, and VBA to control and integrate text files, databases, and workbooks
  • Using VBA and Excel's Query Tools to rapidly filter and integrate data
  • Large scale multi-workbook, worksheet, and text file processing using VBA
  • Automating engineering / science chart reports with Excel VBA
  • How to design worksheet-based user interfaces (UIs) to control your data tools and email your reports

Some key topics we cover in class.

Excel VBA Data Training Topics

4 ways to train.

Virtual Signup
Virtual

View the dates and signup for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup
In-Person

View the dates and signup for our hands-on in-person public training.
In-Person Signup >   Learn More >

Manual Information
Manual

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

Onsite Details
Onsite

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

Additional Class Information

Prerequisites for our Excel VBA training.

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