Data CleaningImport CSV Into Google Sheets Cleanly
Upload CSV without broken dates and split columns — import settings, SPLIT, and TRIM pass before VLOOKUP or pivots.
Index
Tutorials
Step-by-step Excel and Google Sheets guides — VLOOKUP, pivot tables, budget sheets, inventory trackers, and data cleanup with copy-paste formulas.
Data Cleaning
Formulas
FormulasXLOOKUP: When to Use It Instead of VLOOKUP
Look left, return multiple columns, and handle missing values with IFNOTFOUND — XLOOKUP syntax for Excel 365 and Google Sheets.
FormulasVLOOKUP Basics (and the Four Errors You'll Hit First)
Build a product price lookup from scratch, use exact-match syntax, and fix #N/A, #REF!, extra spaces, and the wrong column index.
Templates
TemplatesInventory Tracker With Low-Stock Alerts
Track SKU quantity, reorder level, and a status column that flags low stock — plus conditional formatting you can scan in seconds.
TemplatesBuild a Monthly Budget Sheet You Can Reuse Every Month
Lay out income, fixed bills, variable spending, and savings on one tab with SUM formulas and a running balance row.
