Organizations have used Microsoft Excel for presentations and storing data in a structured manner for several years. The only way they could make use of the tool is by inserting text and numbers. With the new update, add any information to create a data type. In this article at TechRepublic, learn how you can leverage Excel for multiple data types.
Updating Microsoft Excel
You can collect customer data and directly use it in Excel. The tool has been what Microsoft mentioned as ‘two dimensional’ before. Now there is a third dimension that enables you to explore further. Microsoft Excel can connect to Microsoft Power BI automatically. So, the information you are publishing on the BI platform can be displayed in Excel too.
Meanwhile, Microsoft Excel customers can use the Power Query tool to detect various data sources and convert them to a data type. With Get Data menu, you can even build customized data types from sources like files, databases, and online services. What’s more, the Power Query tool would automatically update information from the connected data sources.
Not only are you able to save the customized data types in the spreadsheet, but you can also share these with other teams in your company. If you have a Microsoft 365 Personal or Family subscription, check out the hundred new Wolfram Alpha data types. You can keep track of nutritional information as well as stock pricing. Power BI is also available for Windows customers, but you need to have a Power BI Pro service plan to avail of it.
Microsoft is rolling out Power Query data types from Microsoft 365 or Office 365 customers. You can look at how to use the Wolfram Alpha data types if you are an Office Insiders subscriber.
Microsoft Excel has always been the go-to tool for managing large amounts of data. With Power BI, you can increase its use cases for multiple purposes.
To view the original article in full, visit the following link: https://www.techrepublic.com/article/microsoft-excel-huge-update-expands-data-types-beyond-just-text-and-numbers/