Every workbook in the catalogue is built from functions that Excel, Google Sheets and Numbers all have — so an .xlsx uploaded to Drive works the same as it does on the desktop, dropdowns and colours included. Nothing here needs a macro, an add-on or an Apps Script.
Type a year and a month and the calendar redraws itself: weekends shaded, today blue, other months greyed, and your events written into the right days from a list. Pro adds the whole year on one sheet, a week planner, holidays, and a formulas walkthrough. No macros.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.
Type in and out as times and a break in hours; hours and overtime are calculated, night shifts past midnight included. Pro adds a log with projects and hourly rates, billable amounts per project and per week, distinct days worked, and a formulas walkthrough. No macros.
Amount, rate, term, first payment: the monthly payment and a full schedule where interest is computed month by month from the balance, rounded to cents like a lender, so every figure is visible. Pro adds extra payments with payoff date and interest saved, a rate-and-term comparison grid, and a formulas walkthrough.
Names down the side, days across, one letter per cell — P, A, L, E, H — from a dropdown, coloured. Counts per person, attendance % that counts Late as present and leaves holidays out, present per day, weekends shaded. Pro adds a Summary with bars and flags, holidays from Setup, and a formulas walkthrough. No macros.
A week of shifts: people down the side, seven days across, a shift code per cell from a dropdown — hours and pay per person come from the code table, headcount per day is counted. Pro adds coverage against required staffing per shift, payroll with overtime, and a formulas walkthrough. No macros.
An expense log for Excel and Google Sheets that totals itself: this month by category with data bars, twelve months back, and spending against the limits you set — every formula visible. Pro adds the Monthly and Limits sheets, a Setup sheet with limits, and a formulas walkthrough.
Stock levels, reorder points and stock value for Excel and Google Sheets, every number a visible formula. Status turns yellow at the reorder point and red at zero. Pro adds a Movements log that updates quantities, a Reorder list with the cost to restock, a Dashboard by category, and a formulas walkthrough.
Habits down the side, days across the top, a mark when you did it. Done counts, a monthly target scaled from your weekly one, completion bars, weekends shaded. Pro adds current and best streaks with the running count on its own sheet, a by-week view, and a formulas walkthrough. No macros.
A task list with a Gantt chart drawn entirely by conditional formatting — no shapes, no macros. Start and end dates make the bar, Done % fills it, Blocked turns it red, a line marks this week. Pro adds a 26-week timeline, a Dashboard, Milestones and a formulas walkthrough.
An invoice that adds itself up and prints on one page: line items, discount, tax, total, due date from terms. Pro fills the client's details and item prices from lists, and keeps a register of every invoice — outstanding, days overdue, status, aging buckets, next number. No macros.
A monthly budget for Excel and Google Sheets with every formula visible: planned vs actual by category, red/green differences, savings rate. Pro adds a transactions log that fills the budget automatically, a twelve-month view with a chart, and a sheet explaining each formula.
Plenty of Excel templates open in Google Sheets and quietly break: a function Sheets doesn't have, a macro that never runs, a whole-column reference that makes every edit take a second. These workbooks are built the other way round — from the set of functions all three applications share, with ranges that stop at a stated row, and with every formula written down on a sheet so you can see there's nothing else.
No FILTER, XLOOKUP, LET or dynamic arrays. Where those would be the neat answer — a reorder list, a "last non-empty" lookup — the workbook uses the older shape (an IF mirror, SUMPRODUCT(MAX(…))) and explains it. The guide on building spreadsheets without macros goes through each rule.
Each file is recalculated in LibreOffice and in a second engine, totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors before the file ships. We don't run Excel or Sheets in that pipeline, which is why the catalogue says built for rather than tested in.
Drive → New → File upload, then open it; or in Sheets, File → Import → Upload. Sheets converts it in place. Named ranges, dropdowns, conditional formatting and the charts come across.
Yes. Each workbook uses only functions that Excel 2016+, Google Sheets and Numbers share — SUMIFS, COUNTIFS, SUMPRODUCT, INDEX/MATCH, EOMONTH, EDATE, PMT, IFERROR. No FILTER, XLOOKUP or LET, on purpose.
Whole-column references make Google Sheets recalculate slowly. Each workbook reads a stated number of rows — 400 or 1000 — and the README says how to raise it.
Sheets sharing works as usual. The licence covers one person or company; for several seats, write to us.