))
The power of heat maps for sales and costs data
Manage episode 431725814 series 3560917
Content provided by CPA Australia. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by CPA Australia or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
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:
- 0:15 – Using heat maps for sales and cost information.
- 1:59 – Colour scales options and settings.
- 5:15 – Conditional formatting and top and bottom rules.
- 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 podcasts@cpaaustralia.com.au
26 episodes
Share
