Hellow guys, Welcome to my website, and you are watching Excel: Add Dynamic Traffic Lights to Your Dashboards and Trackers. and this vIdeo is uploaded by Mike Thomas at 2023-08-26T23:45:31-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel: Add Dynamic Traffic Lights to Your Dashboards and Trackers |
| Video Uploader | Video From Mike Thomas |
| Upload Date | This Video Uploaded At 27-08-2023 02:45:31 |
| Video Discription | Something thing that you often see on dashboards and trackers is progress against target. This is often represented as a numeric value. But what if you were to add an image of a traffic light to your dashboard or tracker and have it automatically change colour as the numbers change? Both fun and functional. NOTE: This video uses a feature (Insert - Picture - Place in Cell) which at the time of recording is only available to users on the Microsoft 365 Beta Channel 🗒 Notes and Resources The formula that I used in the demo: =IF(PercentTarget less than symbol 0.8,Red,IF(PercentTarget greater than or equal to symbol 1,Green,Amber)) NOTE: YouTube doesn't allow the greater than and less than symbols in the description. Hope you can work out what I've done above! ✅ Want more FREE training? Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk 🙋♂️ Let's connect on social Twitter: https://twitter.com/theexceltrainer Facebook: https://www.facebook.com/theexceltrainer LinkedIn: https://www.linkedin.com/in/thomasmik #excel #dashboard #tracker #datavisualization |
| Category | Education |
| Tags | trafficlights | microsoftexcel | kpi | dashboard | tracker |
