Weekly Topics
One spreadsheet skill, every week
Each week I pick one spreadsheet skill and cover it three ways: a short video, a fully written guide, and a downloadable template. Here’s every topic so far.
-
How to Sum by Category and Month in Excel (SUMIFS)
Turn a long list of bills into a monthly spending summary with one SUMIFS formula. Step-by-step, with sales-tax and fiscal-year variations.
Looking for a Specific Function?
Try the functions library instead
Weekly topics are tasks and workflows. If you just need to know what XLOOKUPu or SUMIFS does, the Functions library answers that directly.