Excel Data Analysis for Engineers and Scientists - Class

Learn to rapidly analyze, report, and visualize technical data by combining Excel's data elements, formulas, and charts into adaptable data tools. Class Examples >

Next Class: Check Dates

Microsoft Excel Data Analysis for Engineers and Scientists Training

How our class will boost your Excel data skills.

Boost Excel Data Analysis Training

Our 1-day class shows you how to rapidly analyze, report, and visualize data by combining Excel's data elements, formulas, and charts. It covers essential topics like how to use various formulas, functions, filters, and logic to process data. Data collection strategies between worksheets and workbooks are also explored. It also shows how to use charts, PivotTables, slicers, and Pivot Charts to rapidly create reports and visualize data.

In addition to the essentials, topics like curve fitting; parsing text / times; Conditional Formatting; and building array formulas to process data are also discussed. You'll also explore how to use Power Query to automatically import and filter data for your formulas, charts, and reports.

Read our detailed outline > below and see what you'll discover in our class.

What you'll learn in our class.

Excel Picture white
Close Examples
Forward... Forward...

Learn to use formulas, Excel tables, spill over arrays, and filter functions to track, organize, and adaptively consolidate data.

Learn to use logic and functions in formulas to make data decisions and to sum, count, and analyze it based on criteria.

Learn to use logic, functions, and Conditional Formatting to flag data, create adaptive problem formatting, and design data visualization tools.

Learn to use Excel's data tools to filter data and the Analysis Toolpak to rapidly perform various statistical analyses on your data sets.

Learn how to perform hi-tech table lookups with various functions and how to return columns, rows, and parts of tables in your formulas.

Learn to create various technical charts, perform curve fits, and create visual displays by combining charts, shapes, slicers, and controls.

Learn to use array formulas to analyze and filter complex data, and use functions to perform various text, date/time, and statistical operations.

Learn to link and format external data with Power Query and use PivotTables to create tables and Pivot Charts that rapidly summarize data.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8
  • How to use cell references, names, and arrays to build data formulas and combine worksheet data
  • How to use Excel's Filters, Sort, Slicers, Analysis Toolpak, and Excel tables to rapidly filter and process data
  • Flagging worksheet data using Conditional Formatting and logic
  • Creating and formatting charts; curve fitting chart data
  • Using key math, trig, date-time, and statistical worksheet functions to analyze data
  • Looking up data in worksheet tables using the VLOOKUP, XLOOKUP, INDEX... functions
  • Using logic functions like SUMIFS, COUNTIFS, IF, AND... to summarize, count, and analyze worksheet data
  • Importing text files with Text Wizard and analyzing worksheet text with functions like LEFT, MID, CLEAN...
  • Building array formulas to analyze complex engineering and science data sets
  • How to use PivotTables and Pivot Charts to rapidly process, summarize, and visualize data
  • How to use Power Query to import and filter (i.e. sort, delete, clean, trim...) data automatically

Some key topics we cover in class.

Excel Data Training Topics

4 ways to train.

Virtual Signup
Virtual

View the dates and signup for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup
In-Person

View the dates and signup for our hands-on in-person public training.
In-Person Signup >   Learn More >

Manual Information
Manual

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details
Onsite

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

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 PDF

Download Class Brochure

 Worksheet Formula, Linking, and Parsing Fundamentals

 Using Logic to Analyze, Flag, and Display Worksheet Data

Analyzing Data with Filters and the Analysis Toolpak

Analyzing Dates, Times, Text, Statistics and, Performing Table Lookups

Using Power Query and Text Wizard to Import and Filter Data

Chart Design, Curve Fitting, and Visualizing Data

Analyzing Data Sets Using Array Formulas

Using PivotTables and Pivot Charts to Analyze Data

Additional Class Information

Prerequisites for our Excel training.

Class time, manual, and repeats.

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 >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved