MOC 10994 - Data Analysis Fundamentals Using Excel

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).

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

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

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

Training for Yourself

$1,190.00 or 2 vouchers

Upcoming Live Online Classes

  • See More Classes

Please select a class.

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

As someone who uses PowerPoint but never had the time to really learn how valuable this resource can be, I was able to take this class and walk away feeling very confident in my abilities in PowerPoint. The instructor was an incredible teacher and great resource! The time she took to make sure I understood everything was fantastic and we went at a pace that was quick enough for us to cover all the material but also slow enough that I was able to retain it! My only fear is now that everyone in my company will be leaning on me to help them do their Power Point presentations!!! Thank you again for a superb course!
Chris Deigan
Cord Blood Registry
My instructor really took the time to make sure everyone understood what they needed in order to be successful.
Robin Anderson
Zurich Insurance Company
The webucator is as good as a class room course. In fact it is easier than a class room to show your work to your instructor, to sit comfortably at your office or home. It is definitely less stressful.
Krishna Maddi
Capstone Logistics
The course I took helped me understand my job better and gave me a feeling of confidence.
John Mendes
The Canebrake

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

64,157

Students who have taken Instructor-led Training

11,950

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.30

Students rated our trainers 9.30 out of 10 based on 30,188 reviews

Contact Us or call 1-877-932-8228