How to Build a Staff Training Matrix With AI

List each role's tasks, ask AI to turn them into a skills list with levels (0 not trained, 1 supervised, 2 competent, 3 can train others) and refresh intervals, and lay it out with skills down the side, people across the top. Formulas flag expired training and skills only one person can do. Treat the AI's list as a draft.

A training matrix earns its keep in two ways: it shows which required training has lapsed, and it shows where the business depends on a single person. The second is usually the bigger surprise. AI speeds up the slowest parts (listing skills, writing level definitions, building formulas), but it knows nothing about your workshop and will happily add generic items you do not need while missing the ones specific to you. It will also state that a course is "legally required" with no basis for saying so. Legal requirements for training depend on the work and on where you operate; check them with a health and safety adviser, not a chat assistant.

Follow me on Instagram@sagnikteaches

The shape of a matrix, in miniature

Before building the full thing, it helps to see the idea at small scale. Rows are skills, columns are people, and each cell holds a level. A slice from an illustrative handmade jewellery workshop:

Connect on LinkedInSagnik Bhattacharya

Even four rows show something: only one person can do pavé setting unsupervised. If that person is off in the busiest month, pavé commissions stop. That is the kind of finding a matrix exists to surface.

Subscribe on YouTube@codingliquids

Step 1: Get the skills list out of people's heads

Write down each role and what the person in it actually does in a typical week. Ten minutes per role with the person doing it is better than an hour guessing. Then ask an assistant to turn the notes into a structured list.

I run a handmade jewellery business with 8 people. Roles and weekly tasks:
- Senior bench jeweller (2): bespoke rings, stone setting (claw, rub-over, pavé),
  soldering, ring sizing, repairs, laser welding, quality checks
- Junior bench jeweller (2): soldering, simple settings, sizing, casting clean-up,
  polishing
- Finisher (1): polishing, plating prep, cleaning, final inspection
- Dispatch and customer service (1): order processing, insured shipping, customer
  emails, handling customer-supplied stones on intake
- Content and photography (1): product photos, listings, social posts
- Owner/designer: consultations, CAD, buying metal and stones

Draft a training matrix skills list grouped as: Safety, Craft, Quality and
handling, Customer and admin. For each skill: a short name, which roles need it,
and a suggested refresh interval if it's a safety item (or "on change" if it only
needs retraining when equipment or process changes).
Don't say anything is legally required; mark items "check requirement" instead.

An illustrative extract of the reply:

SAFETY
Torch and gas cylinder safety        All bench roles        12 months
Acid pickle and chemical handling    Bench roles, finisher  12 months
Polishing motor safety               All bench roles        12 months
Laser welder operation and safety    Senior jewellers       12 months, check requirement
Fire safety and evacuation           Everyone               12 months
Manual handling                      Everyone               check requirement
Working at height                    Everyone               check requirement

CRAFT
Soldering; Claw setting; Rub-over setting; Pavé setting; Ring sizing;
Casting clean-up; Polishing and finishing; Laser welding

QUALITY AND HANDLING
Final inspection before dispatch; Precious metal weighing in and out

CUSTOMER AND ADMIN
Order processing; Insured shipping; Customer emails; Product photography

