Survey data form software often has “rate 1-5” questions or rate 1-10 such as Microsoft Forms, Google Forms, Survey monkey etc. It’s not really easy to analyse them without leveraging Power Excel which consists of Power Pivot & Power Query. This video walks through the process, for even people who haven’t used the tools before. For advanced users, I bet you’ll learn a new transformation or two!
We also walk through other tools in Modern Excel, including Bos & Whisker plots, slicers, and advance Pivot options.