Interactive Custom Format Visualizing Data in Excel
Custom formatting is not only used for disguising numbers in different ways, but it can also be interactive and take your report or dashboard to a whole different level.
In a previous tutorial I created a Comparison Dashboard that summarizes thousands of records, comparing the sales of different managers between 2 years, with a slicer for the region I made it interactive.
You can watch this tutorial by clicking on the link here below:
• Comparison Dashboard - Super Easy and Very...
Today I will considerably improve this dashboard by adding an Interactive Custom Format.
Let’s dive in…
Note: While calculating the YOY I mistakenly divided the 2 years difference by the last year, while it should be the previous year. The formula will read =(K5-F5)/F5 . Luckily that does not change anything in the topic I explain.
To book a Corporate Training contact
www.Officeinstructor.com
На этой странице сайта вы можете посмотреть видео онлайн Interactive Custom Format Visualizing Data in Excel длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Officeinstructor 18 Февраль 2024, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 934 раз и оно понравилось 69 зрителям. Приятного просмотра!
