Free template
A restaurant training matrix template, and why the spreadsheet version goes stale
The template
Rows are people. Columns are stations. Add these five columns to the left of your stations first, because they are what make the grid answerable later.
- Name
- Primary station (what they are scheduled on by default)
- Start date (context for how far along they should be)
- Stations signed off (a count, so you can sort by who knows least)
- Last trained (the date of any training activity at all)
Then one column per station
In each cell, record four things rather than one. This is the entire difference between a matrix that is useful in a year and one that is decoration.
- Level: 0 not trained, 1 in training, 2 works it with support, 3 signed off to run it alone, 4 can train others.
- Date confirmed: when a trainer last saw them do it.
- Confirmed by: which trainer. Unattributed sign-offs stop being trusted the moment two managers disagree.
- Expires: date confirmed plus your re-check interval for that station.
Two formulas worth adding
Under each station column, count the cells at level 3 or above. That row is your coverage, and any station showing 1 or 2 is a scheduling emergency waiting for a call-out. Then conditionally format any cell whose expiry date has passed, so stale sign-offs turn a colour instead of quietly reading as a pass.
What breaks, and roughly when
Month one: it works
You will find two or three coverage gaps you did not know about in the first sitting. This is real value and it is why the exercise is worth doing even if you never touch the file again.
Month two: freshness drift
Training happens on the line at 7pm. The file is on the office laptop. The update depends on somebody remembering at close, after a long shift, to open a spreadsheet. Some nights that happens. The nights it does not are invisible, which is the problem: you cannot see which cells are behind.
Month three: two versions
Somebody makes a copy to work on. A second manager starts their own for their own shifts. Now there are two grids that disagree and no way to tell which is right, and the usual resolution is that everybody quietly stops trusting both.
Whenever a manager leaves
The cells they filled in were shorthand for judgements only they could reconstruct. Nobody else knows whether their level 2 meant the same as yours.
How to make a spreadsheet version last longer
- One file, one owner, shared and never copied.
- Update at the end of every shift where training happened, not weekly. Weekly means from memory.
- Never allow a level without a date and a trainer name in the same cell.
- Review the coverage row in your weekly manager meeting, so somebody looks at it on a schedule.
- Re-check anything past its expiry date before you treat it as coverage.
Done properly, that gets a single store a surprisingly long way. What it cannot survive is more than one location, or more than a couple of people entitled to sign off.
Common questions
What is a training matrix?
A grid with employees down one side and skills or stations across the top, showing how far along each person is on each. In a restaurant the columns are stations: fry, grill, expo, register, bar, prep, open, close. Reading down a column gives you coverage on that station; reading across a row gives you one person's flexibility.
What columns should a restaurant training matrix have?
One per station, plus four fields per cell that carry all the value: the level, the date it was last confirmed, the trainer who confirmed it, and whether it has expired. Most templates only have the level, which is why they cannot answer 'is that still true'.
What levels should I use in a training matrix?
Four is the sweet spot: not trained, in training, can work it with support, and signed off to run it alone. Some operators add a fifth for 'can train others', which is genuinely useful because it tells you who your coaches are. More than five levels and nobody applies them consistently.
Is a spreadsheet training matrix good enough?
For a single store with one manager doing all the training, yes, for a while. It stops being enough when more than one person signs off, when you have more than one location, or when nobody can remember whether a cell is current. The failure is always freshness, not the format.
How often should a training matrix be updated?
The instant a sign-off happens, which is the whole problem: that moment is on the floor mid-shift and the file is in the office. Any process that depends on reconciling the two later will drift. If you keep it in a spreadsheet, update it at the end of every shift where training happened, and put one named person on it.
Or skip the maintenance entirely
CrewSharp's matrix is a view over the evaluations your trainers already record on the floor, so the level, the date and the trainer land in the cell without anybody opening a file.
14 days free. No card to start. Cancel in one click.
Keep reading
Cross-training matrix software
The same grid, kept current from the floor instead of by hand.
How to cross-train restaurant staff
What to do with the gaps the grid just showed you.
Build a training program
Defining what a level 3 actually means before you record any.
New hire training checklist
How somebody gets from level 0 to level 3 in the first place.