Microsoft Excel for
Engineers and Scientists

Microsoft Excel for Engineers and Scientists

Since 1998

Next Date: Click Dates|Signup

View 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.805.498.7162   Customers >

The details about our Microsoft Excel 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
  • Full EAE 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. Details >
  • Excel Versions:   2007-2019, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training. Details >
  • Personal Examples:   We review our attendees personal examples in our training instruction
  • Available Training Formats:
Excel-Aided Engineering & Science Self-Study Manual
Learn More >
Excel-Aided Engineering Self Study
Included in our training.
Excel Worksheet Layout
> > > >
< 1 > Delete

Key topics covered in our Microsoft Excel for engineers and scientists.

A Review of Formulas, Debugging and Formatting
Learn How to Use Cell Names, Concatenation and Tables
Learn to Use Functions Like VLOOKUP, IF, SUMIFS and How to Nest
Learn to How to Use Eng/Sci Related Functions and Assemble Models
Learn How to Build Forms and Use Data Validation
Learn How to Create and Use Excel Tables
Learn How to Use Conditional Formatting
Learn How to Use Conditional Formatting with Linked Displays
Learn How to Process Text Files and Use the Text Functions
Learn How to Use AutoFilter, Advanced Filter and Group
Learn How to Build Charts and Use ActiveX Controls
Learn How to Build Pivot Tables and Pivot Charts
Learn About How VBA Macros Work and How to Design Powerful VBA Custom Worksheet Functions

*Click to view. Scroll >>>>

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

More Excel Training Options

Microsoft Excel Data Analysis for
Engineers / Scientists

Syllabus >
Microsoft Excel Data Analysis for Engineers / Scientists
Available Onsite Only

Beginning Excel VBA Training for
Engineers / Scientists

Syllabus / Signup >
Beginning Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule

Intermediate Excel VBA Training for
Engineers / Scientists

Syllabus >
Intermediate Excel VBA Training for Engineers / Scientists
Available Onsite Only

Advanced Excel VBA Training for
Engineers / Scientists

Syllabus / Signup >
Advanced Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule

Microsoft Excel-Aided
Engineering and Science

Syllabus >
Microsoft Excel-Aided Engineering and Science
Available Onsite Only

Interfacing FORTRAN with Excel VBA for Engineers / Scientists

Syllabus >
Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Available Onsite Only

Microsoft Excel Dashboards for
Combined Audience

Syllabus / Signup >
Microsoft Excel Dashboard Training
Next Date:
See Schedule

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

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved