Microsoft Excel for
Engineers and Scientists Training

Since 1998

In Person / Live Online

Next Date: Click Dates|Signup

All Dates | Signup

*Our live, hands-on, instructor led Excel online training is running as scheduled above. Excel in person training will hopefully resume in the near future.

Must know knowledge for assembling powerful, time saving, engineering and science tools in Excel.

Our training shows you how to use Excel to perform common engineering and science tasks like problem analysis; data processing; assembling technical displays, building models; and creating your own custom VBA worksheet functions to solve tough calculations.

Questions? 1.805.498.7162   Customers >

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

About our Microsoft Excel training.

Our 1-day hands-on Excel training for engineers and scientists shows you how to use Excel to solve analysis problems, analyze data, build technical displays, build models and create custom VBA functions to solve tough logic and computational problems. The training starts with a complete review of technical formula construction, formula debugging, cell naming and how to effectively transmit information between worksheets and workbooks. It then discusses how to construct proper tables and use key worksheet functions like IF, VLOOKUP, MAX, SUMIF, COUNTIF, COS, STDDEV.P,... to build formulas that analyze data, calculate models and solve analysis problems. After formulas and tables are discussed, it demonstrates how to build proper worksheet forms and data entry fields using data validation and ActiveX controls. Entering and storing data in a standardized consistent format is the key to developing powerful models and data analysis systems in Excel. It also demonstrates how to use shapes and pictures to develop technical diagrams that dynamically update and how to color cell data dynamically using conditional formatting. Our training also covers how to use text functions to process text data on the worksheet and how to use the date functions as well. Last it discusses how to build technical charts and provides an introduction to Excel VBA macros by demonstrating how to build custom worksheet functions, the ultimate formulas.

The skills you need in our Microsoft Excel for engineers and scientists.

Select this Excel training if you or your group:

Our Microsoft Excel for engineers and scientists training syllabus.

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

Excel Formula Construction, Debugging, Cell Naming and Table Design

Worksheet Interface Design Using Data Validation, ActiveX Controls and Grouping

 How to Construct and Use Worksheet Functions in Formulas

Key Summary, Trig, Text, Date and Lookup Worksheet Functions for Engineers and Scientists

How to Create Logic Based Formulas for use in Engineering and Science Problems

How to Use Conditional Formatting to Create Visual Displays and Flag Data

Worksheet Formatting and Form Construction for Engineers and Scientists

Using the Advance Filter, AutoFilter, Sort and Text Tools on Engineering and Science Data

How to Create Engineering and Science Charts in Excel

How to Create and Use Pivot Tables in Engineering and Science

Introduction to Excel VBA Macros for Engineers and Scientists

The details about our Microsoft Excel training.

Excel-Aided Engineering & Science Self-Study Manual
Learn More >
Excel-Aided Engineering Self Study
Included in our training.

If you need to contact us about our Microsoft Excel training.

Contact us directly through email or phone.

Contact us by form.

Click to View Form
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