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



Course Length: 6 hours (1 day)
Managing your data is a key to success in any business. Microsoft Excel is the standard spreadsheet application used extensively worldwide for this purpose. Excel allows users to build and calculate formulas quickly, efficiently and accurately. Excel's database functions enable users to find, extract, and analyze valuable data in order to make effective business decisions.

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: 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?
Table Components
The Create Table Dialog Box
The Table Tools - Design Contextual Tab
Table Styles
Customize Row Display
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 Database Functions to Calculate Data
SUBTOTAL Functions
The Subtotal Dialog Box
Database Functions (DSUM, DAverage)

Section 9: Visualizing Data with Charts
Section 9.1: Inserting Charts
Chart Types
Create Charts
Chart Insertion Methods
Resizing and Moving the Chart
Adding Additional Data
Switching Between Rows and Columns

Section 9.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 9.3: Adding Trendlines
Types of Trendlines
Add a Trendline
Format a Trendline

This Course Comes With

PDF Manual

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

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned


Also Available With This Course

Printed Manual

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

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed


Customize Your Course

Tailored Training

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

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

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!

Level 2 (Intermediate)
Guaranteed to Run
Even with one participant,
our classes are guaranteed to run!
Register for Online Classes

To view additional ticket options, click the "Filter by Date" button and select more dates.


Date(s) Price Qty
September 28, 2021 9am to 4pm ET $275.00 (CAD)*  
October 15, 2021 9am to 4pm ET $275.00 (CAD)*  
October 28, 2021 9am to 4pm ET $275.00 (CAD)*  
November 16, 2021 9am to 4pm ET $275.00 (CAD)*  
November 25, 2021 9am to 4pm ET $275.00 (CAD)*  
December 6, 2021 9am to 4pm ET $275.00 (CAD)*  
December 16, 2021 9am to 4pm ET $275.00 (CAD)*  
January 6, 2022 9am to 4pm ET $275.00 (CAD)*  
January 26, 2022 9am to 4pm ET $275.00 (CAD)*  
February 8, 2022 9am to 4pm ET $275.00 (CAD)*  
February 28, 2022 9am to 4pm ET $275.00 (CAD)*  
March 11, 2022 9am to 4pm ET $275.00 (CAD)*  
March 24, 2022 9am to 4pm ET $275.00 (CAD)*  
April 4, 2022 9am to 4pm ET $275.00 (CAD)*  
April 27, 2022 9am to 4pm ET $275.00 (CAD)*  
May 6, 2022 9am to 4pm ET $275.00 (CAD)*  
May 30, 2022 9am to 4pm ET $275.00 (CAD)*  

* 13% HST will be applied on checkout


Online registration closes two business days before the start of the class.
Questions?
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 4+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here