Excel Courses in Canada: Live Online Training

Choose an Excel course by the work you need to do: build a reliable workbook, improve formulas, summarise data, prepare repeatable reports or automate a task. The nine-course catalogue offers separate paths for functions, data management, dashboards and macros.

Introduction to Excel starts with worksheets, data entry and basic formulas. Intermediate 1 builds a budget using tables and references; Intermediate 2 adds charts, named ranges and more flexible functions. Advanced Functions develops multi-argument formulas, while Expert Functions moves into modern spill functions and dynamic arrays.

For reporting, Advanced Data Management covers validation, PivotTables, PivotCharts and slicers. Expert Data Management is the Power Query and Power Pivot course. Dashboard and Macros and Forms address different tasks, so choose the path that matches your work rather than treating every expert course as a required sequence.

The Excel courses

Compare 9 Excel course options
Course	Level	Next dates	Price	Register
Introduction to ExcelWorkbook and worksheet navigation · Entering and selecting data · Autofill and basic formulas	Introductory	Live schedule	On schedule	Dates & fees
Excel Intermediate 1Build and format a budget worksheet · Excel tables, sorting and filtering · Absolute and relative references	Intermediate	Live schedule	On schedule	Dates & fees
Excel Intermediate 2Create and customise charts · Table functions, filters and slicers · Table total rows and named ranges	Intermediate	Live schedule	On schedule	Dates & fees
Excel Advanced Data ManagementCollect data with validation and pick lists · Remove duplicates and highlight invalid data · Advanced filters	Advanced	Live schedule	On schedule	Dates & fees
Excel Advanced FunctionsUse tables and named ranges together in formulas · Apply ranges and references in functions · Conditional logic and data summaries	Advanced	Live schedule	On schedule	Dates & fees
Excel Expert DashboardCreate PivotCharts · Connect slicers to multiple datasets · Create and configure a dashboard	Expert	Live schedule	On schedule	Dates & fees
Excel Expert Data ManagementImport data with Power Query · Clean irregularly formatted data · Connect to data sources	Expert	Live schedule	On schedule	Dates & fees
Excel Expert FunctionsDynamic arrays and spill functions · Functions that expand with new data · Advanced TrimRange options	Expert	Live schedule	On schedule	Dates & fees
Excel Expert Macros and FormsCreate macros · Review VBA and understand modules · Compile and make minor edits to VBA code	Expert	Live schedule	On schedule	Dates & fees

Where each course sits

Use these links to compare the course outlines. Check the starting skills on each course before booking.

Scroll the diagram sideways to see the full path.

If you are not sure which of these you are ready for, the skill assessment asks eight questions about what you already do and recommends one. It takes about five minutes and asks for nothing in return.

Who teaches this

Frank Byl — Microsoft Master Instructor

Teaches Excel, Office 365, SharePoint, Project. Read the full bio and meet the other instructors, including how the CAFE method structures a class.

What comes with the course

90 days of video-library access, with the exercise files from class.
A free retake for one year — the same course again, at no charge.
No more than 10 people in a public class.
In person or live online, with the same hands-on format either way.

Training several people at once? Corporate training is scoped to your team's skill mix and built around your own files, which for a group is almost always the better format.

Excel training questions

How do I choose a suitable course?

Compare the tasks in each outline with the work you need to do. Check starting skills and software versions, then contact us if you need help choosing a level.

Where can I see current dates and fees?

Each course links to its booking page. Choose a session there and review the time zone, delivery details, currency and final fee before registering.

Can our team arrange private training?

Yes. Contact us with your team size, current skills, software and the work you want to improve so we can discuss an appropriate training scope.

Free guides on this

Course
Excel Pivot Tables and Data Validation Course
Prepare reliable Excel data and summarise it with PivotTables and PivotCharts. This course covers data validation, duplicates, advanced filters and slicers; the separate Expert Data Management course covers Power Query and Power Pivot.
Course
Excel Expert Functions Course
Extend an established Excel formula skill set with modern functions that expand as data changes. The expert course covers spill functions, TrimRange options, financial functions and lookup or reference functions.
Free guide
How to use Excel, from a blank sheet to your first real report
Excel is easy to start and easy to build wrong. This is the path from a blank sheet to a report that updates itself, in the order that stops you having to redo it later.
For teams
Excel Training for Teams and Businesses
Plan Excel training around your team’s starting skills, recurring spreadsheet tasks and the results learners need to check.

Choose Excel training by the work you need to do

Start with the workbook task that takes too long or produces unreliable results. Someone learning first formulas needs a different starting point from someone combining monthly exports or maintaining a dashboard.

Use the course ladder to compare the published topics and prerequisites. Data Management focuses on organising and summarising records; the Functions pathway develops calculation skills. If both matter, explain your current method and choose the foundation that lets you practise successfully.

Learning in a live online class

Set up the meeting window beside Excel so you can hear an explanation and then try it yourself. A second screen can help, but it is more important to practise switching between the workbook and the meeting controls. Before the session, open the exercise files and confirm that your microphone and screen-sharing permissions work.

Use a small budget as a readiness check: enter a quantity, add a unit price and calculate the total. If you can explain where the workbook is saved and return to the right worksheet, you are ready to compare the Excel course levels below.

Booking from Canada

Choose the course by its outline, then check the session’s date, stated time zone and delivery method on the registration page. A Canadian business address does not tell you when a particular class starts in your own city. Ask for the complete fee and tax details before arranging employer reimbursement.

For several provinces in one team, put each learner’s local attendance window in the enquiry. That makes it easier to discuss a shared session or separate groups without assuming every learner works on the same schedule.

How much learning time to reserve

The listed Excel courses generally allocate four hours to an individual course. That describes the course session, not the time it takes to become comfortable applying every tool at work. Reserve a separate practice block with a workbook you can safely edit.

The dashboard course has conflicting duration statements in its source listing, so confirm its length before reserving time. When combining levels, check the dates for each course and leave enough space to practise the first set of skills before progressing.

Choose the level by a task you can complete

Try creating a small table, writing a calculation and copying it down without changing a fixed reference. If those actions are unfamiliar, compare Introduction to Excel and Intermediate 1. If they are comfortable, decide whether your next need is more flexible formulas or better ways to collect and summarise data.

Expert Functions explicitly builds on Advanced Functions or equivalent experience. Expert Data Management explicitly builds on Advanced Data Management or equivalent. Other suggested sequences should help you choose, rather than acting as invented admission requirements.

Make the practice files part of your learning

Download the course files before the session and keep an untouched copy. Work in a second copy so that an experimental formula or formatting change cannot remove your starting point. Name your versions by exercise and date instead of repeatedly saving over one file.

After class, recreate one result without the recording, then use the video to find the step you missed. The published public-course package includes exercise files and 90 days of course video access; use the resources link for the supplied materials.

Check cancellation terms before booking

Read the cancellation and transfer conditions presented for the actual session before paying. Record the deadline, how a change must be requested, whether a replacement attendee is allowed and what happens if Power Concepts changes the session. Do not assume that a retake benefit is a refund policy.

If your employer is purchasing several places, ask who must notify the provider when a participant changes. Keep the registration confirmation with the approval so that the person managing attendance has the applicable terms rather than a remembered summary.

Use the retake to reinforce the same course

The published public-course benefit allows a free retake of the same course for one year. It is useful when you have practised at work and can return with more specific questions. It should not be treated as permission to move into a different course or as a guarantee that every preferred date has a place.

Keep your original registration details and ask Power Concepts how to arrange the retake. Before attending again, list the two or three tasks you still find difficult so the repeat session has a clear purpose.