Microsoft Excel Training Courses | Introduction Level – Toronto


Corporate and Groups Special Rates

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

Upcoming  Classes:  10 a.m- 5 p.m. EST

Monday, May 27  (10:00 a.m.- 5:00 p.m. EST)  (Online)

Monday, June 17 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Monday, June 24 (10:00 a.m.- 5:00 p.m. EST)  (Online)

Monday, July 22 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Monday, July 29 (10:00 a.m.- 5:00 p.m. EST)  (Online)

Monday, Aug 19 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Monday, Aug 26  (10:00 a.m.- 5:00 p.m. EST)  (Online)

Monday, Sep 23 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Monday, Sep 30  (10:00 a.m.- 5:00 p.m. EST)  (Online)

Monday, Oct 28 (10:00 a.m.- 5:00 p.m. EST)  (Toronto)

Monday, Oct 28 (10:00 a.m.- 5:00 p.m. EST) (Online)


Wednesday, TBA (Mississauga)

Wednesday, TBA (Barrie)

Course Fee:  In Person: CAD $275   Online:  $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


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


This MS. Excel course aims to provide students with a foundation for Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation.

Training Type:  Classroom Training – Downtown Toronto ” Also available in Mississauga and Scarborough”

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

Course Level:  Excel Introduction Class

Related Excel TrainingExcel Intermediate Level 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 365 (Windows)

Locations:   Toronto ( 18 King St East),  Also we offer the course in Mississauga, Scarborough, Hamilton, and Barrie. Mississauga ( 55 Village Centre Pl, Mississauga, ON L4Z 1V9).  Barrie” at Georgian College (One Georgian Dr. Barrie, ON L4M 3X9) “. Ottawa (38 Auriga Drive, Suite 200, Ottawa, Ontario, K2E 8A5)


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 2013, 2016, Excel 2019, or Excel 365 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:

At our location:

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

At your location:  Rate per day (level)

  •  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”, the Travel fee is to be added



A working knowledge of Windows is required. No experience with MS Excel is required. If you have basic knowledge of Microsoft Excel, you can improve your skills by taking our Microsoft Excel Intermediate Level Class



This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets



Upon successful completion of this course, you will have a good working knowledge of Excel basics. You will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will: Get started with Microsoft Office Excel. Perform calculations. Modify a worksheet. Format a worksheet. Print workbooks. Manage workbooks.

At the completion of this course you should be able to:

  •  navigate your way around Microsoft Excel
  •  create and work with a new workbook
  •  open and navigate within workbooks and worksheets
  •  make changes to data in a workbook
  •  understand and work with ranges in a worksheet
  •  copy and paste data in Excel
  •  use the fill operations available to fill a data series
  •  move the contents of cells and ranges within and between workbooks
  •  understand, create and work with formulas and functions
  •  understand and use formula cell referencing
  •  use font formatting techniques
  •  align the contents of cells in a number of ways
  •  understand and use the number formatting features in Excel
  •  format rows and columns in a worksheet
  •  work with elements that make up the structure of a worksheet
  •  sort data in a list in a worksheet
  •  filter data in a table
  •  print your workbook data
  •  create effective charts in Microsoft Excel
  •  obtain help with Excel whenever you need it
  •  understand points to consider to avoid problems in your worksheets



A Guide to Brilliant Spreadsheets

Getting to Know Excel

  • Starting Excel
  • Excel Start Screen
  • The Excel Workbook Screen
  • How Excel 2019 Works
  • The Ribbon
  •  Collapsing the Ribbon
  • The Backstage View
  • Accessing the Backstage View
  • Shortcut Menus
  • The Dialog Boxes
  • The Quick Access Toolbar
  • The Status Bar
  • Exiting Safely From Excel

Creating a New Workbook

  •  Excel Workbooks
  • The Blank Workbook Template
  • Typing Text
  • Inserting Numbers
  • Inserting Dates
  • Inserting Formulas
  • Easy Formulas
  • Saving a New Workbook
  • Spell Checking
  • Making Basic Changes
  • Safely Closing Excel Workbook

Working With Workbooks

  • Working with Existing Excel Workbook
  • Navigating a Workbook
  • Navigating Using the Keyboard
  • Using Go To
  • Recent Files and Folders
  • Editing in a Workbook
  • Data Editing
  • Overwriting Cell Contents
  • Editing Longer Cells
  • Editing Formulas
  • Clearing Cells
  • Deleting Data
  • Undo and Redo

