Excel training for your whole team: onsite vs. webinar vs. self-paced

Most Excel training decisions start the same way. Someone in finance or operations mentions that the monthly numbers take three days longer than they should, a manager traces it back to four people who all learned Excel by watching the person next to them, and the question lands on an HR or office manager's desk: what do we do about Excel?

There are three real answers to that question, and they cost very different amounts once you count everything. I want to lay them out honestly, including the cases where I am not the right choice.

The three options, plainly

A public webinar or public classroom seat. You buy seats. Each person registers, blocks a day, and attends a session built for a room of strangers from twenty different organizations.

Self-paced video. You buy licences to a library. Staff work through lessons when they have time.

Onsite group training. One instructor comes to your office and teaches your people together, on your machines, using your files.

All three teach Excel. What separates them is not the content list, which looks nearly identical on every provider's page. It is what happens to the learning afterward.

What a webinar actually costs you

The per-seat fee is the number that shows up in the budget request, and it is the smallest part of the total.

Take whatever per-seat figure you have been quoted and multiply it by the number of staff who need the training. Then add the part nobody puts on the purchase order: each of those people is out of the office for a day, and they are out on the webinar provider's date, not yours. If the only available session is the third Tuesday of the month and the third Tuesday is when your payables run, you either send people anyway or you wait six weeks.

Then add the travel, if it is a classroom seat rather than a webinar. Mileage, parking, sometimes a hotel if the nearest session is in Toronto and you are not.

Then add the part that actually determines whether the money worked: the follow-through. A public Excel class teaches Excel on a sample workbook built by the trainer. Your staff learn a lookup formula against a made-up product list, go back to the office, open the real workbook with the merged cells and the sixteen tabs and the column that has been text instead of a number since 2019, and the transfer does not happen. Two weeks later the habits are back.

Where self-paced video genuinely wins

I am not going to tell you self-paced video is useless. It is excellent for one specific job: refreshing a skill someone already learned once, on demand, at the moment they need it. If a staff member half-remembers how PivotTables group by month, a four-minute video is the correct tool and a training day is overkill.

Where it fails is starting from zero. In every session I have taught, the people who tried a video library first and gave up say the same thing: nobody was in the room when they got stuck, and getting stuck in Excel is silent. The formula returns a number. It is the wrong number. Nobody notices for a quarter.

What changes when the instructor comes to you

This is the part worth understanding, because it is the whole argument.

Think about learning to drive. You can watch videos about parallel parking, and you can take a lesson in the driving school's car on the driving school's practice route. Both help. Neither is the same as an instructor sitting beside you in your car, on the road you actually drive to work every morning, saying "no, not that lane, and here is why."

Onsite training is the instructor in your car. We open your budget template, not a sample one. When someone says "but ours has the department codes in column A and it breaks the total," we fix that, in front of everyone, and the fix is now a thing your team owns. The person who rebuilds the same report from a blank sheet every month, because they never trusted the version that already had the formulas in it, gets caught and corrected on day one, which is worth the session on its own.

You also get scheduling on your terms. The date is your date. Nobody travels. If the training runs from nine to three at your boardroom table, the team is back at their desks the same afternoon, on the same machines they just trained on.

What it costs here, with no games

I publish pricing on every course page. The Excel levels are listed at $1,495 to $2,990 CAD per session. That is a session price for a group, not a per-seat price, and where it lands inside the range depends on group size and scope. You get the number in writing before anything is booked, and there are no setup fees underneath it.

The arithmetic matters more than the number. A session price stays roughly flat as you add people. A per-seat price does not. Somewhere around the fourth or fifth staff member, the two lines cross, and after that point the onsite session is simply cheaper for a better result.

An honest version of when not to book me

If the real problem is a broken workbook rather than a skills gap, training is the wrong purchase. A workbook held together with hidden columns and a macro nobody remembers writing needs a rebuild, not a class. Fix the workbook first, then train the people who will maintain it.

If you have one power user who already needs 401-level work, Power Query and a real data pipeline, and the rest of the team just needs 101, do not put them in the same room. Book two sessions at the right levels rather than one session that bores half the group and loses the other half.

And if your finance team is mid-close, or your busiest week of the quarter is the only week anyone can find on the calendar, wait. A group that is watching the clock does not absorb an absolute reference no matter how well it is taught.

Picking the right level

The Excel track runs as a ladder, and most teams do not start at the bottom. Read the "who this is for" section on each page and pick the one where your staff sit, or tell me what your people currently do with Excel and I will point you at the right level.

• Microsoft Excel training 101 - formulas, absolute references, and printing a sheet that reads cleanly.
• Microsoft Excel training 201 - charts, formulas that survive a column insert, and a first working macro.
• Microsoft Excel training 301 - Tables, lookups, and PivotTables for turning long lists into answers.
• Microsoft Excel training 302 - forecasts and budgets with what-if scenarios, Solver, and auditing.
• Microsoft Excel training 401 - a dashboard that refreshes with one click, built on Power Query.

Not sure which one? Send me a description of what your team does with Excel and what you want them able to do afterward, and I will tell you which level fits, including if the answer is that you do not need me yet.