MOC 10994 - Data Analysis Fundamentals Using Excel

2 Days

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.

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

Filtering and Formatting Data

Charts

Lab: Create an Excel report

Filtering Excel Data

Formatting Excel Data

Create excel Charts

Excel Tables

Excel Data Tables

Summarizing Data

Lab: Create an Excel Table

Create an Excel Table

Summarize Excel Data

Pivot Tables and Pivot Charts

Pivot Tables

Pivot Charts

Editing Pivot Tables and Pivot Charts

Lab: Importing Data from a CSV File

Creating a Pivot Table

Creating a Pivot Chart

Editing Pivot Tables and Pivot Charts

Dashboards

Creating a Dashboard

Data Analysis in Excel Pivot Tables

Lab: Create a Dashboard

Arranging Tables and Charts

Slicing Data

Data Analysis

Hierarchies

Hierarchies

Time Data

Lab: Creating Hierarchies

Create a Hierarchy

Configure Time data

Create an Animated Time Chart

The Excel Data Model

Using an Excel Data Model

External Data

Lab: Explore an Excel Data Model

Add Multiple Tables

Create Relationships

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.