Microsoft Excel Data Analysis
for Engineers and Scientists Training

Microsoft Excel Data Analysis for Engineers and Scientists

Since 1998

Next Date: Click Dates|Signup

View All Dates | Signup

Learn how to use Excel's data tools, charts, worksheet functions, formulas and array formulas to supercharge your Excel data analysis tasks.

Our Excel data training focuses on using key worksheet functions, formulas and array formulas to process data; maximizing the use of Excel's data features, cell flagging tools and charts; and using Pivot Tables and Power Query to process and integrate technical data on the worksheet.

Questions? 1.805.498.7162   Customers >

Excel Worksheet Layout
> > > >
< 1 > Delete

Take a tour of our Microsoft Excel data analysis training.

Data Formula Construction and Debugging, Data Validation, Cell Naming and Tables
Click to expand and take a tour of our Excel data analysis training.

Our 1-day Excel data analysis training will show you how to effectively use Excel to process engineering and scientific data. Key topics include using data validation to control worksheet input, conditional formatting to dynamically color cell data based on logic, cell and range names and Excel tables to track data, using key functions like VLOOKUP, MATCH, COUNTIF, SUMIF and IF in data analysis formulas; using array formulas and logic to process data; organizing and storing data on the worksheet; analyzing worksheet data with various Excel data tools; building charts; pre-processing worksheet data and working with text files; and linking Excel to other programs like Word and PowerPoint for reporting purposes. Also discussed is how to use Pivot Tables and Power Query to manipulate and filter data.

The skills you need for our Microsoft Excel data analysis training.

Select this Excel training if you or your group:

Our Microsoft Excel data analysis training syllabus.

Important: 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 Formula Design, Debugging, Cell Naming, Cell Formats, Data Validation and Sheet Linking

How to Build Proper Engineering and Science Tables on the Worksheet

Excel Worksheet Function Operation, Argument Lists and Nesting for Engineers and Scientists

Looking Up and Merging Engineering and Science Worksheet Table Data

Logic Overview, Condition Construction and Key Logic Worksheet Functions for Engineers and Scientists

How to Summarize and Count Worksheet Data Instances in Engineering and Science Data

How to Use Array Formulas and Dynamic Names to Help Analyze Engineering and Science Data

Must Know Text Processing Techniques for Engineers and Scientists

Using the Advance Filter, AutoFilter and Analysis Toolpak on Engineering and Science Data

Using Conditional Formatting to Flag Your Engineering and Science Data

Creating Engineering and Science Charts

How to Create Pivot Tables and Pivot Charts on the Worksheet

Using Power Query and Microsoft Query to Access External Engineering and Science Data

Linking Excel with Word and PowerPoint

The details about our Microsoft Excel data analysis 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
Learn More >
Excel-Aided Engineering Self Study
Included in our training.

If you need to contact us about our Microsoft Excel data analysis 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