Excel Level 2

Duration: 6 Hours

Prerequisite: Excel Level 1

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

Worksheet Organization

  • Managing Range Names

  • Creating and Using Workbook Templates

  • Applying Worksheet Security

  • Creating and Using Outlines

  • Working with Data Validation

Advanced Formulas

  • Using the IF Function

  • Using the IFS Function

  • Linking Formulas

  • Modifying and Restoring Links

Using Multiple Workbooks and Worksheets

  • Working with Multiple Workbooks

  • Working with Multiple Worksheets

Working with Charts

  • Creating Charts

  • Changing Chart Data

  • Modifying Chart Elements

  • Creating Custom Charts

Applying Formatting

  • Working with Styles

  • Annotating Worksheets

  • Using Sparklines

Supplemental - Macros Overview

  • Planning Macros

  • Recording Macros

  • Executing Macros

  • Maintaining Macros

Get Quote

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