Microsoft Excel Engineering and Science Classes

About our Excel engineering and science classes.

For almost 3 decades, we have been training engineers and scientists on how to use Excel's full capabilities to construct tools and solve a wide variety of problems.
Our Excel training is always taught live and hands-on; you can attend in person or virtually over the web. All Training Options >
Our training is highly dynamic, we do not use manuals, and focus on what problems our customers are trying to solve. We work their problems into our class syllabus.
Our Excel engineering and science training is divided into two Excel groups: general Excel training (no VBA macros) and Excel VBA training (macros).

Some key topics covered in our Excel classes.

Our Excel classes below cover a wide range of general Excel and VBA topics that are useful for all fields of engineering and science.
They cover vital Excel worksheet topics like formatting, problem layout, formula construction, logic, functions, charts, and data filtering for starters. They show how to apply functions and formulas to data processing, technical calculations, numerical analysis, and statistics.
In addition, our general Excel training also covers worksheet topics like conditional formatting, Excel tables, array formulas, spill arrays, PivotTables, Power Query, dashboards, and report automation.
Once Excel's tools and formulas are not enough to solve the problem, our training shows how to use Excel VBA to automate repetitive technical tasks and calculate problems in Excel.
Our VBA training also shows how to use Excel VBA to process data, create charts, automate reports, scan files and folders, or create high-powered apps.

About the picture: In the Excel picture, parameters and formulas are used to calculate various I-beam outputs. Cell names, Data Validation, charts, and shapes are used to create the dynamic interface. Also pictured is a solar cell chart that displays current and power along with various critical points. The graphic also shows XLOOKUP functions and Excel tables being used to rapidly calculate the energy to melt a selected substance.

General Excel Training

Microsoft Excel Essentials
for Engineers and Scientists

1-day. Learn to harness Excel's powerful calculation, charting, data, and interface abilities to build problem solving tools. Includes custom LAMBDA function discussion.

Excel Data Analysis
for Engineers and Scientists

1-day. Learn to harness Excel’s calculation, data analysis, and reporting abilities to solve problems using formulas, functions, charts, filters, shapes, and PivotTables.

Microsoft Excel for Engineers and Scientists

Prerequisites > Class Examples >

Learn More >

Excel Data Analysis for Engineers Scientists

Prerequisites > Class Examples >

Learn More >

4 ways to train with us.

Live Virtual

We can train you live, hands-on virtually over the web.

Live In-Person

We can train you in person, hands-on at a public class.

Business Onsite

We can train your business live in-person or virtually anywhere.

Self-Study Manual

Buy a self-study manual, apply the price later to a class >.

Excel VBA Macro Training

Excel VBA Fundamentals
for Engineers and Scientists

2-days. Learn the fundamentals of using Excel VBA to perform calculations, control models, analyze data, build charts, and create reports.

Excel VBA Data Analysis
for Engineers and Scientists

2-days. 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.

Advanced Excel VBA
for Engineers and Scientists

3-days. Learn to command the advanced features of Excel VBA to create powerful analysis, modeling, data, and visual display tools.

Running Fortran from Excel VBA
for Engineers and Scientists

3-days. Learn to combine the speed of Fortran with the GUI, charting, modeling, and data processing capabilities of Excel VBA to create lightning-fast tools.

Prerequisites > Class Examples >

Learn More >

Prerequisites > Class Examples >

Learn More >

Advanced Excel VBA for Engineers Scientists

Prerequisites > Class Examples >

Learn More >

Running Fortran from Excel VBA for Engineers Scientists

Prerequisites > Class Examples >

Learn More >

You can do amazing things with workbooks, VBA, and imagination.

About the picture: In the Excel picture, 5 workbooks are linked and used to create a drone model, Excel VBA manages it, and Solver optimizes. VBA UDFs and Fortran do the calculations. Also pictured is a simple VBA program that tracks selected experiments from two files and displays their status, due date, and the # of days past due. Also pictured is a VBA charting add-in that scans hundreds of download workbooks, creates a report workbook, charts selected parameters, and emails the report. The take away from this example is complex processes, models, and displays can be rapidly developed in Excel VBA at low cost and time.

Excel Training Services

Excel Public Training

Excel Virtual Training

Excel Onsite Training

Excel Self-Study Manuals

Excel Classes - Business and Industry

Beginning Excel for Business and Industry

Intermediate Excel for Business and Industry

Advanced Excel for Business and Industry

Excel Dashboards for Business and Industry

Beginning Excel VBA for Business and Industry

Excel VBA Data Processing for Business and Industry