Excel Courses in Newmarket
We offer 3 levels of Microsoft Excel training in Newmarket, Ontario. Click a course title for more information.
Microsoft Excel Training in Newmarket
There are two ways to schedule Microsoft Excel training in Newmarket, Ontario. Choose the delivery option that works best for your group.
Online Excel Training
Everyone on your team in Newmarket can learn Microsoft Excel online with a live instructor using Microsoft Teams or Zoom. Remote employees can connect from anywhere in Canada or the United States.
Onsite Excel Training in Newmarket, Ontario
Our instructor-led Microsoft Excel courses can be delivered onsite, in your organization’s meeting room or training room in Newmarket and select locations throughout Ontario.
Excel Level 1
Training for Excel 2016, 2019, and 365
1 day training 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.
Course Content
Getting Started with Excel
Introduction to 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.
Excel Level 2
Training for Excel 2016, 2019, and 365
Prerequisite: Excel Level 1
1 day training 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.
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.
Excel Level 3 Data Management
Training for Excel 2016, 2019, and 365
Prerequisite: Excel Level 2
1 day training 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.
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 for data analysis.
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.
Excel Level 3 Spreadsheet Analysis
Training for Excel 2016, 2019, and 365
Prerequisite: Excel Level 2
1 day training 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.
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 for data analysis, Solver options.
Auditing Concepts
Tracing a worksheet, evaluating formulas, locating and correcting errors in formulas, tracking cells in a workbook.