Microsoft Excel Data Analysis

Since 1998

Microsoft Excel Data Analysis for Engineers and Scientists

Engineers and Scientists

Onsite Only
Onsite Details

Explore Microsoft Excel's hidden data analysis capabilities with our Excel training.

Our Excel training focuses on using key worksheet functions and formulas as they apply to data analysis; maximizing the use of Excel's built-in data features, cell flagging tools and charts; and using Excel's data organizational tools like Pivot Tables and Power Query to process data on the worksheet.

Questions? 1.805.498.7162   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 data analysis training for engineers and scientists.

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.

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 data analysis training for engineers and scientists.

Key Excel skills learned:

Did you know you can take similar training live online?
Can't make a public event, no problem, we broadcast them as live, hands-on webinars also. Learn more about how we broadcast >
Excel Online Webinars

The skills you need for our Microsoft Excel data analysis 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 data analysis training.

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

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 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
  • 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 / Onsite

Public Events
Schedule / Signup
Microsoft Excel Essentials Training 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 Essentials Training for Engineers / Scientists
Next Date:
See Schedule
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 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

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved