Select Page

Microsoft Excel Training Courses | Intermediate Level Class- Toronto


Corporate and Groups Special Rates

Limited Availability & Capacity – Reserve your seat by enrolling now.  Please read our Refund and Cancellation policy

Upcoming Classes:

Tue, July 23 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Tue,  July 30 (10:00 a.m.- 5:00 p.m. EST)  (Online)

Tue,  Aug 20 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Tue, Aug 27  (10:00 a.m.- 5:00 p.m. EST)  (Online)

Tue, Sep 24 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Tue, Oct 01 (10:00 a.m.- 5:00 p.m. EST)  (Online)

Tue, Oct 22 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Tue, Oct 29 (10:00 a.m.- 5:00 p.m. EST) (Online)


Tuesday, TBA (Mississauga)

Tuesday, TBA (Barrie)

Course Fee: In-Person: CAD $275   Online:  CAD $225

Reserve your seat: $25  Non-refundable. To be refunded if the class is canceled by PMVISION.

Remainder:  Due one week prior to the start date

Take Excel introduction course+ Excel Intermediate + Excel Advanced for only $650

MS. Excel Training Course – Excel Intermediate Level Classes | Designed for Excel 365, 2021, 2019, 2016


This Intermediate Microsoft Excel training class is meant for students who want to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features, and data manipulation tools like goal-seeking.

Training Type:  Classroom Training – Downtown Toronto ” Also available in Mississauga,  Scarborough, Hamilton, and Barrie ” Mississauga ( 55 Village Centre Pl, Mississauga, ON L4Z 1V9).  Barrie: Georgian College (One Georgian Dr. Barrie, ON L4M 3X9) )

Other options: Online Training- On-site at your company office ” Anywhere”

Course Level:  Excel Intermediate Level Course

Related Excel TrainingExcel Foundation Course  &  Excel Advanced Class

Number of students per session:  Our class sizes are typically 6 students per session. Our classes are intentionally kept small in order to foster more interaction between the instructor and students. We limit classes to a maximum of six (6) students unless we are teaching a private group or organization. Each student is provided a laptop with hands-on access to Microsoft Excel 2019 (Windows)

Locations: Toronto ( 1 Yonge St),  Also we offer the course in Mississauga & Scarborough. Mississauga ( 55 Village Centre Pl, Mississauga, ON L4Z 1V9)

Duration:   1 day  ( 10 AM- 5 PM)

Special Offers:   Sign up with a friend and save 5% each  – Sign up with 2 friends and save 10%

We provide each attendee with a laptop with hands-on access to Microsoft Excel 365. If you prefer to use your laptop, your laptop should have Microsoft Excel 365, 2013, 2016, or Excel 2019 installed. You can get Microsoft Office including MS.Excel 365 for less than $15/Month from the Microsoft Office Official site. Select Office 365 Business


Corporate Training Special Offers:  Rate per day (level)

At our location:

  • 2 Employees: $450
  • 3 Employees: $700
  • 4- 6  Employees: $800.
  • 7-12  Employees: $1000

At your location:

  •  Up to 6  Employees: $800.
  •  Up to 12  Employees: $1000
  • For a large number of trainees, we assume each employee will have access to a computer with Excel installed. If PMVISION provides the laptops: a $25 Fee for each laptop
  • If Your location is outside GTA “Greater Toronto Area”, a Travel fee to be added



A working knowledge of creating/formatting simple spreadsheets, basic formulas, and functions. Or our Excel Introduction Levelcourse.



This course is intended for students who have basic skills with Microsoft Excel 365  (Excel 2019, Excel 2016, Excel 2013) and want to expand their knowledge. Improving formatting, organizing data, highlighting key information, and creating formulas/links between sheets. Also for students who want to learn the topics covered in this course in the Excel 365 interface.



Upon successful completion of this course, you should be able to:

  • use the fill operations available to fill a data series
  • use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use common worksheet functions
  • create more complex formulas and functions
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel’s Quick Analysis tools
  • create and work with tables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart



Filling Data

  • Understanding Filling
  • Filling a Series
  • Filling a Growth Series
  • Filling a Series Backwards
  • Filling Using Options
  • Creating a Custom Fill List
  • Modifying a Custom Fill List
  • Deleting a Custom Fill List
  • Extracting With Flash Fill
  • More Complex Flash Fill Extractions
  • Extracting Dates and Numbers

