Font size:

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
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live1/8/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.001807314
ON Ottawa1/8/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.001819596
Virtual Live2/26/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.001807318
VA ALEXANDRIA2/26/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.001804564
ON Toronto2/26/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.001819592
Virtual Live4/23/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.001807315
VA ALEXANDRIA4/23/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.001804565
NY New York4/23/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.001819627
Virtual Live7/9/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.001807319
VA ALEXANDRIA7/9/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.001819660
Virtual Live8/20/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.001807322
VA ALEXANDRIA8/20/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.001804568
ON Ottawa8/20/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.001819667
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 13 of 13 items