Data Analysis Fundamentals using Excel (10994)

Data Analysis Fundamentals 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
  • Summarising Data

  Lab: Create an Excel Table

  • Create an Excel Table
  • Summarise Excel Data

  After completing this module, students will be able to:

  • Explain what Excel Data tables are
  • Sort, filter, and validate data
  • Summarise data
  • Format summarised 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