Home > Excel Class Guide > Excel VBA Data Analysis Engr/Sci

Excel VBA Data Analysis for Engineers and Scientists Class

Excel VBA Data Analysis for Engineers and Scientists

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

  • Our 2-day class focuses on combining Excel and VBA elements to calculate, format, organize, and chart various types of data.
  • It shows how to design hi-tech report tools that can scan data stored in multiple folders, databases, text files, and workbooks.
  • Also discussed is how to use VBA to read stacked, non-standard, worksheet and text file datasets.
  • Our class also covers 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 VBA into a rapid data processing system and much more >.

Next Class: 01/25/2023

More Dates >

Black Friday Sale

See the must know topics you will learn.

See What You Master
Close

No time to attend, get a manual instead.

Covers the Excel VBA topics needed to design powerful UI driven data processing, analysis, modeling, and database tools.

  • Contains our complete Excel VBA write-up covering fundamental to advanced Excel VBA topics.
  • Discusses how to create event driven interfaces using VBA, userforms, ActiveX controls, charts, and worksheets
  • Covers key topics including multi-folder / workbook data processing; automated models; controlling databases; and automating Solver / Analysis Toolpak.
  • 1000's of lines of useful code, 100's of real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >
  • Buy a manual now, apply the price towards a class later. Manuals are included with our classes.

Key Excel VBA topics covered in class.

 

Excel VBA Data Analysis Preview

Class examples.

Pricing and class options.

virtual learning

Online Virtual Learning

  • Live, hands-on, talk to the instructor training
  • Bring your own problems to class
  • Online Details >
Dates / Signup >
virtual learning

Public In-Person Learning

  • Live hands-on training
  • Bring your own problems to class
  • We can supply a computer
Dates / Signup >
corporate learning

Onsite Hands-On Learning

  • We come to you and solve your problems
  • We cover in person in the USA and Canada
  • We cover the world virtually using your time zone
Details >

Detailed 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 Syllabus

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

Additional Classes:
Microsoft Excel
for Engineers / Scientists
Excel Data Analysis
for Engineers / Scientists
Excel VBA
for Engineers / Scientists
Excel VBA Data Analysis
for Engineers / Scientists
Advanced Excel VBA Design
for Engineers / Scientists
Mixed Language Programming
with Excel VBA / Fortran
Microsoft Excel for Engineers / Scientists Excel Data Analysis for Engineers / Scientists Excel VBA for Engineers / Scientists Excel VBA Data Analysis for Engineers / Scientists Advanced Excel VBA Design for Engineers / Scientists Mixed Language Programming with Excel VBA and Fortran

Excel VBA skills needed for the class.

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

  • Used Excel VBA in a basic manner before
  • Used Microsoft Excel's data tools manually and know them operationally
  • Formatted worksheets manually and know Excel's basic formatting capabilities
  • Built charts and drawing shapes manually before in Excel
  • Used Excel's worksheet functions like MATCH, COUNTIF, SUMIF, VLOOKUP...

The class details.

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

Contact us by form.

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

Copyright © 2002-2022

EMAGENIT All Rights Reserved