Microsoft Excel Data Analysis for Engineers and Scientists

Microsoft Excel Data Analysis for Engineers and Scientists

Microsoft Excel Data Analysis for Engineers and Scientists

Our Excel data analysis training shows you the skills that you need to start processing engineering and science data.

Our Excel training focuses on useful formula design as it applies to data analysis; data transfer and organization on the worksheet using range names, cell names and Excel tables; using logic and conditional formatting to flag data; using worksheet functions like VLOOKUP, MATCH, IF, COUNTIF and SUMIF to analyze data; and using Excel's built-in analysis tools like pivot tables and Power Query to process data on the worksheet. We even show you how to tie Excel into Word and PowerPoint for report generation tools. Read below and see how we can "Supercharge" your Excel data analysis skills.

Onsite Only
Onsite Details

Excel Data Analysis Training Description

Our 1-day Excel data analysis training for engineers and scientists training will show you how to effectively use Excel to process engineering and scientific data. Key topics include using cell and range names to track data, using key functions like VLOOKUP, MATCH, COUNTIF, SUMIF and IF in data analysis formulas; using advanced 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.

Key Skills Learned in Our Excel Data Analysis Training

Key Skills You'll Learn in Our Microsoft Excel Data Analysis Training

Key Excel skills learned:

Excel Training Skill Requirements

Excel Data Analysis Training Skill Requirements

Select this Excel training if you or your group:

Microsoft Excel Data Analysis Topics Outline

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.

Formula Design, Formula Debugging, Cell Naming and Sheet Linking for Engineers and Scientists

Microsoft Excel Data Analysis Training Free Repeats

Key Things to Know About Building Engineering and Science Tables on the Worksheet

Worksheet Function Operation, Argument Lists and Nesting for Engineers and Scientists

Looking Up and Merging Engineering and Science Table Data

Logic Overview, Condition Construction and Key Logic Worksheet Functions for Engineers and Scientists

Essential Data Analysis Formula Design for Scientists and Engineers

Must Know Text Analysis Techniques for Engineers and Scientists

Using the Group, Advance Filter and Sort Tools 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

Linking Excel with Word and PowerPoint

Using Power Query to Access External Engineering and Science Data

Microsoft Excel Data Analysis Training Details

Onsite Details

Onsite Only
Onsite Details

Microsoft Excel Data Analysis Training Contact Information

Contact EMAGENIT Directly

  • Phone Number: 1.866.924.6244
  • Business Hours: 8:30 - 5:00 PM PT
  • email: excel_data_eng_sci_question@emagenit.com

Your Contact Information

*Name:
Company:
Company Web:
Country:
Phone #:
Ext:
*e-mail:
Contact me directly by
phone when this is received

*Required information to complete form. Privacy Policy

Workshop Questions

Please fill out the box below with your workshop questions and EMAGENIT will contact you.

Request Workshop Information and Submit

Send me on-site workshop information
Send me public training workshop information
Send me self-study manual information
Send me live online course information

Before clicking the Submit button, please fill in at least your name and email under Your Contact Information. Privacy Policy

Facebook
Information
Need Help? Please call us at 1.866.924.6244

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2017

EMAGENIT All Rights Reserved