How to Write *Dynamic* (Automatically-Changing) Takeaway Text in Excel Dashboards

I’m a big fan of takeaway text: for reports, for presentations, and even for interactive dashboards.
Sometimes people think that takeaway text isn’t possible for dynamic dashboards in Excel. They worry that they’ll have to write each sentence by hand. False!
In this video, you’ll learn about two ingredients:
(1) Concatenation: You’ll use the ampersand (&) to join the content from a few cells together.
(2) Helper Cells: There are pivot tables, helper tables (with lookups), and more concatenation to write out the graph labels.
You can write takeaway sentences about:
The most or least (the poles)
The averages
Anything else you think your audience might be interested in
Download this Excel dashboard and follow along: depictdatastud...

[@SpotlightImpact]

Sweeet! Nice BTS peak!

[@AnnKEmery]

Thank you, Nick!