Build a bakery order tracker in Google Sheets step by step: item and status dropdowns, XLOOKUP prices, ARRAYFORMULA totals and balances, overdue pickup alerts, a SUMIFS bake list and summary cards. Free cake order template.
Google Sheets
Training Matrix Template in Google Sheets: Employee Training Tracker
A training matrix template in Google Sheets: log every training once, get automatic expiry dates, days left and Valid / Due Soon / Expired status, plus an employee x course matrix that builds itself.
Toy & Games Industry Dashboard in Google Sheets
A six-page Toy & Games Industry Dashboard in Google Sheets: 4 KPI cards, 15 slicers and 16 charts over 500 sample orders, 10 categories, 8 brands and 4 channels.
How to Build an Inventory Tracker in Google Sheets (Free Template)
Build an inventory tracker in Google Sheets step by step: a stock log with dropdowns, XLOOKUP item names, Stock In and Stock Out with SUMIFS, current stock and value, reorder alerts with colors and KPI cards. Free practice file.
Warehouse Inventory Management System Web App
A warehouse inventory management system web app on Google Apps Script: stock by bin, batch and expiry, FEFO pick and dispatch, cycle counts, barcode labels, 25 reports and 7 roles, with live demo login details.
How to Make a To Do List in Google Sheets with Checkboxes (Free Template)
Build a Google Sheets to do list template step by step: checkboxes, Category and Priority dropdowns, automatic Overdue and Due Soon status, Days Left, KPI cards and a progress bar. Free template included.
Boiler Maintenance KPI Scorecard in Google Sheets
Boiler Maintenance KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Electronics Retail Dashboard in Google Sheets
A six-tab Electronics Retail Dashboard in Google Sheets: 16 KPI cards, 15 slicers and 18 pivot-driven charts over 500 sample orders, 8 categories, 10 brands and 4 channels.
Windshield Repair and Replacement KPI Scorecard in Google Sheets
A 10-KPI traffic-light scorecard for windshield repair and auto glass shops in Google Sheets: service mix, install quality, claims and revenue KPIs, a KPI Trend page, setup steps and the known issues to fix first.
Generator Service KPI Scorecard in Google Sheets
Generator Service KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.