Excel Data Analysis for Engineers and Scientists - Class

Unleash Excel and rapidly solve multi-step engineering and science data problems. Learn to combine Excel's query features, functions, and data analysis elements to quickly build tools that integrate, analyze, and chart data.

Next Class: Check Dates

Microsoft Excel Data Analysis for Engineers and Scientists Training

We'll show you new ways to crunch data.

Class overview.

Our 1-day class shows you hands-on how to take command of Excel's powerful data features and use them to rapidly process and visualize engineering and science 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 merge text values, parse date-times like milliseconds, curve fit chart data, and build array formulas to analyze complex datasets and lookups.

You'll also discover how to use Power Query and Excel tables to create reports that automatically import data, shape it, calculate it, and chart it at the click of a refresh button.

Join us and our class will show you how to quickly combine Excel's critical data elements into tools that will save you time and effort.

Some key topics we cover in class.

Customers
View Customers >
Newsletter Signup
Newsletter Signup >

Prerequisites for our Excel training.

Class syllabus, training, and price options.

Virtual Signup

View the dates and signup for our hands-on live virtual training.
Virtual Signup: $150.00 >

Public Signup

View the dates and signup for our hands-on in-person public training.
In-Person Signup: $190.00 >

Manual Information

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

Onsite Details

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

Using Formulas, Functions, String Concatenation, and Tables in Data Analysis

Quickly Analyzing Data Using Filters, the Analysis Toolpak, and Conditional Formatting

Using Key Worksheet Functions to Lookup, Parse, and Analyze Your Data

Using Power Query and Text Wizard to Access and Shape Data

Chart Design, Curve Fitting, and Data Displays

Using PivotTables, Pivot Charts, and Power Pivot to Analyze Data

Using Array Formulas to Analyze Complex Data Patterns

Linking Excel with Word and PowerPoint to Build Dynamic Reports

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