Library
Step-by-step guides written for actual work — automating reports, fixing broken lookups, building dashboards that survive contact with real data.
Showing 8 of 8
XLOOKUP is newer and easier to read, but INDEX/MATCH still wins in a few specific situations. Here's how to choose.
Stop opening five CSVs and pasting them together by hand. The Folder connector combines every file in a folder into one clean table automatically.
The seven moves that take a flat table of raw data to an executive-ready summary, explained for someone who has never built one before.
A short, reusable macro with proper error handling — paste it in, bind it to a button, and export any sheet or selection to PDF in one click.
Excel's Conditional Formatting dialog won't let you reference another sheet directly — here's the named-range trick that gets around it.
LAMBDA lets you define your own named, reusable Excel functions — no VBA required. Here's how to use it to build dashboard logic that stays readable.
Stop manually dragging a chart's source range wider every month. Excel Tables and dynamic named ranges make charts grow with your data automatically.
Excel's built-in FORECAST.ETS handles seasonality automatically, but a manual seasonal index still has its place. Here's how to decide and how to check your forecast's accuracy either way.