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.

Additional Teams apps

Microsoft Teams allows you to easily access additional applications from the main menu – cloud services and connectors that you will use in your daily work. There are a handful of useful applications, organized by categories, which improve the functionality of Teams such as: Forms, Shifts, Approvals, Stream, Power BI, One Note and many others …

Generic forms

Excel has, within the VBA Editor, a form design tool that helps you easily fill in structured data tables. However, some of you still do not know the VBA and are unable to create the form yourself. Some others will find themselves in the situation that their job is overwhelmed by entering data one time. For all of you, in the “recipe” that follows, I will show how to enter data in a table using generic Excel forms.

Forms

Forms are graphic objects that are created by the designer, and they consist of a variety of controls for easier data entry. These may be: text input field, radio buttons, check boxes, drop-down lists, combined lists, etc. By adding control to the mask, prerequisites for retrieving values into a document ​​are created, and after the scheduled action they are imported on specific location within a worksheet.