If Excel isn’t enough, check out this other post and you can save your Forms into anything else, like Planner, Trello, Slack, etc. Users submit intranet requests it in Forms, it writes to my Excel file, then I can triage the request, manage that data in my Excel file, without having to download it, or writing a Flow to write the data to the Excel file. You can make your budget, plan your expense. You can always do your accounting with the help of MS Excel. Or you can use any formulae you want to get. So the best uses of Excel is that you can calculate anything. I’ve set up a Form as a request tool for the intranet. Top Uses of Microsoft Excel 1)Calculating. This also comes in handy when you want to use the form for more than just a survey tool. People just want to collect data, in a clean manner, and then analyze it in Excel. You can easily carry on and select more columns if needed. Select the first column by clicking on it, then press and hold the Ctrl key and, while holding it, click on any other column you need to select. There have been numerous use cases for this over my last 20 years of consulting. How to Select Two Different Columns in Excel. However, if you have an existing Excel file, you can use Forms to import directly into your existing Excel file! We know this can be easily exported to Excel. We know about Microsoft Forms, the Office 365 quiz and polls tool.

I came across this neat little feature and instantly fell in love.

Create a Form and have the data save directly in Excel (this post).

First, let’s fill in the lookupvalue, which is the first piece of the vlookup function. Here’s how to fill in each of the four pieces of the vlookup formula. This post is the first of a few where we look at how easy the Office 365 stack integrates. I’ve also got two different tables of data.

Two uses of microsoft excel