Microsoft Forms

Microsoft Forms is a web-based application for creating and sharing surveys, quizzes, tests, and other forms, allowing you to collect feedback from respondents and analyze the results in real time. The data we analyze can be easily exported to Excel, and if you know Power Query, you can process the results in a few steps to create effective reporting tables for their analysis.

Excel and Microsoft Forms service

Everyone knows that at the end of the year I often post “recipes” that have something to do with the Christmas and New Year holidays. This time I decided to show you how to combine Excel and Microsoft Forms, a Microsoft 365 service used to create questionnaires, quizzes, polls… In this text, you will find out how to create a New Year’s questionnaire by creating a form directly from Excel.