))
The power of heat maps for sales and costs data
Manage episode 431725814 series 3560917
コンテンツは CPA Australia によって提供されます。エピソード、グラフィック、ポッドキャストの説明を含むすべてのポッドキャスト コンテンツは、CPA Australia またはそのポッドキャスト プラットフォーム パートナーによって直接アップロードされ、提供されます。誰かがあなたの著作物をあなたの許可なく使用していると思われる場合は、ここで概説されているプロセスに従うことができますhttps://ja.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
29 つのエピソード
シェア
