If you have ever used Microsoft Excel to tabulate detailed data on stocks, foods, financial statements, etc., then you will definitely love these Excel Templates. Microsoft provides several templates of different data types to help you use for every situation.
Join the channel Telegram of the AnonyViet ๐ Link ๐ |
These Excel templates are applicable to the city data type for resettlement planning, the stock data type to track investments, and the food data type to record dietary calorie levels. your diet. And you can use excel templates for many other types of data as well.
Excel templates available and required
You can view and download the Excel templates available on the website Discover Data Types Templates by Microsoft. As of the time of this writing, the site has over 10 templates available, and each template has a brief description of how to use it. You can:
- Create a list of your favorite movies.
- Study the elements with the periodic table.
- Learn about planets and stars.
- Record the foods you eat and set dietary goals, or analyze the nutrition of recipes.
- Track your activities and exercise habits.
The data types feature in Excel is available to Microsoft 365 subscribers as well as those who use Excel on the web or as part of the Office Insiders program. You also need an internet connection to download these templates.
Load Excel templates of different data types
If you see a template you want to try, click its name to download it. Depending on whether you use Windows or Mac and which browser you use, you may be asked to save the file or open it immediately in Excel.
Using templates in Microsoft Excel
After you download the template and open it in Microsoft Excel. The โWelcomeโ tab will give you a useful, concise, and engaging summary of how to use that template.
In this article, I will use the Movie List template. With this template, you can keep track of your favorite movies, see the cast and total box office, and include your own ratings and reviews.
In the title field, enter the name of the movie you want to enter.
When you finish entering the movie name, the template will fill in the rest of the information such as actors, directors, characters, reviews, … completely automatically, or not?
If for some reason the movie name can’t be found, you’ll see a question mark next to the data. Click that question mark to open Data Selector, then search and select the movie you want.
Some templates have tabs for you to work with, and the data you add will also populate those tabs. For example, the Movie List template has a tab for Movie List as well as tabs for Dashboard and Cast.
The dashboard shows the movies you add to the list as movie posters and includes ratings as well as movies by decade and genre.
The Cast tab has a drop-down box at the top containing the movies that you add to your list. Select a movie from this box and you’ll see its cast, director, and producer.
Other tabs in the template can also contain more information. Movie List for example, if you go to the Cast tab, you can get more detailed information about an actor by clicking on the photo next to their name.
If you want to see more details of the data that is not in your spreadsheet, you can click the data type icon. Just like the example above, this will open the Data Card. You can see more information here.
After downloading one of these templates, be sure to look at each tab and icon for more details. When you’re done, remember to save the Excel file. You can also Become an expert if you know these 20 more tricks again.