Excel Level 3

Duration: 6 Hours

Prerequisite: Excel Level 2

Cost: $299 CAD / Person

Course provided remotely by a live instructor via Microsoft Teams or Zoom.

Minimum enrollment required. Discounts for government employees and groups.

Learning Objectives

Maintaining Data

  • Data List and Excel Table Concepts

  • Working with Tables

  • Using Lookup Tables

  • Using Data Forms

Sorting Lists

  • Sorting Concepts

  • Sorting Lists

  • Custom Sort Orders

Filtering Lists

  • Filtering Concepts

  • Using AutoFilter

  • Using Advanced Filter

  • Working with Filtered Data

Summarizing Data

  • Automatic Subtotals

  • Working with Subtotalled Lists

  • Using Functions to Summarize Data

Working with PivotTables

  • PivotTable Concepts

  • Creating PivotTables

  • Modifying PivotTable Layouts

  • Working with PivotTables

  • PivotCharts

  • Slicers

Supplemental - Dynamic Array Formulas

  • Dynamic Array Formula Concepts

  • Creating Unique Dynamic Lists

  • Sorting Dynamic Arrays

  • Filtering Dynamic Arrays

Get Quote

Want more information on our courses? Send a message and we’ll reply shortly.