Skip to main Content

Data Analysis Fundamentals using Excel

  • Course Code M10994
  • Duration 2 days
  • Version B

Additional Payment Options

  • GTC 16 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

£1,295.00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

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

Course Schedule

Top
    • Delivery Format: Virtual Learning
    • Date: 13-14 September, 2021
    • Location: Virtual

    £1,295.00

    • Delivery Format: Virtual Learning
    • Date: 09-10 December, 2021
    • Location: Virtual

    £1,295.00

Target Audience

Top
This course is intended for anyone responsible for analyzing data with Excel

Course Objectives

Top

After completing this course, students will be able 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

 

Course Content

Top

Module 1: Reporting in ExcelThis 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 TablesThis 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 ChartsThis 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: DashboardsThis 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: HierarchiesThis 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 ModelThis 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.

Course Prerequisites

Top

Before attending this course, students must have:

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

 

Cookie Control toggle icon