SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Business Skills Training

The instructor appeared to be very knowledgeable with regard to all aspects of the course. He was quick to point out features which were new or had changed since previous versions, and called specific attention to information he thought was particularly relevant to us.
Comment from DND

1. Title

  • Mastering Data Analysis and Presentation for IT Professionals (SDANA, 2 days)
    View PDF

2. Course Pre-requisites

  • Previous Experience in an IT Environment

3. Target Audience

  • IT Professionals who want to learn how to analyze operational data using Microsoft Excel

4. Dates and Pricing

2 People for Guaranteed Live or Virtual Delivery $1,150.00 per person

5. Outline

Module 1: Importing Data from Relevant Sources

Topic 1: A Note on Data Sources

Topic 2: The Representation of Data in Excel

Topic 3: Importing Data from SQL Server

Topic 4: Importing Data from Oracle

Topic 5: Importing Data from Windows Server

Topic 6: Importing Data from Linux

Topic 7: Working with External Data Sources

Topic 8: General Data Import Procedures

Module 2: Filtering and Sorting Data

Topic 1: Ensuring the Correctness of the Data

Topic 2: Making Use of Conditional Formatting

Topic 3: Sorting Data

Topic 4: Filtering Text Data

Topic 5: Filtering Date Data

Topic 6: Filtering Numeric Data

Topic 7: Dealing with Missing Data

Topic 8: Working with Multiple Data Sources

Module 3: Creating Summary Statistics

Topic 1: Creating Summary Sheets

Topic 2: Understanding Copy-Paste Behavior with Functions

Topic 3: Working with Basic Arithmetic and Statistical Functions

Topic 4: Working with Logical Functions

Topic 5: Working with Conditional Functions

Topic 6: Working with Frequency Functions

Topic 7: Working with Dates and Ranges

Topic 8: Working with Null or Missing Data

Topic 9: Presenting Data in Word

Module 4: Working with Charts and Graphs

Topic 1: Creating Basic Charts and Graphs

Topic 2: Working with Multiple Data Sets

Topic 3: Formatting Charts and Graphs

Topic 4: Customizing Charts and Graphs

Topic 5: Presenting Data in Word

Module 5: Working with Pivot Tables and Pivot Charts

Topic 1: The Role and Purpose of a Pivot Table

Topic 2: Creating a Pivot Table

Topic 3: Working with Row and Column Fields

Topic 4: Working with Aggregate Fields

Topic 5: Modifying Picot Table Options

Topic 6: Making use of Pivot Charts

Topic 7: About Slicers

Topic 8: Presenting Data in Word

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette