Advanced Excel VBA Training
for Engineers and Scientists

Advanced Excel VBA for Engineers and Scientists

Since 1998

Next Date: Click Dates|Signup

View All Dates | Signup

Learn how to build advanced dashboard, data analysis, and modeling tools in Excel VBA for engineering and science.

Coupling Excel's worksheets, charts and other built-in features with VBA allows advanced software to be constructed with minimal time and money. Our Excel training gives you the essential knowledge on how to couple these environments to build advanced tools.

Questions? 1.805.498.7162   Customers >

We cover Excel for Mac.

Learn More >

 Excel for Mac Training

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts
Excel Worksheet Layout
> > > >
< 1 > Delete

Key topics covered in our advanced Excel VBA for engineers and scientists.

A Complete Review of VBA Including Procedures, Loops, Logic, Arrays, Variables, Functions, Properties, Methods and Objects
Learn How to Use CreateObject and GetObject to Connect to Other Programs and Libraries in VBA
Learn How to Use VBA to Track and Build Complex Range Configurations, Build Formulas and Apply Formats
Learn How to Control Text Files and Use Advanced String Concatenation in Excel VBA
Learn How to Use Various VBA Loops and Functions to Process, Parse, Filter, Lookup and Correct Data
Learn How to Use VBA to Scan Complex Tables, Irregular Data and Command Folders
Learn How to Use Userforms, ActiveX Controls and Events in VBA
Learn How to Develop Advanced Dashboards and Chart Reports, Use Built-In Dialog Boxes and Use the Windows Registry
Learn How to Use Excel Functions, VBA Functions and Things Like AutoFilter in Advanced Ways in VBA
Learn How to Use ADO, DAO and SQL in VBA to Control Data Sources
Learn How to Integrate VB.Net with Excel VBA
Learn How to Control Word, PowerPoint, Outlook and Web Pages from Excel VBA
Learn How to Build Advanced Models in Excel VBA

Our 3-day hands-on advanced Excel VBA training for scientists and engineers shows you how to build powerful data analysis, data integration, dashboard and modeling tools using Excel VBA. Our VBA training starts off with a complete review of the VBA language where needed, how to use objects in VBA and how to create them using Class modules. Next it discusses advanced command and control of ranges, cells, worksheets and workbooks using Excel VBA, and how these methods can be used to build sophisticated data analysis, modeling and dashboard tools. Using VBA to automate Pivot Tables and queries is also covered.

After covering range control, our training discusses how to read various types of data using advanced loops and logic and how to process, concatenate, clean, parse and replace data using a variety of different worksheet and VBA functions. Our training then explores how to control the file and folder system of Windows and loop through folders looking for various files. Also covered are advanced data processing methods for reading technical data that is arranged in non-standard, adjustable, or stacked formats on the worksheet. Scanning for hard to find data on worksheets such as non-standard, double rowed data headers is also covered. In addition to scanning worksheet data, our VBA training also covers how to read and write to databases and text files integrating their data with information stored on worksheets. Advanced table lookups between worksheets is also covered. Advanced chart reports is also covered.

After discussing data control, our VBA training provides an in depth discussion of how to use and control ActiveX controls on userforms and worksheets using VBA and events. It then shows how to put it all together and design, build and program advanced worksheet dashboards and visual interfaces using cells, charts, ActiveX controls, shapes, pictures and events. Our training also discusses how to build advanced engineering and science models using functions and how to automate Solver and build model batch processing systems. Last, how to control other programs like PowerPoint, Word and interface with other languages like VB.Net, FORTRAN and C is covered.

The skills you need for our advanced Excel VBA training.

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

Our advanced Excel VBA for engineers and scientists training syllabus.

Important: We focus our advanced Excel VBA training on what our customers need. When training begins, we analyze those needs and shift our advanced Excel VBA training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.

Day-1

Full Excel VBA Language, Object and Error Trap Review for Engineers and Scientists

How to Use Excel VBA to Control Complex Ranges, Names and Data Validation in Engineering and Science

Advanced Workbook and Worksheet Control for Scientists and Engineers

Advanced VBA Text File Control Techniques for Engineers and Scientists

Advanced Excel VBA Techniques for Processing and Correcting Engineering and Science Data

Day-2

Analyzing Data in Complex Worksheet Table Patterns and Multiple Workbooks

Windows Registry, Folder and File System Control for Engineers and Scientists

Advanced VBA Methods for Controlling Windows and Excel's Built-In Dialog Boxes

How to Create Advanced Chart Reports Using Excel VBA

Advanced Excel VBA Userform and ActiveX Control Construction Techniques for Engineers and Scientists

Day-3

Advanced Engineering and Science Visual Interface Design on the Excel Worksheet

Advanced Excel VBA Strategies to Control Excel's Advanced Data Features

Using SQL, ADO and DAO in Engineering and Science Programs to Control Data Sources

Using Advanced Excel VBA to Control Other Languages, Programs and Web Pages

Developing Advanced Engineering and Science Models Using Excel VBA

The details about our advanced Microsoft Excel VBA training.

Advanced Excel VBA Self-Study Manual
Learn More >
Advanced Excel VBA Self Study
Our EAE manual is included in our training.

More Excel Training Options

Microsoft Excel for
Engineers / Scientists

Syllabus / Signup >
Microsoft Excel for Engineers / Scientists
Next Date:
See Schedule

Microsoft Excel Data Analysis for
Engineers / Scientists

Syllabus >
Microsoft Excel Data Analysis for Engineers / Scientists
Available Onsite Only

Beginning Excel VBA Training for
Engineers / Scientists

Syllabus / Signup >
Beginning Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule

Intermediate Excel VBA Training for
Engineers / Scientists

Syllabus >
Intermediate Excel VBA Training for Engineers / Scientists
Available Onsite Only

Microsoft Excel-Aided
Engineering and Science

Syllabus >
Microsoft Excel-Aided Engineering and Science
Available Onsite Only

Interfacing FORTRAN with Excel VBA for Engineers / Scientists

Syllabus >
Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Available Onsite Only

Microsoft Excel Dashboards for
Combined Audience

Syllabus / Signup >
Microsoft Excel Dashboard Training
Next Date:
See Schedule

If you need to contact us about our advanced Excel VBA training.

Contact us directly through email or phone.

Contact us by form.

Click to View Form
Facebook Contact Us Newsletter
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved