Excel Data Analysis for Engineers and Scientists

Microsoft Excel Data Analysis for Engineers and Scientists Training

Next Class: Check Dates

Unleash Excel's data abilities and rapidly automate multi-step engineering and science reports.

  Learn to combine Excel's external querying abilities, functions, and data tools to quickly build automated report tools that integrate, analyze, and chart data.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8 Example9 Example10

Class overview.

What makes our training different?

Our 1-day class  shows you how to take command of Excel's data tools, functions, and charts 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.

Onsite Classes Designed for Your Problems

Some key topics we cover in class.

Prerequisites for our Excel training.

Excel Manuals

Class time, duration, manual, and repeats.

Class syllabus and training options.

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

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

Using PivotTables to Analyze Engineering and Science Data

Using Array Formulas to Analyze Complex Engineering and Science Data Patterns

Linking Excel with Word and PowerPoint to Build Dynamic Reports

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 >

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

Copyright © 2002-2023

EMAGENIT All Rights Reserved