Selecting Ranges

  • Excel Cells and Ranges
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns

Copying Data

  • Copying in Excel
  • Fill for Quick Copying
  • Copying From One Cell to Another
  • Copying From One Cell to a Range
  • Copying From One Range to Another

Filling Data

  • Filling in Excel
  • Filling a Series
  • Filling a Growth Series
  • Extracting With Flash Fill

Moving Data

  • Moving in Excel
  • Moving Cells and Ranges
  • Moving by Dragging

Formulas and Functions

  • What are Excel Formulas?
  • The Add Formulas
  • The Subtract Formulas
  • Multiply and Divide Formulas
  • What are the Excel Functions
  • Using the SUM Function to Add
  • Summing Non-Contiguous Ranges
  • Calculating an Average
  • Finding a Maximum Value
  • Finding a Minimum Value
  • Creating More Complex Formulas
  • What if Formulas
  • Common Error Messages

Formula Referencing

  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References

Font Formatting

  • Font Formatting
  • Working With Live Preview
  • Changing Fonts
  • Changing Font Size
  • Growing and Shrinking Fonts
  • Making Cells Bold
  • Italicizing Text
  • Underlining Text
  • Changing Font Colors
  • Changing Background Colors
  • Using the Format Painter

Cell Alignment

  • Cell Alignment in Excel
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells

Number Formatting

  • Number Formatting
  • General Formatting
  • Formatting for Money
  • Formatting Percentages
  • Formatting as Fractions
  • Formatting as Dates
  • The Thousands Separator
  • Increasing and Decreasing Decimals

Row and Column Formatting

  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting the Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights

Working With a Worksheet

  • Excel Worksheets
  • Changing the Worksheet View
  • Worksheet Zooming
  • Viewing the Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting Cells Into a Worksheet
  • Deleting Cells From a Worksheet
  • Inserting Columns Into a Worksheet
  • Inserting Rows Into a Worksheet
  • Deleting Rows and Columns
  • Working With Multiple Worksheets
  • Worksheet Wisdom

Sorting Data

  • Excel Lists
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Sorting on More Than One Column

Filtering Data

  • Filtering in Excel
  • Applying and Using a Filter
  • Clearing a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards


  • Printing in Excel
  • Previewing Before You Print
  • Selecting a Printer
  • Printing a Range
  • Printing an Entire Workbook
  • Specifying the Number of Copies
  • The Print Options

Creating Charts

  • The Charting Process in Excel
  • Selecting the Right Chart
  • Recommended Chart
  • Creating a New Chart From Scratch
  • Working With an Embedded Chart
  • Resizing a Chart
  • Repositioning a Chart
  • Printing an Embedded Chart
  • Creating a Chart Sheet
  • Changing the Chart Type
  • Changing the Chart Layout
  • Changing the Chart Style
  • Printing a Chart Sheet
  • Embedding a Chart Into a Worksheet
  • Deleting a Chart

Getting Help

  • How Help Works in Excel
  • Using Tell Me
  • The Help Window
  • Navigating the Help Window
  • Using Google to Get Help
  • Printing a Help Topic
  • Other Sources of Assistance


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)

To promote Green , printed handouts will not be available. If you have plans to print your own hard copy, when printing, choose multiple slides (2 – 4) on one page to save on paper.


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 the class is cancelled by PMVISION
  • In case PMVISION  cancels an event, 100% refund will be paid to the delegate.
  • If the cancellation is done by the delegate within 48 hours of subscribing, 10%  will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or more, prior to the event, 20% will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or less, prior to the event, no refunds will be made
  • Bookings made at discounted prices ( Including Early Bird Booking) cannot be cancelled.
  • If you will have to travel to attend the course, please don’t make any travel arrangements until we confirm the class. We usually usually confirm the class by emails at least one week prior to 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.

At our location: (1 Yonge Street)

2 Attendees : $450 ( $225 each)

3 Attendees:  $600 ( $200 each)

4 – 6  Attendees:  $800


At your location: ( GTA- Daily Rate) 

$800 : Up to 6 attendees

$1000: Up to 12 Attendees

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

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

At your location: ( Outside GTA- Daily Rate) 

$800 : Up to 6 attendees   + Travel expenses

$1000: Up to 12 Attendees  + Travel expenses

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



Tax to be added