Guides

Practical, no-fluff guides to auditing, reviewing, and taking over Google Sheets.

How to Find and Fix Broken Formulas in Google Sheets

What #REF!, #NAME?, #VALUE! and the other error codes really mean — and how to find every broken formula across a whole workbook, fix each type, and stop them coming back.

The Google Sheets Audit Checklist

A practical 12-point checklist for reviewing a spreadsheet before you trust it: formulas, references, external links, validation, protections, hidden tabs, named ranges, and more.

How to Take Over an Inherited Google Sheet Without Breaking It

A calm, step-by-step playbook for inheriting a complex sheet: back it up, map the structure, find the hidden dependencies, and understand it before you change a thing.

Ready to audit your next workbook?

Use Sheet Audit Pack to review workbook structure, formula risks, and handoff readiness — directly inside Google Sheets. Free, with no subscription.