Home > Excel Class Guide > Excel Data Analysis Engr/Sci

Excel Data Analysis for Engineers / Scientists Class

Microsoft Excel Data Analysis for Engineers and Scientists Training

Learn to combine Excel's external querying abilities, functions, and data tools to integrate / analyze data and build automated reports.

  • Our 1-day class shows you how to control Excel's data tools, functions, and charts and use them to rapidly process and visualize your data.
  • It covers essential topics like how to use functions, logic, charts, PivotTables, and various data filters to process your data.
  • Also discussed are unique topics like how to combine text values, parse date-times like milliseconds, curve fit chart data, and build array formulas to analyze complex datasets.
  • You'll also discover how to use Power Query and Excel tables to build automated reports that import data, shape it, calculate it, and chart it.
  • Join us and our class will show you how to combine Excel's data elements into time saving tools and much more >.

Next Class: 12/10/2022

More Dates >

Black Friday Sale

See the must know topics you will learn.

See What You Master
Close

No time to attend, get a manual instead.

Our "all-in-one" Excel manual covers the Excel and VBA topics needed to build powerful model, analysis, optimization, and data tools.

  • Includes our full Microsoft Excel and Excel VBA macro write-up. It is everything we have rolled into one manual, basically all the above manuals.
  • Covers the Excel topics needed to perform tasks like data processing, automated reporting, modeling, numerical analysis, design optimization, and dashboard design.
  • Includes our complete Excel VBA write-up that shows you how to build automated calculations; models; data processing tools; advanced UIs; and database tools.
  • 100's real world examples and 1000's of lines of useful VBA code included. Learn More >
  • Buy a manual now, apply the price towards a class later. Manuals are included with our classes.

Key Excel topics covered in class.

Excel Data Analysis Preview

Class examples.

Pricing and class options.

virtual learning

Online Virtual Learning

  • Live, hands-on, talk to the instructor training
  • Bring your own problems to class
  • Online Details >
Dates / Signup >
virtual learning

Public In-Person Learning

  • Live hands-on training
  • Bring your own problems to class
  • We can supply a computer
Dates / Signup >
corporate learning

Onsite Hands-On Learning

  • We come to you and solve your problems
  • We cover in person in the USA and Canada
  • We cover the world virtually using your time zone
Details >

Detailed class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.
Class Syllabus

Data Analysis Problem Construction on the Worksheet

Building Tables, Filtering / Sorting Data, and Using the Analysis Toolpak

Using Conditional Formatting / Data Validation to Flag and Control Data

Chart Design, Curve Fitting, and Controlling Chart Views with Slicers

Creating and Using Key Worksheet Functions to Analyze Data

Looking Up Data in Worksheet Tables 

Importing Text Files and Analyzing Worksheet Text Data with Functions

Using Logic to Summarize, Count, and Analyze Worksheet Data

Using PivotTables to Analyze Engineering and Science Data

Using Array Formulas to Analyze Complex Engineering and Science Data Patterns

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

Linking Excel with Word and PowerPoint to Build Dynamic Reports

Additional Classes:
Microsoft Excel
for Engineers / Scientists
Excel Data Analysis
for Engineers / Scientists
Excel VBA
for Engineers / Scientists
Excel VBA Data Analysis
for Engineers / Scientists
Advanced Excel VBA Design
for Engineers / Scientists
Mixed Language Programming
with Excel VBA / Fortran
Microsoft Excel for Engineers / Scientists Excel Data Analysis for Engineers / Scientists Excel VBA for Engineers / Scientists Excel VBA Data Analysis for Engineers / Scientists Advanced Excel VBA Design for Engineers / Scientists Mixed Language Programming with Excel VBA and Fortran

Excel skills needed for the class.

Select this Excel training if you or your group have:

  • Controlled workbooks, worksheets, and entered worksheet data
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks like coloring a cell, bolding, aligning,...
  • Used cell and range references like A1 or A1:A10 in formulas
  • Built formulas like =.5*0.002377 *A1^2
  • Used basic worksheet functions like SUM, MAX, MIN...

The class details.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Contact us by form.

Click to View Form
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved