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

Business Skills Training

The course was very well documented, very enriching experience.
Comment from Courts Administration Service

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