Microsoft Excel Training in Toronto and Ottawa

Microsoft Excel training

We offer 3 levels of Microsoft Excel training.

Excel Level 1
Details | Request Quote

Excel Level 2
Details | Request Quote

Excel Level 3 Data Management
Details | Request Quote

Excel Level 3 Spreadsheet Analysis
Details | Request Quote

Online Excel Courses with a Certificate

Each of our Microsoft Excel courses are available in the Online LIVE format. Sessions are led by an experienced trainer. Participants receive a student manual, practice files, and a certificate upon completion of the course.

Excel Level 1

1 day course – $275 per person plus HST. Minimum enrollment required. Discounted pricing is available for groups of 6 or more, non-profit organizations, and Government of Canada employees.

Training available for Excel 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE. Contact us for a quote!

Course Content

Getting Started with Excel 2019
Understanding spreadsheet concepts, getting started, creating and saving workbooks, opening and closing workbooks.

Modifying Worksheets
Working with columns and rows, working with cell contents.

Using Formulas and Functions
Creating and using formulas, creating and using functions, using absolute cell references, inserting functions.

Formatting and Viewing Worksheets
Formatting worksheets, viewing worksheets.

Printing Workbooks
Using workbook views, changing the page setup, previewing and printing workbooks.

Back to Top


Excel Level 2

1 day course – $275 per person plus HST. Minimum enrollment required. Discounted pricing is available for groups of 6 or more, non-profit organizations, and Government of Canada employees.

Training available for Excel 2013 / 2016 / 2019 or Excel for Office 365. Prerequisite: Excel Level 1. Delivery via Online LIVE. Contact us for a quote!

Course Content

Worksheet Organization
Managing range names, creating and using workbook templates, applying worksheet security, creating and using outlines.

Advanced Formulas
Using the IF function, using the IFS function, linking formulas, modifying and restoring links.

Using Multiple Workbooks and Worksheets
Working with multiple workbooks, working with multiple worksheets, consolidating data.

Working with Charts
Creating charts, changing chart data, modifying chart elements, creating custom charts.

Applying Formatting
Working with styles, annotating worksheets, using sparklines.

Back to Top


Excel Level 3 Data Management

1 day course – $275 per person plus HST. Minimum enrollment required. Discounted pricing is available for groups of 6 or more, non-profit organizations, and Government of Canada employees.

Training available for Excel 2013 / 2016 / 2019 or Excel for Office 365. Prerequisite: Excel Level 2. Delivery via Online LIVE. Contact us for a quote!

Course Content

Maintaining Data
Data list and excel table concepts, using data forms, using lookup tables.

Sorting Lists
Sorting concepts, sorting lists, custom sort orders.

Filtering Lists
Filtering concepts, using AutoFilter, using advanced filter, working with filtered data.

Summarizing Data
Automatic subtotals, working with subtotalled lists ; using functions to summarize data.

Working with PivotTables
PivotTable concepts, creating PivotTables, modifying PivotTable layouts, working with PivotTables, PivotCharts, slicers.

Working with External Data
External data concepts, importing query data from Access, importing query data from web pages, importing query data from text files, importing text files using the import wizard.

Back to Top


Excel Level 3 Spreadsheet Analysis

1 day course – $275 per person plus HST. Minimum enrollment required. Discounted pricing is available for groups of 6 or more, non-profit organizations, and Government of Canada employees.

Training available for Excel 2013 / 2016 / 2019 or Excel for Office 365. Prerequisite: Excel Level 2. Delivery via Online LIVE. Contact us for a quote!

Course Content

Using Functions
Function concepts, absolute and mixed references, financial functions.

Projecting Figures
Goal Seek, data tables.

Performing What-If Scenarios
Scenario concepts, creating scenarios, managing scenarios ; scenario reports.

Using Solver
Solver concepts, defining the problem, solving the problem, Solver reports, Solver options.

Auditing Concepts
Tracing a worksheet, evaluating formulas, locating and correcting errors in formulas, tracking cells in a workbook.

Back to Top


Microsoft Excel is a registered trademark of Microsoft Corporation. onsite‑training.com provides Excel training but is not affiliated with Microsoft.