Excel VBA Data Analysis for Engineers and Scientists - Live Class

Learn to combine VBA with Excel's data features to develop hi-tech data tools that calculate, visualize, integrate, and report data from multiple sources. Class Examples >

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 focuses on combining key Excel and VBA elements to develop various data tools. It covers the essentials like using VBA to track data ranges; control data formulas; and calculate / lookup data using a variety of functions. Also covered is scanning for data in workbooks and folders and automating Excel's data tools to quickly process and report large datasets.

In addition, it covers how to create reports from various dataset types; fill in forms; and create chart, status, timeline, and summary tables from raw data. Also discussed is how to access text files; process date / times; command databases; create chart reports, and make visual displays using charts, VBA, and shapes.

It even shows how to automatically email reports using VBA and Outlook.

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

What you'll learn in our class.

Excel Picture white
Close Examples
Forward... Forward...

Learn to use Excel VBA and functions to perform lookups, find data, generate report workbooks, and build and format report tables.

Learn to use Excel VBA to track ranges, control formulas, scan datasets for max, mins..., and create movable charts that can be dismissed.

Learn to use VBA to loop through folders and files, consolidate data, build and position charts on a sheet, and save to custom built folders.

Learn to create user interfaces and use VBA to batch process text files, parse dates/times, color chart data points, create limit lines.

Learn to use VBA to control Excel's data tools, use their data, control table columns and rows, fill in data, and build chart control lines.

Learn to use Excel VBA to read irregular data tables, perform interpolation, and fill in premade forms and worksheet templates with data.

Learn to use Excel VBA to read stacked data, load multiple tables into charts as arrays, and interact ActiveX / Charts to create visual displays.

Learn to use VBA, SQL, and ADO to control databases; query workbooks and text files; and import data rapidy to the worksheet.

Learn to combine worksheets, shapes, charts, and Excel VBA to quickly create status and visual displays for your data.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8 Example9
  • Review of the critical Excel VBA language elements and objects used to develop data tools
  • How to track ranges, control formulas, and run data analysis functions in VBA
  • Controlling and scanning folders, workbooks, and worksheets for data with VBA
  • How to build UIs for your data tools using VBA, ActiveX, Data Validation, and the worksheet
  • Combining VBA with Excel's data tools to rapidly process large worksheet datasets
  • Building loops and logic to analyze advanced worksheet data patterns
  • How to shape (insert, delete, moveā€¦ rows/columns) and format worksheet tables
  • Using Excel VBA to create and fill timelines, summary tables, status tables...
  • How to fill forms, lookup data, and interpolate with Excel VBA
  • How to use VBA to process text data and create, write, and modify text files
  • Using VBA, SQL, ADO, and Power Query to integrate database, workbook, and text file data
  • Using VBA to build, format, and layout charts on worksheets (chart reports)

Some key topics we cover in class.

Excel VBA Data Training Topics

4 ways to train.

Virtual Signup
Live Virtual

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

Public Signup
Public In-Person

View the dates, signup, and pricing for our hands-on in-person 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

Tracking Objects

*This section discussed throughout the class when needed

Tracking Data Ranges, Managing Formulas, and Using Functions in VBA

Scanning for Data and Controlling Workbooks / Folders with VBA

Designing Worksheet Interfaces (UIs) for Your Excel Data Tools

Using Excel's Data Tools and VBA to Rapidly Process Worksheet Data

Analyzing Simple and Advanced Worksheet Data Patterns with VBA

 

Day-2

Formatting and Filling Worksheet Tables and Forms with VBA

Controlling Text Files and Processing Text Data with Excel VBA

Using VBA, SQL, and ADO to Query Data and Control Databases

Visualizing Data Using VBA, Charts, and Shapes

Auto Emailing Your Data Reports with Outlook and VBA

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