From the course: Microsoft 365 New Features

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use new data types in Excel

Use new data types in Excel

From the course: Microsoft 365 New Features

Start my 1-month free trial

Use new 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…

Contents