For people who use spreadsheets at work and quietly worry the totals at the bottom might be wrong. Past sessions have left attendees writing their own formulas the next working morning instead of waiting for the office spreadsheet person to free up.
If you have ever opened a spreadsheet at 4pm and realised you do not actually know whether the totals at the bottom are right, this day is built for you. Microsoft® Excel® 101 in St. Catharines is a single-day, in-person course for people who use Excel at work, get the job done eventually, and suspect there is a faster, more dependable way. There is.
I teach this course the way I wish someone had taught me in 1998: starting with how Excel actually thinks about a worksheet, then layering on the formulas, formatting, and habits that turn a fragile spreadsheet into one a colleague can open six months later and still trust. By the end of the day you will know why your formulas break, how to stop them breaking, and which twenty per cent of features cover roughly eighty per cent of office spreadsheet work.
This is foundational work. If your team has someone who is “the Excel person” by accident rather than training, send them. If that person is you and you are tired of being it alone, come yourself.
How the day runs
The session runs full-day in St. Catharines with two short breaks and a lunch hour. I teach a topic, you try it on a worked example, then we move on. I keep the group small enough that I can see your screen when you get stuck, and I budget real time for the questions that come up from your own work. If a topic clicks for the room early, we go deeper. If it does not, we slow down. The schedule serves the learning, not the other way around.
What you will leave with
You will leave able to build a worksheet that is readable on the first pass, write formulas that survive being copied into a new column, and clean up a messy data export without rebuilding it by hand. You also get a one-page reference sheet covering the layout, formula, and validation habits I want you to take back to your desk on Monday morning, plus the worked files from the day so you can repeat any exercise in your own time.
By the end of the day, you will be able to
- Write formulas that hold up when the data changes underneath them
- Spot the three most common reasons a spreadsheet quietly returns the wrong number
- Format a sheet so a colleague can open it cold and read it correctly
- Use the small set of Excel features that cover most everyday office work
- Set up a sheet that you can come back to in six months and still trust
A day that turns an occasional spreadsheet user into someone who trusts their own numbers, priced so a small team can send three people without flinching.
Register for this training event
Complete the registration form below and we will confirm seats, delivery details, and payment instructions.
Pricing (CAD) per student
| Team size | Price per student |
|---|---|
| 1–3 attendees | $250 |
| 4–6 attendees | $225 |
| 7–10 attendees | $200 |
Pricing is per student and excludes applicable taxes. Final confirmation is based on seat availability and delivery format.
A red asterisk means we need that one to confirm your seat. Everything else is optional and helps us tailor the session.