Worksheet Techniques

  • Inserting and Deleting Worksheets
  • Copying a Worksheet
  • Renaming a Worksheet
  • Moving a Worksheet
  • Hiding a Worksheet
  • Unhiding a Worksheet
  • Copying a Sheet to Another Workbook
  • Changing Worksheet Tab Colors
  • Grouping Worksheets
  • Hiding Rows and Columns
  • Unhiding Rows and Columns
  • Freezing Rows and Columns
  • Splitting Windows

Page Setup

  • Strategies for Printing Worksheets
  • Understanding Page Layout
  • Using Built in Margins
  • Setting Custom Margins
  • Changing Margins by Dragging
  • Centering on a Page
  • Changing Orientation
  • Specifying the Paper Size
  • Setting the Print Area
  • Clearing the Print Area
  • Inserting Page Breaks
  • Using Page Break Preview
  • Removing Page Breaks
  • Setting a Background
  • Clearing the Background
  • Settings Rows as Repeating Print Titles
  • Clearing Print Titles
  • Printing Gridlines
  • Printing Headings
  • Scaling to a Percentage
  • Fit to a Specific Number of Pages

Applying Borders

  • Understanding Borders
  • Applying a Border to a Cell
  • Applying a Border to a Range
  • Applying a Bottom Border
  • Applying Top and Bottom Borders
  • Removing Borders
  • The More Borders Command
  • Using the More Borders Command
  • Drawing Borders
  • Drawing a Border Grid
  • Erasing Borders
  • Formatting the Drawing Pencil

Essential Functions

  • Key Worksheet Functions
  • Using IF With Text
  • Using IF With Numbers
  • Nesting IF Functions
  • The CHOOSE Function
  • The LOOKUP Function
  • Using Counting Functions
  • The ROUND Function
  • Rounding Up and Rounding Down
  • Manipulative Functions
  • The MOD Function
  • The TODAY Function
  • The NOW Function
  • The DATE Function
  • The PMT Function

Complex Formulas

  • Scoping a Formula
  • Long-Hand Formulas
  • Preparing for Complex Formulas
  • Creating the Base Formula
  • Adding More Operations
  • Editing a Complex Formula
  • Adding More Complexity
  • Copying Nested Functions
  • Switching to Manual Recalculation
  • Pasting Values From Formulas
  • Documenting Formulas

Defined Names

  • Understanding Defined Names
  • Defining Names From Worksheet Labels
  • Using Names in Typed Formulas
  • Applying Names to Existing Formulas
  • Creating Names Using the Name Box
  • Using Names to Select Ranges
  • Pasting Defined Names Into Formulas
  • Defining Names for Constant Values
  • Creating Names From a Selection
  • Scoping Names to a Worksheet
  • Using the Name Manager
  • Documenting Defined Names

Number Formatting Techniques

  • Applying Alternate Currencies
  • Applying Alternate Date Formats
  • Formatting Clock Time
  • Formatting Calculated Time
  • Understanding Number Formatting
  • Understanding Format Codes
  • Creating Descriptive Custom Formats
  • Custom Formatting Large Numbers
  • Custom Formatting for Fractions
  • Padding Numbers Using Custom Formatting
  • Aligning Numbers Using Custom Formats
  • Customizing the Display of Negative Values

Conditional Formatting

  • Understanding Conditional Formatting
  • Formatting Cells Containing Values
  • Clearing Conditional Formatting
  • More Cell Formatting Options
  • Top Ten Items
  • More Top and Bottom Formatting Options
  • Working With Data Bars
  • Working With Colour Scales
  • Working With Icon Sets
  • Understanding Sparklines
  • Creating Sparklines
  • Editing Sparklines

Goal Seeking

  • Understanding Goal Seeking
  • Using Goal Seek
  • Challenge Exercise
  • Challenge Exercise Sample
  • The Quick Analysis Tools
  • Understanding Quick Analysis
  • Quick Formatting
  • Quick Charting
  • Quick Totals
  • Quick Sparklines
  • Quick Tables

Worksheet Tables

  • Understanding Tables
  • Creating a Table From Scratch
  • Working With Table Styles
  • Inserting Table Columns
  • Removing Table Columns
  • Converting a Table to a Range
  • Creating a Table From Data
  • Inserting or Deleting Table Records
  • Removing Duplicates
  • Sorting Tables
  • Filtering Tables
  • Renaming a Table
  • Splitting a Table
  • Deleting a Table

