Great Canadian Training Company color logo

Microsoft Excel Level 2 (Intermediate)
(2013, 2016, 2019, 2021, 365)

What You'll Learn in Microsoft Excel Level 2 (Intermediate)

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. You will:

 

  • Enter, edit, and format data to create workbooks
  • Work with Named Ranges
  • Use IF, OR, PMT, VLOOKUP and XLOOKUP functions
  • Display relationships between formulas and cells using formula auditing tools
  • Sort and filter data
  • Organize worksheet data with tables
  • Visualize data with charts

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 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


Section 3: Analyzing Data with Logical and Lookup Functions 

The IF Function

The AND Function

The OR Function

The LOOKUP Function

The VLOOKUP and HLOOKUP Function

The XLOOKUP Function

 

Section 4: Using Financial Functions

The PMT Function

The FV Function

 

Section 5: Use Date Functions

The TODAY Function

The NOW Function

Serialize dates and times with functions

 

Section 6: Auditing Worksheets

The Trace Cells Feature

Show and Hide Formulas

Resolve Errors in Formulas

Using the Watch Window

 

Section 7: Organizing Worksheet Data with Tables

What Are Tables?

Table Components

The Create Table Dialog Box

The Table Tools – Design Contextual Tab

Table Styles

Customize Row Display

Table Modification Options

 

Section 8: 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 9: Using Subtotal and Database Functions to Calculate Data

SUBTOTAL Functions

The Subtotal Dialog Box

 

Section 10: Visualizing Data with Charts

Section 10.1: Inserting Charts 

Chart Types

Create Charts

Chart Insertion Methods

Resizing and Moving the Chart

Adding Additional Data

Switching Between Rows and Columns

 

Section 10.2: Modifying and Formatting Charts

Chart Elements

The Chart Tools Contextual Tabs

Format the Chart with a Style

Add a Legend to the Chart

Add Data Labels to Charts

Create Custom Chart Templates

 

Section 11: Managing Themes

About Themes

Customize Themes

 

Section 12: Adding Trendlines

Types of Trendlines

Add a Trendline

Format a Trendline

 

Section 13: Create Sparklines

What is a Sparkline?

Types of Sparklines

The Sparkline Tools – Design Tab

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Microsoft Excel Level 2 (Intermediate)

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
April 16, 2024
9:00 AM to 4:00 PM ET
$295.00 Online
May 13, 2024
9:00 AM to 4:00 PM ET
$295.00 Online
June 21, 2024
9:00 AM to 4:00 PM ET
$295.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training


Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices


Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!


Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference


Can I customize my course?
OF COURSE!

Tailored Training

Your Reference Guide will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Use Your Own Files

You can include your own files in your training session to make it more applicable to your day-to-day role.