How to Use Microsoft Forms | Understand The Survey Results & Export to Excel скачать в хорошем качестве

How to Use Microsoft Forms | Understand The Survey Results & Export to Excel

How to Use Microsoft Forms | Understand The Survey Results & Export to Excel | Hakuna Matata 722 0:12 Okay now, if you open up the Excel file, which contains the data that we have collected using the Excel form that we have talked about in the last module. It's going to look something like this. And this are all the data that we have collected from the customers. In this Excel table, each row corresponds to a unique customer. Notice that Excel organized all the results that we have obtained using the Excel form as a data table. And all the items in the first row of the table is going to tell you the meaning of each column.  And for example, this column E is going to contain customer names. In this column, F is going to contain age of the customers, etc., etc. Okay now, let's say we want to add another column to keep track of telephone numbers of customers. Then you can simply type in the name of the column which is telephone number. And now you can see that the first row of this new column is having different color comparing to the other items in the first row. To format the new column as a table, you can simply select the entire column and then choose format as table. And if you want to use the first item in the column to label the column, you can simply check this option, my tables has headers. And now you can see that the first item becomes the label of the column and then I'm going to start this result according to customer names. To do it, on the customer name, I simply choose sort ascendingly. And now you can see that all the results are sorted according to customer names and then let's say I want to focus on the results for air conditioner. Then I can simply go to report item and then choose filter and I only focus on air conditioner. 2:03 Then all the results will be about air conditioner. #Microsoft365 #msexcel #MsExcel