Tight Ship
All tools

Onboarding and Training

Training and Certification Tracker

Employee training tracker in Excel for service companies with a field crew.

It puts each person's licenses, certifications and training in one place and counts what has expired or comes due in the next 90 days.

$12.00

Buy now

Pay once. No subscription.

If a file won't open, won't work on your computer or Microsoft plan, or isn't what the page described, we fix it or refund you, your choice. Tell us within 14 days of your purchase.

Questions? Email support@tightshiphq.com

  • Made for Excel, not Google Sheets.
  • No reminders: nothing is emailed or texted.

How you use it

  1. 3EXPIRED

    Sample data

    Coming due, next 12 months

    Oct2
    Nov4
    Dec3
    Jan4
    Feb1
    Mar2

    Step 1. Open the sample-data copy first.

    It shows how it all fits together.

    A sample-data copy filled with a made-up crew, so you can click around before adding your own.

    See the real screen: Dashboard

  2. Settings

    Sample data

    Company name
    Brightline Field Services
    Due soon window (days)
    60

    CREDENTIAL TYPES

    Credential typeRenewal ruleMonthsCE hours to renew
    EPA 608No expiry
    NATEEvery N months2416
    Journeyman licenseEnter the date
    Master licenseEnter the date
    NICETEnter the date
    OSHA 10Enter the date

    Step 2. Save the blank tracker where you keep your work files.

    On its Settings tab, type your company name and check the credential types and their rules.

    The Settings tab: company name, as-of date, a 60-day Due soon window, and 10 credential types with renewal rules.

    See the real screen: Settings

  3. People

    Sample data

    NameRoleTradeDrives company vehicle
    Ray DelgadoLead technicianHVACYes
    Kim LarsenService technicianHVACYes
    Ben OkoroService technicianHVACYes
    Wes HarmonInstall technicianHVACYes
    Tess AveryApprentice or helperHVACNo
    Jon PruittService technicianElectricalYes

    Step 3. Add your crew on People.

    A People tab with role, trade, phone, email, hire date, status, and whether they drive a company vehicle.

    See the real screen: People

  4. Credentials

    Sample data

    PersonCredential typeExpiresDays leftStatus
    Rick SalazarOSHA 30Needs a date
    Janelle OrtizMaster license2/28/27136Current
    Janelle OrtizOSHA 308/14/27303Current
    Janelle OrtizDriver's license11/2/2618Due soon
    Tom BeckerNICET12/1/2647Due soon
    Tom BeckerOSHA 105/5/26-163Expired

    Step 4. Add each license or certification on Credentials.

    Use the dates from the card.

    The Credentials tab: one row per license or card. Person, type, issued and expires are typed in; days left, status and CE hours logged fill in by formula.

    See the real screen: Credentials

  5. Training Log

    Sample data

    PersonCourse or topicHoursNext dueDue status
    Wes HarmonLadder safety11/14/27Scheduled
    Derek FongConfined space awareness411/4/26Due soon
    Jon PruittArc flash awareness810/2/26Overdue
    Cole JensenFall protection49/18/26Overdue
    Tom BeckerAerial lift safety412/5/26Due soon
    Abby KlineLadder safety19/30/27Scheduled

    Step 5. Log each class on the Training Log.

    A Training Log for every class, with hours, trainer, and next due date.

    See the real screen: Training Log

  6. Training and Certifications

    Sample data

    EXPIRED, DUE IN 30 DAYS, OR NO DATE · soonest first

    • Tom Becker · OSHA 10 · expired 5/5/26
    • Kim Larsen · NATE · expired 9/30/26
    • Wes Harmon · Driver's license · expired 10/9/26
    • Cole Jensen · Driver's license · due 10/28/26 · 13 days

    TRAINING DUE · soonest first

    • Cole Jensen · Fall protection · overdue since 9/18/26
    • Jon Pruitt · Arc flash awareness · overdue since 10/2/26
    • Derek Fong · Confined space awareness · due 11/4/26 · 20 days

    Step 6. Each week, open the Dashboard.

    Work the two lists at the bottom.

    Open the Dashboard each week: its two lists show what has expired, is due in the next 30 days, or is missing a date, and which training is due.

    See the real screen: Two lists

Drawn from the sample data in the file. Each step links to the real screen. Made-up data only, in every file and every image.

What's included

  • Training and certification tracker workbook, blank and ready to use, with seven tabs: Start Here, Dashboard, Crew Matrix, People, Credentials, Training Log, and Settings
  • A sample-data copy filled with a made-up crew (15 people, one marked Left; 46 credential rows; 22 training rows), so you can click around before adding your own
  • A one-page quick-start PDF
  • A start-here text file

Before you buy

  • Needs Excel for Microsoft 365 or Excel 2021 or newer. Checked in desktop Excel for Microsoft 365 on Windows.
  • Not tested yet in Excel for the web or Excel for Mac.
  • Not for Google Sheets, Apple Numbers, or Excel 2019 and older.
  • No reminders: nothing is emailed or texted. The workbook shows what's due when you open it.
  • No state license rules are built in. You type the date from each card or license.
  • Delivered as one .zip file. Unzip it first, then open the Quick Start PDF.
  • Digital download. Nothing is shipped.

A person makes every decision

This is a workflow and organizing tool for your crew's training and credential records. It doesn't know your state's license rules, and it doesn't decide who is qualified for a job: you check each date against the card and the rules that apply to you. Not legal advice. Check your state and local rules.

Questions

Does it send reminders?

No. Nothing is emailed or texted. Open the Dashboard each week: its two lists show what has expired, is due in the next 30 days, or is missing a date, and which training is due.

Does it know my state's license rules?

No. No state rules are built in. Journeyman, master, backflow tester, and the other license types use the date you type from the license or certificate. Not legal advice. Check your state and local rules.

Can I add my own credential types?

Yes. Type a new one under the last row of the credential types on Settings and pick its renewal rule; the dropdowns follow. To delete one, right-click it, then Delete, Table Rows. The by-type chart on the Dashboard shows the first 10 types, and the Dashboard table and the Crew Matrix show the first 16.

Does this work in Google Sheets?

It's built for Excel, not Google Sheets. It needs Excel for Microsoft 365 or Excel 2021 or newer, and it isn't made for Google Sheets, Apple Numbers, or Excel 2019 and older.

Does it work on a Mac or in Excel for the web?

Not tested yet. We've checked it in desktop Excel for Microsoft 365 on Windows. It uses no macros and only functions Excel 2021 has, but we haven't opened it in Excel for Mac or Excel for the web.

Training and Certification Tracker

$12.00

Buy now

Pay once. No subscription.

Sample dataApplicantsDashboardPipeline by stageNew8Gate check7Pre-screen7Manager interview5Offer2Hired3

Related tool

Field Tech Hiring System Tracker

The Field Tech Hiring System Tracker has a license column and a first gate check where you mark whether each applicant holds the license or certification the role needs, before you hire.

See this tool$19.00