top of page
Excel Logo.webp

Improve Your Productivity 

Join the club of Microsoft Excel Masters who’ve cut through the maze of confusion and made communication about numbers easier. See a snapshot of each course below.

 

Call 1-905-829-1111 to “Ask the Trainer” which program level is right for you (and get a detailed description of each course). Learn practical techniques and tools in Microsoft Excel training so you can work smarter, not harder.

 

Progressive Training’s comprehensive Excel program is broken down into three separate one-day courses, guaranteed to change your use of Microsoft Excel forever. 

Level 2: Intermediate

Target Student:


This course is for individuals who are familiar with the basics of Excel and who wish to learn additional functions and tools to organize and analyze their data more fully.
Course Length: 6 hours (1 day)

Learning Objectives:

In this course, you will create advanced formulas, utilize and maintain database records, utilize Named Ranges in your formulas and visualize your data in Charts.

 

  • Navigate efficiently around your worksheets

  • Work with Named Ranges

  • Use, date, text functions and IF, VLOOKUP and XLOOKUP Functions

  • Display relationships between formulas and cells using formula auditing tools

  • Organize worksheet data with tables

  • Sort and filter data

  • Visualize data with charts

Course Outline:

Section 1: Working with Range Names

  • What are Range Names?

  • Apply Range Names using the Name Box

  • Editing Range Names

  • Using Range Names in Formulas

Section 2: Using Specialized Functions

  • Function Categories

  • The Excel Function Reference

  • Function Syntax

  • Function Entry Dialog Boxes

  • Using Nested Functions

  • Automatic Workbook Calculations Date, Time and Text functions

Section 3: Analyzing Data with Logical and Lookup Functions

  • The IF Function

  • The LOOKUP Function

  • The VLOOKUP and HLOOKUP Function

  • The XLOOKUP Function

Section 5: Auditing Worksheets

  • The Trace Cells Feature

  • Show and Hide Formulas

  • Resolve Errors in Formulas

  • Using the Watch Window

Section 6: Organizing Worksheet Data with Tables

  • What Are Tables?

  • The Create Table Dialog Box

  • The Table Tools - Design Contextual Tab

  • Table Styles

  • Table Modification Options

Section 7: Sorting and Filtering Data

  • The Difference Between Sorting and Filtering

  • Sorting Data

  • Filtering Data with Autofilters

  • Creating Advanced Filters

  • Filter Operators

  • Removing Duplicate Values

Section 8: Using Subtotal and Summary Functions

  • SUBTOTAL Functions

  • The Subtotal Dialog Box

  • Summary Functions

Section 9: Visualizing Data with Charts

  • Chart Types

  • Create Charts

  • Resizing and Moving the Chart

  • Switching Between Rows and Columns

  • Chart Elements

  • Format the Chart with a Style

  • Create Custom Chart Templates

bottom of page