Useful, with three fixes typical of a first draft. "Working at height" is generic filler for a workshop where nobody climbs anything; delete it. The draft missed two things specific to this business: customer stone intake (logging, photographing and storing a customer's own diamond, which matters enormously if one ever goes missing) and bespoke consultations, which the owner wants a senior jeweller to cover. And the refresh intervals are the assistant's guesses. Some may be right; the insurer and a safety adviser decide which ones are required and how often.

Step 2: Define what each level means for each skill

"Competent" means different things to different people. The fix is a short definition per level, per skill, with evidence you can check. Ask the assistant to draft them and edit hard.

For the skill "Claw setting" in a small handmade jewellery workshop, write level
definitions for 0-3 (0 not trained, 1 can do under supervision, 2 competent alone,
3 can train and sign off others). For levels 2 and 3, include the evidence needed:
what the person must have done, how many times, and who checks it.
Keep each level to one or two sentences.

0: Has not been shown the technique.
1: Can set round stones of 4 mm and above in 4- or 6-claw settings with a senior
   jeweller checking each piece.
2: Has set at least 10 stones across round and oval shapes that passed final
   inspection first time, signed off by a level-3 jeweller.
3: At level 2 for 12 months or more, has trained someone to level 1, and has
   been approved by the owner to sign off others.

That is close to usable. The edits the owner made: the evidence for level 2 added "including at least three stones under 3 mm", since small stones are where claw work goes wrong, and level 1 added "knows when to stop and ask", because the costly mistakes come from pressing on with a stone that is not seated. Write definitions for the skills that matter most first; safety items can use a simpler pass or fail with a date.

Step 3: Build the grid and its formulas

Two tabs keep it tidy. Levels holds the skills and people with a level in each cell. Dated training holds anything with an expiry: person, item, date completed, refresh months, expiry, status. Either Excel or Google Sheets works; the formulas below run in both.

Dated training tab (row 2; B = date completed, C = refresh months):
Expiry (D2):   =IF(B2="","",EDATE(B2,C2))
Status (E2):   =IF(B2="","Missing",IF(D2<TODAY(),"Expired",IF(D2<TODAY()+30,"Due in 30 days","OK")))

Levels tab (skills in rows, people in columns D to K):
Competent people for the skill (L5):   =COUNTIF(D5:K5,">=2")
Single point of failure (M5):          =IF(L5<=1,"YES","")
Trainers available (N5):               =COUNTIF(D5:K5,3)

In Excel, EDATE returns a date serial number, so format the Expiry column as a date or it will show something like 46314. Add data validation to the level cells so only 0, 1, 2 or 3 can be entered, and conditional formatting so 0 and 1 show in one colour, 2 and 3 in another, and "Expired" or "YES" stand out. If you want the assistant to write these for your exact layout, give it the column letters and one sample row rather than the whole sheet, and test each formula on a row where you know the answer. Prompts for AI in Google Sheets has more on getting formulas written reliably.

Step 4: Mark what each role requires

A blank cell means nothing until you know whether the person needs the skill. Add a "required level" for each role and skill, then compare. The simplest version is a second grid of the same shape, holding the required level; a formula in a third grid shows the gap:

Gap (in the Gaps tab, same cell position):
=IF(Required!D5="","",MAX(0,Required!D5-Levels!D5))

A gap of 0 means the person meets the requirement. A gap of 1 or 2 is training to plan. Keep three categories visible, because they are handled differently: required safety items (fix before the person does the task again), role-required skills (plan within a quarter), and development skills (nice to have, done as time allows).

The jewellery workshop's matrix, filled in

With all eight people and 18 skills entered (levels from the owner, checked with each person), the gap and failure columns showed five things worth acting on:

None of this was news to everyone, but it had never been in one place, and nobody had noticed the first-aid expiry. The stone intake gap was the owner's biggest worry once seen: an unlogged customer diamond is the kind of mistake that ends a small jeweller's reputation.

Turning gaps into a training plan

You cannot fix everything at once, so score each gap. A simple score multiplies three ratings from 1 to 3:

• Impact: what happens if nobody can do it (3 = safety risk or lost orders, 1 = inconvenience).
• Coverage risk: 3 if one person or none can do it, 2 if two, 1 if three or more.
• Urgency: 3 if expired or needed within a month, 2 within a quarter, 1 later.

Then ask the assistant to draft the plan, with your constraints:

Here are five training gaps with priority scores (attached). Constraints: the two
senior jewellers can spare 3 hours a week each for training; the busy season starts
in 10 weeks; external courses need booking 4 weeks ahead.
Draft a 10-week plan: who trains whom, when, what evidence closes each gap, and
what I need to book. Put the highest scores first. Flag anything that can't fit.

A typical first draft schedules training in the weeks the owner already knows are full of commissions, and forgets that the person being trained also has a workload. Edit it with your calendar open. The useful part is the evidence column: "closed when finisher has logged 5 intakes checked by owner" is easier to track than "trained in stone intake".

Reminders that go out without anyone remembering

Expiry formulas only help if someone looks at them. Once the Dated training tab works, add a reminder so the right person hears about renewals a month ahead. Three ways, from simplest up:

• Calendar entries. When you record a completed course, add a calendar reminder for 30 days before expiry, assigned to the person and the owner. Low-tech and reliable for a small team.
• An automation. A scheduled Zapier or Make scenario reads the sheet each Monday, keeps only rows where the status is "Due in 30 days" or "Expired", and emails a short list. Filter steps cost nothing in Zapier, so the whole thing uses a few tasks or credits a week.
• A weekly summary. If you already get a weekly business summary by email, add the count of expired and due items to it.

A reminder worth copying, which an AI step can fill from the sheet:

Training due in the next 30 days:
- First aid certificate (Senior jeweller A): expires 18 Oct. Book course; 4 weeks' notice needed.
- Laser welder refresher (Senior jeweller B): due 2 Nov.
Expired:
- Acid pickle handling (Junior jeweller B): expired 3 Sep. No pickle work until refreshed.
Single points of failure: Pavé setting (1 competent), Customer stone intake (2).

The line "no pickle work until refreshed" is the important one. Decide in advance what an expired safety item means for the person's work, and say it in the reminder, so nobody has to make that call on the day.

A new starter's column on day one

The matrix doubles as an onboarding plan. When a new junior jeweller joins, add their column with the required level for the role in every row, and the gaps are the training list. In the illustration, the first four weeks came out like this:

Nothing on that plan had to be invented for the new person. The matrix already held the skills, the required levels, the definitions and who can train. That is the moment most owners decide the matrix was worth the afternoon it took.

Keeping the matrix true

A matrix that is correct on the day you build it and wrong six months later is worse than none, because people trust it. Three habits keep it honest:

1. A 15-minute monthly look. Filter the Dated training tab for "Expired" and "Due in 30 days", and scan the single-point-of-failure column. Book what needs booking.
2. Evidence for every level 2 and 3. A column noting who signed it off, when and on what evidence. "Owner, 12 Aug, 10 claw settings passed QC" is enough.
3. Update on events. A new starter gets a column on day one. A leaver's column is archived, not deleted, so you can see what left with them. New equipment adds a row.

New starters' first two weeks should draw straight from the matrix; planning a new starter's first two weeks with AI shows how. Written procedures make training quicker and more consistent, and writing SOPs with AI, including screen-recorded ones for the admin tasks, gives trainers something to teach from.

The matrix that says everyone is competent

The most common failure is a grid full of 2s and 3s that does not match reality. It happens when people rate themselves, or when the owner fills it in from memory in one sitting. It shows up later as a "competent" person making a basic mistake: in the illustration, a junior rated 2 in ring sizing stretched a ring with a stone already set, cracking it, which a genuinely competent jeweller would not do.

Two rules prevent it. First, self-ratings are only a starting point; level 2 and above need sign-off by someone at level 3 against the written definition. Second, when a quality problem happens, check the matrix for that person and skill. If they were rated competent, either the rating or the definition was wrong; fix whichever it was. Used this way, the matrix also makes performance reviews fairer, because the conversation is about defined skills and evidence, not impressions.

Spreadsheet or training software?

For a team of up to about 25 people, a spreadsheet with the tabs above does the job, and it has one big advantage: you understand every formula in it. Training or HR software starts to pay off when several managers sign off training, when you need people to upload certificates themselves, or when staff work across sites and the sheet keeps getting out of date. If you move, keep the same structure (skills, levels with definitions, evidence, dated items), because that structure is the real asset; the tool is just where it lives. Whichever you choose, keep one copy of the level definitions somewhere every trainer can read them.

Skills that belong in other small businesses' matrices

The method is the same everywhere; the rows are not. A few illustrations of rows that generic templates miss:

• A craft brewery: cleaning-in-place chemical handling, CO2 and confined-space awareness around fermenters, keg handling, forklift or pallet truck use if you have one, and allergen and hygiene rules for the taproom. Brewing skills can be split by stage: mash, boil, fermentation monitoring, packaging line.
• A farm shop with a butchery counter: knife skills and slicer safety, food hygiene at the level each role needs, allergen labelling for anything made or packed on site, and till and cash procedures. Seasonal staff need a short "day one" subset.
• A specialty coffee roaster: roaster operation (including chaff and fire risk), green coffee receiving and grading, cupping to a standard, grinder and packing machine safety, and wholesale café training if you support customers.
• An online clothing shop: goods-in checks, returns grading, picking accuracy, customer service tone and policy, and photography standards for listings.

For kitchens specifically, building a kitchen training manual with AI covers the manual side, and the safety rows in any matrix should line up with your risk assessments; drafting risk assessments with AI explains what a person must check in those.

Further reads

• Compliance Calendar: Track Licences, Insurance and Certificates — Track certificate renewals alongside licences and insurance.
• How to Write a Health and Safety Policy With AI and What to Check — Write the safety policy your required training supports.
• How to Write an Employee Handbook With AI and What to Check — Put training expectations and sign-off rules in the handbook.
• How to Train Staff to Use AI in a Small Business — Add AI skills to the matrix and train them properly.
• Opening and Closing Checklists: Build Them With AI in an Hour — Turn routine tasks into checklists new starters can follow.
• AI Literacy Requirements: What Your Staff Need to Know — What staff need to know about the AI tools they use.
• How to Create SOPs From Screen Recordings With AI — Record admin tasks once and turn them into training material.
• How Much Time and Money Does AI Staff Training Take? — Training hours by role, free and paid course options with current prices, a costed plan for an eleven-person decorating firm, and how to check it paid off.
• How to Build a Restaurant Staff Rota With AI Demand Forecasts — Turn a covers forecast into an hourly staffing plan and a fair rota, with a worked Saturday that shows the labour-cost difference in dollars and hours.
• How to Run Staff Surveys and Exit Interviews With AI Analysis — A 12-question survey, an exit interview script, anonymity settings, a theme-coding prompt with checks, and an online clothing shop's first round of results.
• How to Automate Holiday Requests and Absence Tracking — Build a leave request process that checks balances, protects shift cover and records changes without repeated messages.
• Capacity Planning With AI: Know When Your Team Is Full — Find the role, day or machine that limits your next booking, with a practical weekly capacity calculation and checked AI scenarios.
• How to Choose an AI Training Provider for Your Team — A bakery's 14 staff, three kinds of training quote and a syllabus test that catches out-of-date courses: a neutral method for picking AI training that sticks.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Microsoft Support and Google Docs Editors Help pages for the EDATE function; Zapier help on task counting for filter steps.