The working library

A clearer way
through your spreadsheet.

Start with a specific problem. Leave with a method you can check.

Excel vs Google Sheets: Formula Compatibility Differences That Matter

Compare FILTER signatures, array formulas, lookup version support, and date inputs using a small migration checklist and expected outputs.

5 min read

Formulas02

Google Sheets FILTER Function: Practical Examples and Common Errors

Copy Google Sheets FILTER examples for one condition, AND, OR, and no matches, using a five-row dataset with expected outputs.

4 min read

Troubleshooting03

How to Fix XLOOKUP Not Working in Excel

Diagnose unsupported Excel versions, missing matches, mismatched ranges, and duplicate keys with a small XLOOKUP repair dataset.

4 min read

Data Cleaning04

How to Import CSV Files Without Losing Leading Zeros or Changing Dates

Preserve CSV identifiers and date text during import, then validate raw values before converting any dates in Excel or Google Sheets.

5 min read

Data Cleaning05

How to Remove Duplicate Rows in Excel and Google Sheets Safely

Choose duplicate keys, preview keep-first results, and avoid deleting meaningful revisions in Excel, Google Sheets, and raw CSV files.

5 min read

Formulas06

IFERROR vs IFNA in Excel and Google Sheets: Fix Errors Without Hiding Problems

Learn when to use IFERROR or IFNA in Excel and Google Sheets, with two reproducible example tables, a diagnostic decision tree and safer error-handling formulas.

11 min read

Formulas07

SUMIFS with Dates: A Step-by-Step Excel and Google Sheets Tutorial

Sum monthly amounts using an inclusive start and exclusive next-month boundary, with timestamp edge cases and expected Excel/Sheets totals.

4 min read