MOC 10994 - Data Analysis Fundamentals Using Excel

MOC 10994 - Data Analysis Fundamentals Using Excel

Course Length:
Delivery Methods:
Next Live Class:Apr 22-23, 2021 10AM-6PM ET
Register Now
Course Topics
  • Learn to create an Excel report.
  • Learn to create an Excel table.
  • Learn to create a pivot table and pivot chart.
  • Learn to create a dashboard and analyze data.
  • Learn to create Hierarchies.
  • Learn to create an Excel data model and connect to external data.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Course Overview

In this Data Analysis Fundamentals Using Excel training class, students learn to add analysis capabilities to Excel spreadsheets. This course is intended for anyone responsible for analyzing data with Excel.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Course 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 Microsoft Excel class:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic Knowledge of Excel spreadsheets.
Register for a Live Class
$1,190.00

    • See More Class Dates

Please select a class.
Request a Private Class
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Pricing