))
The power of heat maps for sales and costs data
Manage episode 431725814 series 3560917
Контент предоставлен CPA Australia. Весь контент подкастов, включая эпизоды, графику и описания подкастов, загружается и предоставляется непосредственно компанией CPA Australia или ее партнером по платформе подкастов. Если вы считаете, что кто-то использует вашу работу, защищенную авторским правом, без вашего разрешения, вы можете выполнить процедуру, описанную здесь https://ru.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 эпизодов
Поделиться
