I’m designing a series of matching static dashboards. Each state, tribal area, and territory that’s participating in this program will receive a two-page PDF with a dozen charts, like this waffle.
In this video, I show you what’s possible right inside of good ol’ Excel! I used the power of drop-down menus, vlookup, sumif, countif, conditional formatting, and concatenate to save myself from having to create dozens of dashboards individually.
Hopefully this video inspires you to apply the technique to your own work.