Chart Elements

  • Understanding Chart Elements
  • Adding a Chart Title
  • Adding Axes Titles
  • Repositioning the Legend
  • Showing Data Labels
  • Showing Gridlines
  • Formatting the Chart Area
  • Adding a Trendline
  • Adding Error Bars
  • Adding a Data Table

Chart Object Formatting

  • Understanding Chart Formatting
  • Selecting Chart Objects
  • Using Shape Styles
  • Changing Column Color Schemes
  • Changing the Color of a Series
  • Changing Line Chart Colors
  • Using Shape Effects
  • Colouring the Chart Background
  • Understanding the Format Pane
  • Using the Format Pane
  • Exploding Pie Slices
  • Changing Individual Bar Colors
  • Formatting Text
  • Formatting With WordArt
  • Changing WordArt Fill
  • Changing WordArt Effects


Included Course Materials

Course workbook “PDF” including step-by-step course exercises complete with many actual screen captures and advanced project tips, exercises and answers

Data files with all applicable Microsoft Excel files used in the course

Certificate of completion (PDF)

For more details about Microsoft Excel , please visit the product  official page EXCEL 2016

Learn What’s New in Microsoft Excel 2019


Contact us



Related Classes

Take Microsoft Excel 2019 Fundamentals Training Courses in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Take Microsoft Excel 2019 Intermediate Level Training Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Take Microsoft Excel 2019 Advanced Level Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Microsoft Excel 2019 Tables, Pivot Tables and Conditional Formatting

Microsoft Excel 2019 | Using Formulas for Financial Analysis.

Microsoft Excel 2019 | Using Formulas For Statistical Analysis

Microsoft Excel 2019 | Data Analysis with Pivot Tables

PMVISION reserves the right to postpone/cancel an event or change the location of an event because of insufficient enrollments, instructor illness, or force-majeure events.


Cancellation & Refund Policy

  • Reserve your seat fee:  Non Refundable. To be refunded if PMVISION cancels the class
  • Reserve your seat is not “transferable”, if you wish to attend the class on another date, you will have to reserve again
  • In case PMVISION  cancels an event, a 100% refund will be paid to the delegate.

If PMVISION Received the full payment

  • If the cancellation is done by the delegate within 48 hours of subscribing, 10%  will be deducted as an administration fee.
  • If a cancellation is done by a delegate 7 days or more, before the event, 20% will be deducted as an administration fee.
  • If a cancellation is done by a delegate 7 days or less, before the event, no refunds will be made
  • Bookings made at discounted prices ( Including Early Bird Booking) cannot be canceled.
  • If you must travel to attend the course, please don’t make any travel arrangements until we confirm the class. We usually usually confirm the class by email at least one week before the start date.


IMPORTANT: We recommend waiting to book any non-refundable travel until 1 week before the start of class. PMVISION is not responsible for any loss incurred as a result of a canceled class. Please email for any additional questions.

Delivery Methods:

  1.  Classroom Training: Downtown Toronto – Mississauga , Scarborough, Ottawa & Montreal.
  2.  Virtual Classroom
  3.  On-Site Training: At your location, anytime , anywhere
  4.  Corporate Training: Special rates for Corporate Training

Group Discount:

We provide special rate for groups :

  • 5% Discount for Group of 2
  • 10% Discount for Group of 3
  • 15% Discount for Group of 4

Certificate of Completion (PDF Format) is available upon attending the course.


2 Attendees: $400

3 Attendees:  $600

4 – 6  Attendees:  $800

7 – 10  Attendees:  $1000

11-14  Attendees:  $1200


Our location: (18 King Street East)

2 Attendees: $450

3 Attendees:  $700

4 – 6  Attendees:  $1000

7 – 10  Attendees:  $1200

11-14  Attendees:  $1500


Your location: (GTA- Daily Rate) 

$800: Up to 6 attendees

$1000: 7 to 10 Attendees

11-14  Attendees:  $1500

Assuming each attendee will have access to a computer with the software installed. If PMVISION to provide laptops during the training, a $35 fee per laptop will be added

If the location is outside the Greater Toronto Area “GTA”, travel expenses to be added

Your location: (Outside GTA- Daily Rate) 

$800: Up to 6 attendees   + Travel expenses

$1000: 7 to 10 Attendees  + Travel expenses

11-14  Attendees:  $1500  + Travel expenses

Assuming each attendee will have access to a computer with the software installed. If PMVISION is to provide laptops during the training, a $35 fee per laptop will be added