Advanced Excel VBA Methods
for Engineers and Scientists Training

Advanced Excel VBA for Engineers and Scientists

Since 1998

Public / Live Online

Next Date: Click Dates|Signup

All Dates | Signup

*Our live, hands-on, instructor led Excel online training is running as scheduled above. Public training resumes on 5/4.

Learn how to use advanced Excel VBA methods to build adaptive, multi-data source, dashboard driven engineering and science tools in Excel.

Combining Excel with advanced VBA methods allows incredibly powerful visual software tools to be rapidly constructed in Excel. Our training will give you the knowledge to build Excel tools that outperform what's on the market today.

Questions? 1.805.498.7162   Customers >

Excel Worksheet Layout
Scroll Picture > > >
< 1 > Delete

Take a tour of our advanced Excel VBA methods for engineers and scientists.

A Complete Review of VBA Including Procedures, Loops, Logic, Arrays, Variables, Functions, Properties, Methods and Objects
Click to expand and take a tour of our advanced Excel VBA methods training.

Our 3-day hands-on advanced Excel VBA methods for scientists and engineers shows you how to build adaptive intelligent 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, reporting, 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 VB.Net is covered.

The skills you need for our advanced Excel VBA methods training.

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

Our advanced Excel VBA methods 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 Excel VBA methods training.

Advanced Excel VBA Methods for Engineers and Scientists Self Study Manual
Learn More >
Advanced Excel VBA Self Study
Our EAE manual is included in our training.

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-2020

EMAGENIT All Rights Reserved