The power of heat maps for sales and costs data

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:

• INTHEBLACK
• INTHEBLACK Out Loud
• With Interest
• Excel Tips

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au