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

Goals

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.

Outline

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
Excel Tables
1. Excel Data Tables
2. Summarizing Data
3. Lab: Create an Excel Table
  1. Create an Excel Table
  2. Summarize Excel Data
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
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
Hierarchies
1. Hierarchies
2. Time Data
3. Lab: Creating Hierarchies
  1. Create a Hierarchy
  2. Configure Time data
  3. Create an Animated Time Chart
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

Onsite: Course Setup
Live Online: Course Setup | WebEx Setup

What people say about our training

Webucator lived up to the "no classes cancelled" motto. I was the only student in my class. The instructor was excellent, cheerful and attentive to my questions and covered the material completely in a way that I could learn it.

Philip Mahan

The Institutes

Awesome facilitator!

Connie Woodland

Capital Area Asset Builders

Really got a lot out of this class. Loved being in my own environment but also having class and trainer interaction. I will definitely use Webucator in the future.

Stephanie Glorioso

Ward & Moore Insurance Services

The best thing about Webucator classes is that they are taught by developers who are actually using the tools in their professional careers! They provide tips and guidance based on their experience in addition to following the course materials.

Amanda Brown

Genzyme

MOC 10994 - Data Analysis Fundamentals Using Excel

Training for your Team

Training for Yourself

Upcoming Classes

What people say about our training