{"id":267839,"date":"2021-06-04T17:24:07","date_gmt":"2021-06-04T14:24:07","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-templates-for-data-types-in-microsoft-excel\/"},"modified":"2021-06-04T17:24:07","modified_gmt":"2021-06-04T14:24:07","slug":"how-to-use-templates-for-data-types-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-templates-for-data-types-in-microsoft-excel\/","title":{"rendered":"#How to Use Templates for Data Types in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6b0061618cc88\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6b0061618cc88\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-templates-for-data-types-in-microsoft-excel\/#Available_Templates_and_Requirements\" >Available Templates and Requirements<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-templates-for-data-types-in-microsoft-excel\/#Download_a_Data_Types_Template\" >Download a Data Types Template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-templates-for-data-types-in-microsoft-excel\/#Use_a_Data_Types_Template_in_Microsoft_Excel\" >Use a Data Types Template in Microsoft Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use Templates for Data Types in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-725718\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019ve ever used Microsoft Excel\u2019s data types feature for details on geography, stocks, food, and more, then you\u2019ll love the addition of templates. Microsoft offers several data types templates to help you track all sorts of things.<\/p>\n<p>These templates help you use the cities data type to plan a relocation, the stocks data type to track your investments, and the food data type to log meals for your diet. But of course, there are more! Here, we\u2019ll help you view and obtain templates as well as work with an example to learn how to use it.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Available_Templates_and_Requirements\"><\/span>Available Templates and Requirements<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can view and <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">download<\/a> available templates on Microsoft\u2019s <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/discover-data-types-templates\/ba-p\/2037252\">Discover Data Types Templates<\/a> web page. As of this writing, there are almost a dozen handy templates available, and each has a brief description of how you can use it. You can:<\/p>\n<ul>\n<li>curate a list of your favorite <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">movies<\/a>.<\/li>\n<li>study the elements with an interactive periodic table.<\/li>\n<li>learn about planets and comets, or stars and constellations.<\/li>\n<li>get help selecting the right college.<\/li>\n<li>obtain details about cities you\u2019re considering moving to and use the checklist.<\/li>\n<li>keep a list of baby names you\u2019re contemplating.<\/li>\n<li>log the food that you eat and set dietary goals, or analyze your favorite recipes for nutrition details.<\/li>\n<li>track your activities and exercise routines.<\/li>\n<li>keep up with your stock portfolio.<\/li>\n<\/ul>\n<p>The data types feature in Excel is available to Microsoft 365 subscribers as well as to those who use Excel on the web or are part of the Office Insiders Program. You must also be connected to the internet, as the information comes from online sources.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Download_a_Data_Types_Template\"><\/span>Download a Data Types Template<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you see a template that you want to try, click its name (which is a download link) from <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/discover-data-types-templates\/ba-p\/2037252\">Microsoft\u2019s templates website<\/a>. Depending on whether you use Windows or Mac and which browser you use, you may be asked to save the file or to open it im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely in Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727202\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FavoriteMovieList-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click a template name to download it\" width=\"642\" height=\"150\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_a_Data_Types_Template_in_Microsoft_Excel\"><\/span>Use a Data Types Template in Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you download a template and open it in Microsoft Excel, it\u2019s ready for use right from the start. However, the \u201cWelcome\u201d tab gives you a helpful, short, and sweet summary of how to use that particular template. Each template is a bit different from the others, but they all begin with you entering a keyword or phrase.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727203\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/Welcome-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"View the Welcome tab\" width=\"650\" height=\"436\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For this how-to, we\u2019re going to use the Movie List template. With this template, you can track your favorite movies, view details like cast and box office totals, and include a rating and review of your own.<\/p>\n<p>Start by entering a keyword or phrase in the appropriate cell that applies to the data type. For the Movie List, you\u2019ll enter a film title.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727204\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/TypeHere-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter a key word or phrase\" width=\"650\" height=\"297\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you enter your item, the template takes over and fills in the remaining details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-727206 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/DataDetailsAdded-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Details added automatically\" width=\"650\" height=\"61\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If for some reason the data for your word or phrase cannot be found, you\u2019ll see a question mark next to it. Click the icon to open the Data Selector sidebar, and then search for and select the correct item.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727207\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/SelectCorrect-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the question mark and select the right item\" width=\"650\" height=\"407\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Some templates have several tabs for you to work with, and the data types that you add populate those, too. For example, our Movie List template has a tab for the actual Movie List as well as tabs for Dashboard and Cast.<\/p>\n<p>The Dashboard shows the films that you add to the list as movie poster images and includes ratings as well as movies by decade and genre.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727209\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/Dashboard-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Dashboard tab\" width=\"650\" height=\"399\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The Cast tab has a drop-down box at the top that populates with the movies that you add to your list. Select a film from this box and you\u2019ll see the movie\u2019s cast, director(s), and producer(s).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727208\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/Cast-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"585\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Other tabs in the template can also contain more information. Using our Movie List example, if we visit the Cast tab, we can get more details on a cast member by clicking the contact icon next to their name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727211\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MoreDetails-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"446\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019d like to see even more details for your data type that aren\u2019t in the spreadsheet, it\u2019s easy to do. Just click the data type icon next to it. Just like with the cast member icon above, this will open the Data Card. You can drag to resize it or simply scroll through for more information.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-727210\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MovieListDataCard-ExcelDataTypesTemplate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"391\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After grabbing one of these templates, be sure to check out each tab and icon for more details. When you finish, remember to save the file like any other Microsoft Excel workbook. Then, pop it open and add more data to it anytime!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use the Built-In Geography Feature in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/727200\/how-to-use-templates-for-data-types-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use Templates for Data Types in Microsoft Excel&#8221; If you\u2019ve ever used Microsoft Excel\u2019s data types feature for details on geography, stocks, food, and more, then you\u2019ll love the addition of templates. Microsoft offers several data types templates to help you track all sorts of things. These templates help you use the cities&#8230;<\/p>\n","protected":false},"author":1,"featured_media":267840,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-267839","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/267839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=267839"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/267839\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/267840"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=267839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=267839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=267839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}