0345 4506120

M10994 Data Analysis Fundamentals using Excel 2016

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets.

This is a Microsoft Official Course (MOC) delivered by an expert instructor.

Learning Objectives

You Will Learn How To

  • Create an Excel report
  • Create an Excel table
  • Create a pivot table and pivot chart
  • Create a dashboard and analyze data
  • Create Hierarchies
  • Create an Excel data model and connect to external data

Pre-Requisites

Requirements:

  • Before attending this course, students must have: 
    • Basic knowledge of the Microsoft Windows operating system and its core functionality 
    • Basic Knowledge of Excel spreadsheets

Redeem Your Microsoft Training Vouchers (SATV):

  • This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.

Course Content

Course Outline

Module  1: Reporting in Excel

This module explains how to create a report in Excel.

Lessons

  • Filtering and Formatting Data
  • Charts

Lab: Create an Excel report

  • Filtering Excel Data
  • Formatting Excel Data
  • Create excel Charts

After completing this module, students will be able to:

  • Filter and format data
  • Create charts

Module  2: Excel Tables

This module explains how to create data tables in Excel.

Lessons

  • Excel Data Tables
  • Summarizing Data

Lab: Create an Excel Table

  • Create an Excel Table
  • Summarize Excel Data

After completing this module, students will be able to:

  • Explain what Excel Data tables are
  • Sort, filter, and validate data
  • Summarize data
  • Format summarized data

Module  3: Pivot Tables and Pivot Charts

This module describes pivot tables and pivot charts and how to work with them.

Lessons

  • 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

After completing this module, students will be able to:

  • Describe pivot tables and how to create them
  • Describe the various elements of a pivot chart
  • Edit pivot tables and pivot charts

Module  4: Dashboards

This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.

Lessons

  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables

Lab: Create a Dashboard

  • Arranging Tables and Charts
  • Slicing Data
  • Data Analysis

After completing this module, students will be able to:

  • Describe a dashboard
  • Filter data using a slicer
  • Add calculated columns to a dashboard
  • Find anomalies

Module  5: Hierarchies

This module describes hierarchies and time data.

Lessons

  • Hierarchies
  • Time Data

Lab: Creating Hierarchies

  • Create a Hierarchy
  • Configure Time data
  • Create an Animated Time Chart

After completing this module, students will be able to:

  • Describe hierarchies
  • Create levels within a hierarchy
  • Explain why time data is different and how to work with it

Module  6: The Excel Data Model

This module explores the Excel data model and looks at ways of extending it.

Lessons

  • Using an Excel Data Model
  • External Data

Lab: Explore an Excel Data Model

  • Add Multiple Tables
  • Create Relationships
  • Add External Data

After completing this module, students will be able to:

  • Explain an Excel Data Model and how to use it
  • Import External Data and use it
  • Link out to external data

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Online Courses

You may prefer an online course if you are looking for a flexible and cost-effective solution. Online courses allow you to study at your own pace, at a time that suits you.

We have the following eLearning options available:

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include