Microsoft Excel Data Analysis
for Engineers and Scientists

Microsoft Excel Data Analysis for Engineers and Scientists

Since 1998

About Our Onsites

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 >

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.
Excel Worksheet Layout
> > > >
< 1 > Delete

Key topics covered in our Microsoft Excel data analysis training.

Data Formula Construction and Debugging, Data Validation, Cell Naming and Tables
Learn How to Use SUMIF, SUMIFS, COUNTIF, COUNTIFS, SUM, MAX, MIN… to Process Data
Learn How to Create Data Processing Formulas Using Key Functions Like IF, VLOOKUP, AND, OR and the Time Functions
Learn How to Use ADDRESS, INDIRECT, MATCH, OFFSET and INDEX to Lock on to Subsets of Data Automatically
Learn to How to Use Array Formulas to Quickly Process Your Data
Learn How to Use Logic in Conditional Formatting to Flag Data
Learn How to Use AutoFilter, Advanced Filter and the Analysis Toolpak
Learn How to Process Text Files and Use the Text Functions
Learn How to Build Engineering and Science Charts
Learn How to Build Engineering and Science Charts Cont.
Learn How to Build Pivot Tables, Pivot Calculations and Pivot Charts
Learn to How to Control Excel Tables and Workbook Ranges Dynamically Linked to External Data Files
Learn to How to Use Power Query and Microsoft Query
Learn How to Dynamically Link Excel to Word and PowerPoint

*Click to view. Scroll >>>>

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

More Excel Training Options

Microsoft Excel for
Engineers / Scientists

Syllabus / Signup >
Microsoft Excel for Engineers / Scientists
Next Date:
See Schedule

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 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