Year-Over-Year (YoY) analysis in Excel || Conditional Formatting Icon Sets || Company Performance

This video describes Year-Over-Year (YoY) analysis and how to visually represent the result with icons using conditional formatting. If you are in finance/ accounting or an analyst or a small business owner or an investor, you need to use YoY analysis to assess the performance of a company.
Please check out other videos on my channel and don't forget to like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Connect with me on:
👉Instagram and Facebook @youexceltutorials
👉Twitter @youexceltutor
👉LinkedIn @bunmisanusi
🎬Check these videos
Common Size (Vertical) Analysis in Excel • Common Size (Vertical)...
Simple Actual to Budget Charts • Simple Actual to Budge...
Download the workbook here drive.google.com/file/d/1Nfbi...
📢“God resists you when you are proud but continually pours out grace when you are humble” James 4:6b (TPT)
#msexcel #youexceltutorials

[@lolaodedokun3140]

Good job👌

[@Ayuk1]

Hello @YouExcel Tutorials , wuick question please, why did you change the "type" to number in the conditional formatting phase whereas the YoY change is expressed in percentage ?

[@YouExcelTutorials]

Firstly, @Mr Arung let me say thank you for watching and dropping a question.
Now to your question, when you select the percentage type, Excel uses the relative value (in percentage terms) of the number in each cell to assign an icon. For instance, using the 3 icon sets in the video - if the percentage type was selected - Excel will identify the minimum and maximum value, obtain the range (Max - Min) and by default assign the green icon to cells that are in the top 67% of the data, yellow to those between 33% and 67% and any cell that is below 33% will be red (please note that these ranges can be edited). However, changing the type to number allows us to specify the exact value we want for each icon. I hope this helps.

[@Ayuk1]

@@YouExcelTutorials well understood. Thanks a lot. Looking forward to more exiting finance related videos :)