Excel lets you use food, movies, space, and more data types

by Don Sharpe
Don Sharpe
Don Sharpe
Author
Don has been writing professionally for over 10 years now, but his passion for the written word started back in his elementary school days. His work has been... read more
Affiliate Disclosure
  • More than 100 new Excel data types are available for Preview.
  • Office insiders on Windows 10 and Mac, and with a Microsoft 365 subscription can start working with the new data types in Excel.
  • You may check out the Excel section at any time for tips and how-to guides.
  • Visit the Windows 10 page to learn more about MS Office applications.
Excel new data types include food, movies, etc
XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various Windows 10 errors, we recommend Restoro:This software will repair common computer errors, protect you from file loss, malware damage, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove virus damage now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows 10 issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

What type of data do you mostly handle or process in Excel day to day? Names of places, movies, food?

Well, from now on, you don’t have to assign generic types, such as, text or integers, to that kind of data.

Where relevant or applicable, you have the option to use any of the more than 100 new Excel data types that Microsoft launched to Office insiders on Windows 10 and Mac.

New Microsoft Excel data types

If you’re an Office insider with a Microsoft 365 subscription, you can start working with the new data types in Excel, including:

Food: calories, carbohydrates, fats, vitamins, nutrients, etc.

Exercise: exercise types and calories burned.

Locations: zip codes, economic data, airports, schools, forests,etc.

Universities: graduation rates, tuition, student body, etc.

Chemistry: elements, compounds, and minerals.

Space: planets, moons, satellites, supernovas, space missions, etc.

Movies: actors, characters, directors, release dates, poster art,etc.

And More: music, plants, animal breeds, famous people, languages, etc.

Moreover, you can assign properties to your data types. For example, the food data type has properties like calories and nutrients.

You can reference data types with formulas besides creating your data types in Excel. Also, you can manipulate the data as you’d typically do in a table.

For example, you may filter or sort your data based on the new properties.

In addition, the feature comes with a couple of automations to let you quickly get started on crunching the numbers.

Creating a table for the Food data type is a perfect example. When you add a column to the right of the Food table, you’ll get auto-suggestions for a single field or multiple fields. Also, Excel will auto-fill the columns with their respective values.

The new Excel data types are yet another consumer-focused feature that Microsoft is bringing to the spreadsheet application. A few weeks ago, the company announced Money in Excel, a personal finance management tool aimed at individual consumers.

If you’re an Office insider, have you received the new Microsoft Excel data types yet? Kindly let us know in the comments section below.

Still having issues? Fix them with this tool:

SPONSORED

If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: