Guides

Worked examples of everyday spreadsheet and file jobs, with the tools that do them.

How to Find Missing Rows Between Two Excel Sheets

Three ways to find rows that are in one spreadsheet but not the other: formulas, Power Query, and a no-formula browser tool. With examples for payroll, bank and inventory reconciliations.

Read the guide →

Find Amazon SKUs That Have Stock but No Active Listing

A simple two-report check for Amazon sellers: compare your FBA inventory export against your active listings to find SKUs that are in the warehouse but not buyable.

Read the guide →