MOC 10994A - Data Analysis Fundamentals Using Excel

Customized Onsite Training

2
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

$950.00
or 2 vouchers
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

Upcoming Classes

  • See More Classes

Please select a class.
Overview

The main purpose of this Data Analysis Fundamentals Using Excel training class is to give students the ability to add analysis capabilities to Excel spreadsheets.
This course is intended for anyone responsible for analyzing data with Excel

Goals
  1. Learn to create an Excel report.
  2. Learn to create an Excel table.
  3. Learn to create a pivot table and pivot chart.
  4. Learn to create a dashboard and analyze data.
  5. Learn to create Hierarchies.
  6. Learn to create an Excel data model and connect to external data.
Outline
  1. Reporting in Excel
    1. Filtering and Formatting Data
    2. Charts
    3. Lab: Create an Excel report
      1. Filtering Excel Data
      2. Formatting Excel Data
      3. Create excel Charts
  2. Excel Tables
    1. Excel Data Tables
    2. Summarizing Data
    3. Lab: Create an Excel Table
      1. Create an Excel Table
      2. Summarize Excel Data
  3. Pivot Tables and Pivot Charts
    1. Pivot Tables
    2. Pivot Charts
    3. Editing Pivot Tables and Pivot Charts
    4. Lab: Importing Data from a CSV File
      1. Creating a Pivot Table
      2. Creating a Pivot Chart
      3. Editing Pivot Tables and Pivot Charts
  4. Dashboards
    1. Creating a Dashboard
    2. Data Analysis in Excel Pivot Tables
    3. Lab: Create a Dashboard
      1. Arranging Tables and Charts
      2. Slicing Data
      3. Data Analysis
  5. Hierarchies
    1. Hierarchies
    2. Time Data
    3. Lab: Creating Hierarchies
      1. Create a Hierarchy
      2. Configure Time data
      3. Create an Animated Time Chart
  6. The Excel Data Model
    1. Using an Excel Data Model
    2. External Data
    3. Lab: Explore an Excel Data Model
      1. Add Multiple Tables
      2. Create Relationships
      3. Add External Data
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic Knowledge of Excel spreadsheets.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

80,130

Students who have taken Live Online Training

15,540

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.38

Students rated our trainers 9.38 out of 10 based on 4,997 reviews

I was very pleased. This was Interactive and really easy to follow.

Natalie Ewton, IRMI
Dallas TX

Webucator is a great way for busy professionals to get training without being away from the office.

Margaret Smith, Stryker Orthopaedics
Mahwah NJ

Great practical examples by the instructor to help with real life use. This course/class will definitely get me off the ground and headed in the direction I want to go with web design.

Dennis Renfroe, n/a
Fuquay Varina NC

A lively class that offered plenty of opportunity for one-on-one instruction and direct feedback for questions and clarification.

Ole Calderone, Harris Corporation
Toronto ON

Contact Us or call 1-877-932-8228