Microsoft Excel for
Engineers and Scientists Training

Microsoft Excel for Engineers and Scientists

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. Public training will hopefully resume 7/1.

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; processing data; 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

Take a tour of our Microsoft Excel for engineers and scientists.

A Review of Formulas, Debugging and Formatting
Click to expand and take a tour of our Excel essentials training.

Our 1-day hands-on Excel essentials 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 import text files into worksheets and use text functions to process text data on the worksheet. Last it discusses how to build technical charts, how to build Pivot Tables that summarize and organize data, 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.

Review of Excel Formula Construction, Cell Naming and Data Distribution

How to Build Engineering and Science Tables on the Worksheet

Worksheet Function Review for Engineers and Scientists

Key Lookup Worksheet Functions for Engineers and Scientists

Key Logical Worksheet Functions for Engineers and Scientists

How to Summarize and Count Instances in Your Technical Data Based on Logic

How to Use Data Validation and ActiveX to Control Data Entry on a Worksheet

Worksheet Formatting and Form Construction for Engineers and Scientists

How to Import and Analyze Text Files for Engineers and Scientists

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

How to Use Conditional Formatting to Flag Your 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
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