Resources
Practical guides on Excel formulas, Power Query and reporting, written for finance teams who want fewer manual steps and numbers they can trust.
Where should you start?
My reports don’t agree
You will know why two reports differ and how to prove the gap ties out.
I repeat the same cleanup every month
You clean the file once, then every new month loads and reshapes itself.
- Clean a messy bank export
- Combine monthly files automatically
- Unpivot a report layout (coming soon)
I need formulas I can maintain
You pick the right lookup and write formulas the next person can audit.
Showing all 9 guides
Why month-end reports break
Find out why reports disagree, trace the differences, and build checks your team can rely on.
8 min readRead the guide
Clean a messy bank export with Power Query
Turn a sloppy monthly export into a tidy table once, then refresh it every month with one click.
9 min readRead the guide Power QueryCombine monthly files automatically
Point Power Query at a folder and let new monthly files append themselves.
7 min readRead the guideUnpivot a report layout in three steps
Reshape a wide, report-style sheet into rows you can actually analyze, filter and chart.
5 min readComing soonXLOOKUP vs. INDEX/MATCH: which should you use?
A side-by-side look at both approaches on a real lookup, where each one breaks, and a simple rule for choosing.
8 min readRead the guide Excel formulasSUMPRODUCT for multi-condition sums
Add up values that meet several conditions at once, without helper columns, and see why it often beats SUMIFS.
7 min readRead the guide Excel formulasMake long Excel formulas easier to audit with LET
Give repeated calculations clear names, shorten a variance formula, and make the logic easier for the next person to check.
6 min readRead the guide Reporting and financeBuild a variance bridge people trust
A step-by-step approach to explaining the gap between budget and actual so the numbers tie out.
10 min readRead the guide AI at workUsing AI on spreadsheets safely
Where AI helps with formulas and cleanup, where it quietly goes wrong, and a checklist before you trust the output.
6 min readRead the guideNo guides match your search. Try a different word or clear the filter.
Try it while you learn
Need this built for your team?
If a guide describes your problem, we can build the solution for you. Start with a free 30 minute strategy session.