Getting the key workbook out of one person’s head
The highest-value session in a manufacturing engagement is often restructuring the one workbook everything depends on so that a second person can maintain it.
Sun-Rype
Sun-Rype is named as a PowerConcepts client on our services page. This page is about how training gets scoped in a manufacturing business.
- Sector
- Food and beverage manufacturing
- Based in
- Kelowna, British Columbia
Sun-Rype is a Kelowna food and beverage manufacturer, and one of the better-known brands to come out of the Okanagan. Manufacturing businesses have a training profile that is unusually easy to read, because the spreadsheets tell you where the pain is.
Production planning, inventory, yield, waste and cost per unit are all things that end up in Excel regardless of what system the business officially runs. They are usually maintained by one or two people who built them, they are usually correct, and they are usually impossible for anyone else to pick up. That is a business risk long before it is a training request.
The work that helps most is rarely the advanced material people ask for. It is tables instead of ranges, named references instead of cell addresses, Power Query instead of monthly copy-paste, and enough structure that the workbook can be explained. Kelowna is also home turf — two of our instructors are based there, so on-site delivery is straightforward.
What tends to work for organisations like this
Replacing monthly rebuilds with refreshes
Production and inventory reporting is the textbook Power Query case: the same export, cleaned the same way, every month. Advanced Data Management is the course that addresses it.
Bookkeeping alongside Excel
Smaller manufacturers often run their books in QuickBooks or Sage in the same office. Training both sides together tends to sort out the reconciliation friction between them.
What this page does not say
It does not report what Sun-Rype was trained on, how many people took part, or what it saved them. Those numbers have not been published and we are not going to invent them — a fabricated result attributed to a real organisation is worse than a page with a gap in it.
Sun-Rype is named as a client on our services page, which is a claim the business already makes about itself. Everything above that line is about the shape of the problem rather than about this engagement. The index page explains the policy in full.
The relevant training
For an organisation of this shape the material that usually matters most is Excel training. How it gets delivered depends on where people are: On-site training, Live online training or Excel for teams.