I need 1 hour to translate, 1 hour to think about functions used and ratios, 1 hour to write data. For me is KPI Dashboard in 180 minutes ! Thanks man! 😀
Thank you for such an informative video that everyone else makes you pay for. You’re truly an amazing human to be able to give such valuable lessons that you have to pay a school to learn. God bless and thank you again.
Hi Bill, I am doing CMA currently, I found your videos are very helpful in understanding how F&A works in real world... huge thank you for all of your wonderful videos you produced.
Mr.Bill...thank you very much for your lesson, never seen this before. May God give you & family best health and keep share your valuable knowledge with us 🙏
This video is very informative. I haven't dealt with KPIs in a long time. I decided it was time for me to retrain myself on how to build one and you made the process painless for me. Thank you!
Such a great teacher. 1 minute into the video and I'm already hooked. No unnecessary subscribe plugs or anything, straight to content. Btw I love what you did with the submit form 😂 "I promise _not to never_ share your email address,"
Glad to have found your channel. I’m making a career change from an electronic technician to a business analyst. Same employer, just a different role. I’ll be more involved with R&D business metrics that finance. However, there’s a lot of great content on your channel.
Receive a big HELLO from COLOMBIA !!!!.... is good to find a compact video related to KPIs and the FILE attached !!!! Even more, the video opens the door to new Excel formulas like Index and Match. Gracias mil
Hi I found it useful for now since I am pushing my organization (newly established 1 year back) to use the dashboard when communicating any KPI which is not limited to financial once, but also include many KPIs that monitor the business e.g. SFE dashboard,.. BR
I hope I get the help I need. I work with a team with multiple targets (Phone sales, data device sale and sim activation). I want to design an interactive dashboard where all the individuals along their performances in all of the 3 KPIs appear
Hello Sir, I'm learning many things from you thanks for your great teaching skills. I would like to know which software do you use for recording your videos ? Which software do you use to edit your videos ? Thank you again 🌸
Why is not downloading the sheet directly ...why should you to send it by email...tell now i did not receive anything ...could you please put it on website .so it can be downloaded quickly ...thanks
Good channel, there’s a lack of RU-vid videos out there that explains fraud, that said there’s also a lot of people not understanding the importance of understanding financial statements, most people jump the gun for stocks, think you’d do awesome if you mix in a bit of stock analysis and just say you’re not a financial advisor or something down the line
Hi Bill thank you so much, this is very usefull, as mention in your KPI Dasboard Template the Premium Version will be coming on June 30, 2021. Can I get the the new one? Thank you so much Bill !!!
i am really into kpis and i think i have a jewel for your analysis.have you heard of percentage distance calculation? with proper weighting you can homogenously group indices into category metrics whether they are percentages or currency.ideally the groups should be meaningfull companywise ie in functional departments or project-based according to org-chart.plz share your thoughts, criticisism or brainstorming on that
I learned from your video to make my first KPI dashboard. The only confusing part is the year-month dropdown, my icon disappears every time losing focus, I tried with fake arrow(wingdings 3) does not look nice, also tried hyperlink method, both requires another column. From your video, your dropdown arrow shows right inside of the cell, can you please share how you did it so nicely? p.s. subsribed
The video is very informative and it will help in my daily work surely. Thank you so much bill. I have one doubt how did you insert drop down menu for month in dashboard? Is it macros?