{"id":179433,"date":"2018-09-13T09:13:56","date_gmt":"2018-09-13T14:13:56","guid":{"rendered":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/"},"modified":"2018-09-13T09:13:56","modified_gmt":"2018-09-13T14:13:56","slug":"the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel","status":"publish","type":"post","link":"https:\/\/ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/","title":{"rendered":"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel"},"content":{"rendered":"

[youtube https:\/\/www.youtube.com\/watch?v=gbImc7A8_Q8&w=560&h=349]<\/p>\n

To date, Excel and similar apps deal primarily with text and numbers as data types. However, that tradition is about to be a thing of the past as Microsoft is adding two new data types to Excel. These data types allow cells to contain rich, intelligent data that can better represent more real-world data types.<\/p>\n

[youtube https:\/\/www.youtube.com\/watch?v=gbImc7A8_Q8]<\/p>\n

Limitations and Possibilities<\/h2>\n

Suppose you are putting together a spreadsheet that will plot the relationship between a company\u2019s sales and population in South America. The sales data is easy enough to find, but tracking down the latest population for each South American country might be a bit time consuming and error-prone. At the last minute, someone asks for data that shows sales related to the size of the country, which means another session of hunting down the right information.<\/p>\n

What if you could have all that information for a country \u2014 population, square miles, map, gross national product, average minimum wage and more \u2013 all contained in a single cell within your worksheet? Believe it or not, those days are not too far away.<\/p>\n

Excel\u2019s New Intelligent Data Types<\/h2>\n

There are two new intelligent data types available in Excel<\/a>: Geography and Stocks. That means that cells in your Excel workbook are no longer limited to holding flat information like text, numbers, or dates. Cells can now house an incredible amount of information related to geography and stocks. Not only can you access this information easily, you can even work with it when you are offline. Both of these data types can be found under the Data tab in Excel, and converting existing data to either of these types is very simple.<\/p>\n

Working with the New Geography Data Type<\/h2>\n

Let\u2019s suppose we have a worksheet that contains a single-column table. The table contains strings that represent countries. To convert this data to the new Geography data type, highlight the country names, then go to the Data tab and click on Geography. This takes care of the conversion.<\/p>\n

You\u2019ll notice that an icon appears in the cells next to each country name. It resembles a map that has been unfolded. If you click on that icon, you\u2019ll see a data card that contains tons of information about that country. Now that cell is no longer just a string of characters, but a rich data type with much deeper meaning. All of the data from the data card is actually contained in that cell, and you don\u2019t need an internet connection to access that data.<\/p>\n

You will notice that a widget appears to the right at the top of the table. If you click on it, it offers to add another column. You can select from a list of available fields based on the data contained in the card you just looked at.<\/p>\n

\"Microsoft<\/p>\n

Stock Data Type<\/h2>\n

The Stock Data type works in a similar manner to the Geography data type but provides access to data involving stocks. Let\u2019s say you have a table with a single column that contains some company names and some ticker names. You highlight that data, then go to the Data tab and select Stocks. That converts the string data into the new Stock data type, and all the names are switched to company names. You\u2019ll notice that an icon appears by each company name, allowing you to access the data card for that company.<\/p>\n

Stock data changes quickly, unlike the Geography data. Because of the dynamic nature of Stock data, the data is refreshable. Some of it is available in almost real-time, while other data will be delayed. If you want to do calculations with cells that contain either the Geography or Stock data type, type in a formula referencing the cell number and then use the . (dot operator) to select the correct member of that geography object. Anything you can do with normal data, you can do with these new data types.<\/p>\n

Intelligent Data Types<\/h2>\n

The Microsoft Knowledge Graph, the intelligent service that also powers Bing, is what provides the data. When someone points out that the Stock and Geography data types are intelligent, that means far more than fixing typos or spelling errors. For example, these intelligent data types can interpret data requests in context. It may ask for more specifics if you enter a city name and convert it to the Geography data type because it wants to make sure what city you mean. However, if a city is listed with other city names in a particular geographical region, then Excel will select a city in that particular region (context).<\/p>\n

Accessing It<\/h2>\n

Not all Excel 365 users can access these new AI data types just yet. According to Microsoft<\/a>,<\/p>\n

\u201cThe new data types are being released as preview to Office 365 subscribers enrolled in the Office Insiders<\/a> program, in the English language only, starting in April 2018. \u201c<\/p>\n

However, it will eventually be rolled out for all Office 365 users. And other AI data types will also be added to Microsoft Excel\u2019s repertoire. These developments mean that in Excel you can do even more, even faster.<\/p>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

[youtube https:\/\/www.youtube.com\/watch?v=gbImc7A8_Q8&w=560&h=349] To date, Excel and similar apps deal primarily with text and numbers as data types. However, that tradition is about to be a thing of the past as Microsoft is adding two new data types to Excel. These data types allow cells to contain rich, intelligent data that can better represent more real-world…<\/p>\n","protected":false},"author":5,"featured_media":158928,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[8],"tags":[64],"class_list":["post-179433","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-techbytes"],"acf":[],"yoast_head":"\nThe Intelligent New (and Awesome) Data Types Supported by Microsoft Excel - IT Services in Virginia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel - IT Services in Virginia\" \/>\n<meta property=\"og:description\" content=\"[youtube https:\/\/www.youtube.com\/watch?v=gbImc7A8_Q8&w=560&h=349] To date, Excel and similar apps deal primarily with text and numbers as data types. However, that tradition is about to be a thing of the past as Microsoft is adding two new data types to Excel. These data types allow cells to contain rich, intelligent data that can better represent more real-world…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"IT Services in Virginia\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-13T14:13:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914.jpg\" \/>\n<meta name=\"author\" content=\"Steve West\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steve West\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/\",\"url\":\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/\",\"name\":\"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel - IT Services in Virginia\",\"isPartOf\":{\"@id\":\"https:\/\/www.ntegrait.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914-1.jpg\",\"datePublished\":\"2018-09-13T14:13:56+00:00\",\"dateModified\":\"2018-09-13T14:13:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#primaryimage\",\"url\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914-1.jpg\",\"contentUrl\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914-1.jpg\",\"width\":509,\"height\":339},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ntegrait.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.ntegrait.com\/#website\",\"url\":\"https:\/\/www.ntegrait.com\/\",\"name\":\"IT Services in Virginia\",\"description\":\"Ntegra IT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.ntegrait.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79\",\"name\":\"Steve West\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g\",\"caption\":\"Steve West\"},\"description\":\"Ntegra IT is devoted to providing reliable Computer Support to businesses that want to improve productivity and profitability. We deliver custom designed Network Services that better map to your business, so you can stop worrying about your technology and get back to achieving your business goals.\",\"url\":\"https:\/\/ntegrait.com\/author\/swestntegrait-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel - IT Services in Virginia","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel - IT Services in Virginia","og_description":"[youtube https:\/\/www.youtube.com\/watch?v=gbImc7A8_Q8&w=560&h=349] To date, Excel and similar apps deal primarily with text and numbers as data types. However, that tradition is about to be a thing of the past as Microsoft is adding two new data types to Excel. These data types allow cells to contain rich, intelligent data that can better represent more real-world…","og_url":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/","og_site_name":"IT Services in Virginia","article_published_time":"2018-09-13T14:13:56+00:00","og_image":[{"url":"https:\/\/www.ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914.jpg","type":"","width":"","height":""}],"author":"Steve West","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steve West","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/","url":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/","name":"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel - IT Services in Virginia","isPartOf":{"@id":"https:\/\/www.ntegrait.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914-1.jpg","datePublished":"2018-09-13T14:13:56+00:00","dateModified":"2018-09-13T14:13:56+00:00","author":{"@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79"},"breadcrumb":{"@id":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#primaryimage","url":"https:\/\/ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914-1.jpg","contentUrl":"https:\/\/ntegrait.com\/wp-content\/uploads\/2018\/09\/GettyImages-881609914-1.jpg","width":509,"height":339},{"@type":"BreadcrumbList","@id":"https:\/\/www.ntegrait.com\/the-intelligent-new-and-awesome-data-types-supported-by-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ntegrait.com\/"},{"@type":"ListItem","position":2,"name":"The Intelligent New (and Awesome) Data Types Supported by Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.ntegrait.com\/#website","url":"https:\/\/www.ntegrait.com\/","name":"IT Services in Virginia","description":"Ntegra IT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ntegrait.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79","name":"Steve West","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g","caption":"Steve West"},"description":"Ntegra IT is devoted to providing reliable Computer Support to businesses that want to improve productivity and profitability. We deliver custom designed Network Services that better map to your business, so you can stop worrying about your technology and get back to achieving your business goals.","url":"https:\/\/ntegrait.com\/author\/swestntegrait-com\/"}]}},"_links":{"self":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts\/179433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/comments?post=179433"}],"version-history":[{"count":0,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts\/179433\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/media\/158928"}],"wp:attachment":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/media?parent=179433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/categories?post=179433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/tags?post=179433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}