A free Packing Checklist Template in Google Sheets with 45 sample items, packed and priority drop-downs, luggage locations and three summary charts. See every column, simple progress formulas and how to adapt it for your trip.
Google Sheets
Birthday and Anniversary Tracker in Google Sheets with Search Feature
A Birthday and Anniversary Tracker in Google Sheets that counts the days left to every occasion and lists what is coming up in the next 7, 30 or 90 days. See each sheet, the Remaining Days formula and how to set it up.
Task Management Tracker in Google Sheets
A ready-made Task Management Tracker in Google Sheets with automatic task IDs, an overdue flag, pending-age buckets and four summary charts. See how each column and formula works and how to set it up with your own team.
INDEX with Double MATCH in Google Sheets (Two-Way Lookup)
Use INDEX with two MATCH functions in Google Sheets to look up any employee by ID and any field by its header, with a worked call-centre example and a free practice file.
Sparklines in Google Sheets: Line, Column and Win/Loss Examples
Learn the SPARKLINE function in Google Sheets with three worked examples: a line sparkline for daily sales, a column sparkline for quarterly margin and a win/loss sparkline for attendance.
3D Doughnut Chart in Google Sheets: Step-by-Step Guide
Build a dynamic 3D doughnut chart in Google Sheets from a pie chart, two data cells and one helper formula, with the KPI value shown in the centre of the ring.
Gauge Chart in Google Sheets: Step-by-Step Guide (Service Level Example)
Build a gauge chart in Google Sheets from just a label and a value: insert the Gauge chart, set the scale and red/orange/green bands, and drive it with a live Service Level formula. Free practice file included.
6 VLOOKUP Tricks in Google Sheets (With Real Examples)
Six practical VLOOKUP tricks in Google Sheets – normal lookup, VLOOKUP with COLUMN, VLOOKUP with MATCH, double VLOOKUP, IFERROR handling and age buckets – with a free practice file and checked results.
Conditional Formatting in a Google Sheets Chart (Target vs Actual)
Make Google Sheets chart bars turn red when sales miss the target and green when they meet it, using two IF/NA() helper columns and a stacked combo chart. Free practice file included.
To-Do List in Google Sheets: Free Template with Priority and Checkboxes
A free, simple to-do list template in Google Sheets with an automatic serial number, a colour-coded High/Medium/Low priority dropdown, status checkboxes and automatic strike-through for finished tasks.