In this video, you will learn how to calculate and Analyze the Net promoter score ( NPS) in Microsoft Excel. The Net Promoter score is a customer experience survey usually carried out by companies to test their customers loyalty or the likelihood of them recommending their brand, products or services to someone else. The NPS is based on a single survey question on a scale of 1 to 10. The NPS is divided into 3 main categories of respondents which are the detractors, passives and promoters. Watch the video till the end to get the full details.

Click on the link to watch other related and educative videos
   • How to use the SUM IF Function #excel...      • ABSOLUTE, RELATIVE & MIXED CELL REFER...  

Click to download the practice file.
https://docs.google.com/spreadsheets/...

The below timestamps will help you locate specific areas you are interested in:
0:00 Intro
0:58 NPS Respondents
2:57 Count if function
4:34 How to calculate percentage
5:06 How to calculate NPS
5:21 SUMIF function
7:14 Global NPS standards
7:53 How to convert detractors to promoters
9:27 Wrap up