- How to use quick analysis tool in excel online update#
- How to use quick analysis tool in excel online software#
We’ve chosen to use the country names, but this feature also works if you use the names of cities, provinces/states, etc. In this example we’re using country names “France,” “Spain,” and “Sweden” to pull Geography data about each country’s population. If you’re already on the latest update, then here’s how you can try out the new linked data feature in just three easy steps: 1) Create a new table in Excel
How to use quick analysis tool in excel online update#
It really is that simple!Īlthough not all Office 365 users have received the new update (Amaxra as a certified Gold-level Partner of Microsoft actively participates in the Office Insiders program to see previews of upcoming feature enhancements), the updates are coming and should be available to Office 365 Business users by the end of October 2018. And when you upload these Excel spreadsheets on your team SharePoint site in Office 365, you can securely give or limit who in your organization has access to the cloud-powered data.
How to use quick analysis tool in excel online software#
Academics and actuaries can use the Geography data type to build predictive models around population density and commodity prices using Excel in a few minutes rather than contracting a software design firm to build a custom solution. One practical application for the Stocks data type would be for financial analysts to create an Excel workbook that updates a stock watchlist showing current prices and the changes expressed as a percentage in real time all in less than ten minutes. The near-ubiquity of Excel in business and its relative ease of use compared to other complex data modeling software opens up infinite possibilities for all kinds of organizations.
This means that as long as your device has a connection to the internet, the data inside any cells marked with either the Stocks or Geography data type will be automatically updated in real time with the latest data delivered by Microsoft’s extensive global cloud infrastructure.
If your organization has Office 365, then you’ll notice an option under the Data tab in Excel for “Stocks and Geography.” Unlike data types such as numbers that can be modified to operate as percentages, dates, or currency, the new “Stocks and Geography” data types are automatically linked to online sources. Uses for real-time data in Excel for Office 365 If you’re like me, then you are already thinking of all the ways that this new feature is going to change the way you look at your business data. Much like that feature, the October 2018 update of Excel in Office 365 enables you to pull real-time and constantly updated financial market and geographic data from the cloud into your spreadsheet. But one of the key benefits of having the cloud-powered version of Excel in Microsoft Office 365 is your ability to leverage the global data stored in the Microsoft Cloud in real time.Īmaxra blogged about this productivity-enhancing ability in the past with Map Charts in Excel.
Microsoft has always used data types in Excel such as text, number, et cetera to help you build complex data models in spreadsheets.