PLAY PODCASTS
The power of heat maps for sales and costs data

The power of heat maps for sales and costs data

Excel Tips

August 1, 20249m 41s

Audio is streamed directly from the publisher (traffic.libsyn.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.

Show Notes

Looking for ways to gain deeper insights from your sales and costs data in Excel?

This episode explores the power of heat maps, a data visualisation technique often used for climate data, but equally effective for business analysis.

For fast access, use these timestamps:

  1. 0:15 – Using heat maps for sales and cost information.
  2. 1:59 – Colour scales options and settings.
  3. 5:15 – Conditional formatting and top and bottom rules.
  4. 7:27 – Using the large and small function.

Listen now for insights into this multi-functional Excel tool.

Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

Search for them in your podcast platform.

You can email the podcast team at [email protected]