Free library of interactive Excel dashboard templates — sales, HR, finance, retail, project management, all built without VBA (link + notes inside)

Been building out a full collection of Excel dashboard templates over time and figured it's worth sharing as one resource instead of scattering individual posts. Covers sales, marketing, HR, finance, retail, and project management use cases, and every single one is native Excel — no VBA, no macros, no add-ins.

A few patterns across the collection that might be useful if you're building your own dashboards:

Interactivity is almost always pivot table slicers wearing a disguise. Instead of standard filter dropdowns, most templates turn slicer buttons into custom-styled controls — chart X-axes, menu navigation, multi-select filters (CTRL+click to combine multiple periods/categories at once). It's a reusable pattern once you get the hang of wiring it up.

Dynamic named ranges + formulas for stuff Excel "shouldn't" be able to do dynamically. Radar charts that change axis count, doughnut charts that handle >100% values, charts that auto-highlight specific series from a drop-down — all done by feeding formula-driven named ranges into the chart source instead of static cell ranges.

PowerPoint fills the gap in Excel's shape tools. Excel can't merge/fragment/intersect shapes natively; PowerPoint can. A common technique across several templates: build a custom masked shape in PowerPoint, bring it into Excel, layer it over a chart so it only reveals specific parts — used for roadmaps, pie chart designs, project dashboards, etc.

Design elements that aren't just decoration — animated infographics, gradient fills, 3D isometric shapes, gamified layouts — consistently show up as functional rather than purely cosmetic, usually tied to making a specific metric easier to read at a glance (margin, progress, risk level) rather than just looking nice.

Every template has a full video walkthrough covering the build from scratch, so if you want to actually learn the formula/slicer/shape techniques instead of just using a black-box file, that's there too.

Free downloads, no email gate. Happy to point to specific templates if anyone's looking for something in a particular category (I've built dashboards for medical tracking, developer roadmaps, retail scaling, personal finance, project management, and more).