Microsoft Excel Essentials Training

Since 1998

Microsoft Excel Essentials for Engineers and Scientists

Engineers and Scientists

Click Dates|Signup
All Dates | Signup

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.866.924.6244   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
Back Forward
> > > >

About our Microsoft Excel essentials training for engineers & scientists.

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.

Over 20+ years of Excel training experience.
Our Excel training covers what you need to succeed. How do we know? We use the same knowledge to design software for customers like NASA and BMW.
Microsoft Excel Essentials for Engineers and Scientists

The key skills learned in our Excel essentials training for engineers & scientists.

Key Excel skills learned:

Did you know you can take this training live online?
Can't make the public event, no problem, we broadcast it as a live, hands-on webinar. Use the All Dates | Signup button above to take the online webinar. Learn more >
Excel Online Webinars

The skills you need for our Microsoft Excel essentials training.

Select this Excel training if you or your group:

Free repeats with our Excel training.
All of our Excel training comes with Free Repeats. Our Excel classes have a lot to learn in them. Learn more >
Microsoft Excel Training Free Repeats

The topics covered in our Microsoft Excel essentials training for engineers & scientists.

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

Having trouble deciding on a class?
We have a page that can help. Learn more about our classes on our Excel Classes Guide and Skills page. >
Microsoft Excel Essentials for Engineers and Scientists

The details about our Microsoft Excel essentials training.

  • Audience:   Engineers, scientists and technicians
  • Duration:   8:30 AM - 4:30 PM
  • # of Days:   1-day
  • Instruction Type:   Hands-on, live, instructor taught training
  • Manual Included:   2200 + page Microsoft Excel Aided Engineering and Science manual full of Excel tips, how-to-do topics and Excel examples included with the training
  • Excel Versions   2007-2016, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training as many times as you like, no date or limit
  • Personal Examples:   We review our attendees personal examples in our training instruction
  • Available Training Formats:
Excel-Aided Engineering & Science Self-Study
Learn More >
Excel-Aided Engineering Self Study
Free with our training.

More Training Options

Public / Online Events

Public Events
Schedule / Signup
Microsoft Excel Data Analysis for Engineers / Scientists Beginning Excel VBA Training for Engineers / Scientists Intermediate Excel VBA Training for Engineers / Scientists Advanced Excel VBA Training for Engineers / Scientists Microsoft Excel Dashboards Training for Combined Audience Microsoft Excel-Aided Engineering and Science Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Upcoming 2018 Excel Public Events Schedule
Microsoft Excel Data Analysis for Engineers / Scientists
Available Onsite Only
Beginning Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule
Intermediate Excel VBA Training for Engineers / Scientists
Available Onsite Only
Advanced Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule
Microsoft Excel Dashboard Training
Next Date:
See Schedule
Microsoft Excel-Aided Engineering and Science
Available Onsite Only
Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Available Onsite Only

If you need to contact us about our Microsoft Excel essentials 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.866.924.6244

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved