Excel for Microsoft 365 now includes rich data types from Wolfram|Alpha and Bing. After watching this video, you'll be able to use fitness, food, and other rich, linked data types in Excel.
- [Instructor] There's a feature here in Excel for Microsoft 365 that keeps getting better and better. It relates to linked data types. And there are some new ones we're going to explore here. Using Bing and Wolfram Alpha integration, we can actually store tons of information on different data types right within the cell and then extract that data as we need it. For example, I've set up a sheet here. That's going to track the calories I burn doing different activities. The calories I take in eating certain foods. And you can see I've set this up with some simple formulas to total up the amount of calories burned versus that that I'm taking in. Just to get a feel for any given week. So the first step is to go over here to our data. And select the data and convert it to linked data. And it's very easy to do. We'll start with the food items here. Clicking and dragging from apple down to cheese, selects the items. We go to the data tab up here on the ribbon. And in data types, you'll see a couple here, like organization, stocks. You may see something different. This is constantly being updated and changed. So clicking the drop-down, I see a couple of other ones up here at the top. And a number of preview data types. You may see different data types. You may not see any yet. But this list is going to continue to grow and grow. Eventually you'll see dozens here. And for us, selecting apple down to cheese, those are foods. And as I hover over food I can see that this is one that I can convert to the food data type to get things like nutrition facts. So clicking this is going to do a couple of things. First of all. You'll see down at the bottom, it's converting to a linked data type. Obviously we need an internet connection for this to work. But once we get the data, convert it, and store it in these cells, we no longer need that internet connection to access the data. So you can see some things have happened here. We have icons next to some of the items. Chocolate seems to have an issue. It's highlighted with a question mark. And over here the data selector's opened up because we're being prompted for something more specific. You can see there's chocolate. And then there's also milk chocolate. So if it's milk chocolate I'm eating, that's the one I'm going to click the select button for. And it converts it to milk chocolate. Even changes the label. Now to get the calories I don't have to research it on my own. I can just extract that data. For example if we click the apple icon next to the word apple, it opens up the card where I can see a lot of information. Like the amount consumed. Common servings. Calories, these are expandable sections that give me all kinds of information. If I see information I want to use it's even easier to get onto my spreadsheet. So I'll click in the background to close that up and select them all by clicking and dragging. Notice this little icon in the top right corner is the insert data button. Clicking this allows me to access that data I saw on the card and put it right here in the next available column, which is under calories. So clicking this, I can go to calories total. Look at the long list of items I can choose from here. Lots of information. Choosing calories total will insert the calories per serving right next to each of these. Very cool stuff. Now if I click down below cheese and want to add one like banana, for example, and press Enter. Automatically you can see it's being converted to a data type. And if I want to get that data over here to the right, I can use a different method. And it's like starting a formula. We hit the equal sign. Then we select banana. All of those items pop up again, including calories total. I can select that, press Enter, and it's locked in, just like that. Now all I have to do in my worksheet here is track how many I've eaten of each. For example, on Monday I had an apple. I'll type in a one. I had another one on Thursday. And on Saturday. You can see the totals up here. I'll just use a simple formula that takes the total number of servings here and multiplies it by the calories. So I go through my worksheet here, adding these items. I can see the totals adding up for me nicely. Oatmeal every second day. And then cheese, here and there. And let's have a banana. There we go. So you can see what's happening. I'm getting the total consumed here for the week. Now for activities, I can do the exact same thing. Select these. Go to my data types. Click the dropdown. There's one for activity. It's going to convert them to data. The icon looks a little bit different. I can go right to that same button to insert data. And from here, I'm looking for calories burned. There it is. Selecting that pops those in. Wondering how long I have to do that activity to burn those. Well, go back to the same button, click it. And we're going to look for time. There it is down near the bottom. That's going use the next available column. And you can see the duration set to 30 minutes. So for tennis, if I played an hour and a half, that would be three units of 30 minutes. And you can see the total showing up here in my worksheet. Great way to track that information without having to research it myself thanks to the data types. Let's have some fun now. We'll click the planets tab down below here. And when you work with data in a table, it works a little bit differently. Can save you some time. So I'm going to select everything here and convert this to a table first using the keyboard shortcut Control + T. Now I'll click okay. And I have a table. Now I'll select the data that I want to convert to one of those linked data types. Going back to data, click the drop-down. And there is one for space. This one's going to all kinds of things like track constellations, planets. Information about each. So selecting this is going to convert those. I can see it happening down below. The information will be stored in each of these cells. And now if I wanted to get their mass, for example, I can go back to that same button. This time it says add column because I'm in a table. And as I scroll down, there's lots and lots of information I can extract on these planets. Including the mass. There it is. Notice it adds the label at the top, mass. If I wanted to, I could go in here. Maybe make it a capital. Mass. And I'm going to type in kgs like so. There we go. Click in the background to see the end result. So the new link data types here in Excel from Microsoft 365 are going to be a big time-saver. The list will continue to grow. You'll even be able to create your own custom data types with Power BI and Power Query here in Excel for Microsoft 365.
- Using natural language queries in Excel
- Getting writing assistance from Editor
- Using the Resume Assistant in Word
- Turning data into maps in Excel
- Setting access to linked files right within Outlook
- Creating better PowerPoint lists with Designer
- Using the math assistant in OneNote
- Working with Microsoft To-Do and Forms