Using Linked Data Types in Excel for Microsoft 365

Microsoft developers are hard at work, coming up with new and exciting ways to make your job easier! Who doesn’t want easy? They are coming up with new ways to use Everyday AI (Artificial Intelligence) to intuitively complete tasks for you.

Linked Data Types

Excel for Microsoft 365 has a neat little feature that uses Everyday AI. It has the capability of filling in data for you without having to research. Specifically, data having to do with Stocks and Locations. Data types have been used in Excel for a long time, but linked data types that use the power of Bing search, Wikipedia, and more through AI to bring data right to you.

Location Data Types

Below I have two examples of tables created using linked data types. The first one starts with a list of several states, and then once converted to a location data type, data on those specific locations will automatically populate for you. Watch below:

Notice how once the data is changed to a location data type that you can see there is a “card” next to the name of the state. Clicking on that card will show you all of the data available for this state.

The Location data type is not just for states, you can try cities, countries, and more. Here is a quick screenshot of a table made using Location data types for Countries.

Stocks Data Type

There is a second type of linked data type available, stocks. You can make a quick and easy spreadsheet to track your stocks without having to search for every single stock. Watch below:

Notice that Excel uses everyday AI to retrieve data from Wikipedia, Bing, and more.

This is just one of the many ways that Microsoft is incorporating everyday AI into your workflows. Read more here.

Work smarter, not harder!

About Harbor Computer Services


Harbor Computer Services is an IT firm servicing Southeastern Michigan. We work exclusively under contract with our clients to provide technology direction and either become the IT department or provide assistance to the internal IT they already have. We have won many awards for our work over the years, including the worldwide Microsoft Partner of the Year in 2010. We’re the smallest firm to have ever won this most prestigious award. Most recently we were recognized as one of the top 20 visionaries in small business IT by ChannelPro Magazine (2015). And in 2016 as the top Michigan IT firm for Manufacturing. There are a few simple things that make Harbor Computer Services the best choice for your business. •We are Professionals •We are Responsible •We are Concerned About The Success of Your Business

Leave a comment

Your email address will not be published. Required fields are marked *