Data types can help you achieve real-life goals more easily with the power and flexibility of Microsoft Excel. No more pasting from browsers or skimming search results, data types bring facts and data from trusted sources right into Excel.
Our data type templates help get things done faster, from comparing colleges to tracking investments to planning a movie night and more. In this post, we’d like to highlight what you can do with the new data types and provide links to the templates we’ve created to help you get started.
|
Curate a list of your favorite movies. Keep a list of the movies you’ve watched or want to watch, enter your rating and notes for each movie, and see each movie’s actors, characters, and more. |
|
|
Learn about the elements with this interactive periodic table. |
|
|
Learn about the planets and comets in our solar system. Perfect for amateur astronomers. |
|
|
Learn about the stars and constellations. A great way to explore the universe from the comfort of your couch. |
|
|
Get the help you need to choose a college in the United States. Learn about the colleges you’re interested in, compare colleges to narrow down your choices, and keep track of your applications after you’re decided to apply. |
|
|
Relocate to a new city with confidence. Learn about the cities you’re interested in, compare cities to narrow down your choice, and keep track of the things you need to do after you’ve decided to move. |
|
|
Pick the perfect name for your little one. Keep a list of the names you’re considering, see historical trends, and find famous people with similar names. |
|
|
Get healthier by tracking your nutrition. Set personal dietary and nutrition goals, keep track of the food you eat, and see the calories, carbs, protein, and fats you consume. |
|
|
Eat healthier by analyzing your favorite recipes. Enter the ingredients in each recipe, and see the calories, carbs, proteins, and fat each ingredient has. |
|
|
Get healthier by tracking your activities. Enter some basic info about yourself, keep track of the activities you do each day, and see how many calories and ounces of fat you burn with each activity. |
|
|
Keep an eye on your portfolio by entering stocks and ETF’s you own to monitor trends and compare stocks. The data can be refreshed to make sure you’re always up to date with the current prices. |
How to use data types
- Open a blank Excel workbook.
- Type “Earth” into A1.
- To convert the text into a data type, select A1, and then select Data > expand the Data Types gallery > select Space .
- See available data you can work with by selecting the icon next to Earth to view the card.
- Insert data into the sheet by hovering over a field in the card and select the Insert Data button that appears. Otherwise, select the cell containing Earth and click the Insert Data button on the top right corner of the cell.
Requirements
To use the new data types and templates, you need:
- A Microsoft 365 Family or Personal subscription with the English editing language added to your Office Language Preferences.
- To be using Excel on the Web or have joined the Office Insider program:
- Windows build 16.0.13426.20184: all subscribers in the Beta Channel and a portion of the subscribers in the Current Channel (Preview) of the Office Insider program.
- Mac build 16.44.1206.0: all subscribers in the Beta Channel and a portion of the subscribers in the Current Channel (Preview).
To learn more about the Office Insiders program, see When do I get the newest features for Microsoft 365?.
Feedback
Send us feedback and suggestions on data types:
- Give feedback in the templates form.
- In Excel for Windows Desktop and Web: Click Help > Feedback.
- In Excel for Mac: Click the Feedback button near the top-right corner in Excel.
Learn what other information you should include in your feedback to ensure it’s actionable and reaches the right people. Ask questions and get answers from us and others in the community by joining our Excel Community. We’re excited to hear from you!
Artigo originalmente postado em Excel Blog