Library

Excel Tutorials

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

FormulasIntermediate

XLOOKUP vs INDEX/MATCH: Which One Should You Actually Use?

XLOOKUP is newer and easier to read, but INDEX/MATCH still wins in a few specific situations. Here's how to choose.

8 min readRead →
Power QueryIntermediate

Automate Monthly Reports With Power Query's Folder Connector

Stop opening five CSVs and pasting them together by hand. The Folder connector combines every file in a folder into one clean table automatically.

9 min readRead →
Pivot TablesBeginner

Pivot Tables From Zero to Boardroom

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.

10 min readRead →
VBAAdvanced

A VBA Macro That Exports Any Selection as a PDF

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.

7 min readRead →
FormulasBeginner

Conditional Formatting Based on Another Sheet's Value

Excel's Conditional Formatting dialog won't let you reference another sheet directly — here's the named-range trick that gets around it.

6 min readRead →
DashboardsAdvanced

Building Reusable Financial Dashboards With LAMBDA

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.

11 min readRead →
ChartsIntermediate

Charts That Update Themselves When New Data Arrives

Stop manually dragging a chart's source range wider every month. Excel Tables and dynamic named ranges make charts grow with your data automatically.

7 min readRead →
FormulasAdvanced

FORECAST.ETS vs a Manual Seasonal Index: Which Gives Better Forecasts?

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.

9 min readRead →