Spreadsheet Diary
Real spreadsheet problems and how to solve them.
excel
Cleaning Up a Messy Sales Sheet
A step-by-step method for finding and removing duplicate rows and extra spaces in a sales spreadsheet, based on official Excel documentation.
Latest
excel
Date Formulas for Deadlines and Workdays
How DATEDIF, NETWORKDAYS, and EDATE work in Excel, with each official example re-checked against a plain Python date calculation.
excel
VLOOKUP vs XLOOKUP, Which Should You Use?
A side-by-side comparison of VLOOKUP and XLOOKUP in Excel, with a worked table example, based on official Microsoft function documentation.
excel
Your First Pivot Table, Explained
A beginner walkthrough of what a pivot table does and how to build one in Excel or Google Sheets, based on official Microsoft and Google documentation.