Mastering a technical skill like excel is one thing, but proficiently teaching it is quite another. In this case Eric has both. Which make's you outstanding among many excel tutors.
I found this video very useful and downloaded the template, thanks so much. Yes, I have heard of it and I use NPS at work for surveying customers. However I noticed in your video that your score started a One and I believe most NPS scores start at Zero. But I still used your template and made a modification to include zeros in the calculations. Thanks again for the explanation and breakdown.
Hey Stuart it's my pleasure to help and I'm glad that you found the template useful. Yeah I've seen NPS start at 0 before and at 1 but either way it's great that you're doing this analysis for your business!! Cheers 👍
Yes, it's actually a really interesting exercise! It's great to survey your customers (in exchange for a discount or something of value) with a wide range of questions, this being one of them.
I work for a company whose NPS is always between 88 and 90. This seems inordinate for what is going on in this company. And yet they plaster this NPS all over their website / materials etc . What are the odds that they are misrepresenting their NPS score in some way? Are there any safeguards in place?
Haha, yes, you would need to look at the underlying survey data....could be misrepresenting it somehow. Also, NPS isn't always a reliable metric, customers often say they "love" products when they are prompted for their opinion, but the real test is if they actually purchase, recommend to others, and then repurchase over and over again. Financial performance is the real indicator.
Thanks for sharing this amazing and useful video. I just need your permission to me to let me do this video or something like that in Arabic language for Arabic learners. Thanks in advance
Hey Eric, how can I create a cell that will calculate the amount of Promoters needed in order to achieve the next % that is on target, please help meeeee😂😂
@@eric_andrews Hi - I have registered several times, but it does not appear to be emailing the excel template (I have checked junk mail) - is it still available ? - Thx!
Dear Eric, very easy. Brilliant tutorial. Kudos!
Mastering a technical skill like excel is one thing, but proficiently teaching it is quite another. In this case Eric has both. Which make's you outstanding among many excel tutors.
Thanks so much for the comment stanley! I'm glad you find these videos helpful 😎
Thanks Eric! Your content was simple to understand. Some people teaching Excel makes it complex.
Glad to hear it!
Really appreciate you uploading this video
Glad it was helpful!
Thanks for this content with a great example. Quite helpful 😊
you are very welcome!
Your videos are really of high quality..and you make any concept very simpler to understand.. Thanks and all the best 👍
Appreciate the kind words, good luck to you as well!
I would definitely recommend this video to a friend!! 10/10
Hahaha! Thanks for the comment! Appreciate it 😀
This a really great video, and a really good explanation 💯💯💯
Appreciate it!
very helpful!! thank you!
I found this video very useful and downloaded the template, thanks so much. Yes, I have heard of it and I use NPS at work for surveying customers. However I noticed in your video that your score started a One and I believe most NPS scores start at Zero. But I still used your template and made a modification to include zeros in the calculations. Thanks again for the explanation and breakdown.
Hey Stuart it's my pleasure to help and I'm glad that you found the template useful. Yeah I've seen NPS start at 0 before and at 1 but either way it's great that you're doing this analysis for your business!! Cheers 👍
Thanks I have gained very useful knowledge and created automatic NPS Google sheet
Glad to hear it Mohamed, nice work 👍
10/10 I would recommend this video to a friend or colleague.
Ok so up to this point we're up to a +100 NPS on this video !! 😂😂
So clear! THANK YOU!!
Great job🎉
Cheers!
Thia is very useful. Highly recommended. Thanks Eric
Hey Thisaru - really appreciate the comment. I'm glad you found it useful. Cheers!
Great video! Very informative
This was awesome to watch and use. I am also looking to benchmark L&D NPS in the healthcare industry. Any sources you can point me to?
Thank you so much for this. 👌
You're welcome
Thanks for sharing, this helped
I'm glad
How can I calculate the required promoters to achieve a certain NPS target based on the existing survey?
Great help! Thank you
You're welcome!
Well described.
Glad you think so!
Excellent 👍
Thankyouuuuu Eric
Fantastic thanks 👍
Thank you
So helpful! Thanks.
Cheers Antinuke! Really glad it was helpful!!
thank you very much!!
I need to do this for my company.
Yes, it's actually a really interesting exercise! It's great to survey your customers (in exchange for a discount or something of value) with a wide range of questions, this being one of them.
and what about sumif (not SUM) formula for calculating % of categories? :)
I work for a company whose NPS is always between 88 and 90.
This seems inordinate for what is going on in this company.
And yet they plaster this NPS all over their website / materials etc .
What are the odds that they are misrepresenting their NPS score in some way?
Are there any safeguards in place?
Haha, yes, you would need to look at the underlying survey data....could be misrepresenting it somehow. Also, NPS isn't always a reliable metric, customers often say they "love" products when they are prompted for their opinion, but the real test is if they actually purchase, recommend to others, and then repurchase over and over again. Financial performance is the real indicator.
Is it possible to just ask customers one question you showed on your explanation?
Well the question is just "on a 1-10 scale how likely are you to recommend us to a friend". You could definitely just ask that question
Thanks for sharing this amazing and useful video. I just need your permission to me to let me do this video or something like that in Arabic language for Arabic learners.
Thanks in advance
Hey Eric, how can I create a cell that will calculate the amount of Promoters needed in order to achieve the next % that is on target, please help meeeee😂😂
Watching this video in 2022 and the formula didn’t work 😢 can somebody help?
Just download the template in the description to see the formula
@@eric_andrews Hi - I have registered several times, but it does not appear to be emailing the excel template (I have checked junk mail) - is it still available ? - Thx!
@@michaelcummings6975 seems to be working fine search "support@ericandrewsstartups.com" that should be the sender and let me know if you find it
Isn't Detractor scores 0-6?
There are actually many different questions you can use to analyze NPV. You could use a 0-10 scale as well instead of 1-10.
Detractors are from 0 to 6, not 1 to 6.
@eric should fix that , because indeed detractors are from 0-6 and NOT 1-6
We work in a bank and we hav e a goal of 63%
Hey thanks for sharing that's actually a really interesting stat!
Thank you very much great video