Excel VBA Data Analysis for Engineers and Scientists

Excel VBA Data Analysis for Engineers and Scientists

Next Class: Check Dates

Turn Excel into a data processing machine and stop wasting days assembling engineering and science reports!

  Learn to design scalable Excel VBA data tools that analyze, format, integrate, chart, and report data from multiple sources, files, and folders.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8

Class overview.

What makes our training different?

Our 2-day class  shows you how to couple Excel's "off-the-shelf" data capabilities with VBA to build adaptive scalable data tools for engineering and science. 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 specific needs.

Onsite Classes Designed for Your Problems

Some key topics we cover in class.

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

Excel Manuals

Class time, duration, manual, and repeats.

Class syllabus and training options.

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

Day-1

Excel VBA Language and Editor Review for Engineers and Scientists (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

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 >

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

Copyright © 2002-2023

EMAGENIT All Rights Reserved