From students to businessmen – Microsoft Excel can be a very useful tool for all who want to create reports, charts, tables and so on. When someone needs to create a chart using a free tool, Microsoft Excel Online is the first tool that should come to mind. Unlike Excel desktop version, Microsoft Office Online is free, and all the files get saved to OneDrive, which in turn can help users manage Excel sheets from anywhere. To get more familiar with this tool, here are some Microsoft Excel Online tips and tricks to help you get started.
Excel Online tips and tricks
1] Use Functions
Functions are probably the backbone of the web version of Microsoft Excel. There are different functions available including Cube function, Engineering function, Financial function, Logical function and so on. You can use all these functions from the Insert section. To use this feature go to Insert > Function > Select the function category and enter a Function. Following that, you can utilize it just like the desktop version. Check out this page to know more about Excel Functions.
2] Create a Survey
Many times, we need to create polls to get user feedback or gather information. If you use Microsoft Excel Online, you do not have to use any other third party survey makers, since Excel can handle that task easily. It is also possible to share the survey with others. To create a survey, click on Insert > Survey > New Survey > Add questions, mark fields as required (if necessary). Now, you will get two options i.e. Share Survey & Save and View. If you want to share the survey with someone, click on the first option. Otherwise, click on the second option. All the surveys will be saved in that particular Excel file.
Continue Reading at Source: Microsoft Excel Online tips and tricks to help you get started