{"id":597,"date":"2018-09-24T06:00:22","date_gmt":"2018-09-24T13:00:22","guid":{"rendered":"https:\/\/www.microsoft.com\/en-za\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/"},"modified":"2022-06-28T10:51:48","modified_gmt":"2022-06-28T17:51:48","slug":"bringing-ai-to-excel-4-new-features-announced-today-at-ignite","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/","title":{"rendered":"Bringing AI to Excel\u20144 new features announced today at Ignite"},"content":{"rendered":"<p>Excel\u2019s power comes from its simplicity. At its core, <a href=\"https:\/\/products.office.com\/excel\" target=\"_blank\" rel=\"noopener noreferrer\">Excel<\/a> is three things: cells of data laid out in rows and columns, a powerful calculation engine, and a set of tools for working with the data. The result is an incredibly flexible app that hundreds of millions of people use daily in a wide variety of jobs and industries around the world.<\/p>\n<p>Today, we\u2019re pleased to announce four new artificial intelligence (AI) features that make Excel even more powerful:<\/p>\n<ul>\n<li>Ideas<\/li>\n<li>New data types<\/li>\n<li>Insert Data from Picture<\/li>\n<li>Dynamic arrays<\/li>\n<\/ul>\n<h3>Introducing intelligent suggestions with Ideas<\/h3>\n<p>Ideas is an AI-powered insights service that helps people take advantage of the full power of Office. Proactively surfacing suggestions that are tailored to the task at hand, Ideas helps users create professional documents, presentations, and spreadsheets in less time. In Excel, for instance, Ideas helps identify trends, patterns, and outliers in a data set\u2014helping customers analyze and understand their data in seconds. Ideas is generally available in Excel today and will begin rolling out in preview to other apps starting with PowerPoint Online. Simply click the lightning bolt icon in Excel or PowerPoint Online and Ideas will start making recommendations. Read more about Ideas in this <a href=\"https:\/\/support.office.com\/article\/3223aab8-f543-4fda-85ed-76bb0295ffc4\" target=\"_blank\" rel=\"noopener noreferrer\">support article<\/a>.<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-228662\" src=\"http:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-1b-1.png\" alt=\"An animated image shows Ideas in Excel.\" width=\"1530\" height=\"781\" srcset=\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-1b-1.png 1530w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-1b-1-300x153.png 300w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-1b-1-768x392.png 768w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-1b-1-1024x523.png 1024w\" sizes=\"(max-width: 1530px) 100vw, 1530px\" \/><\/h3>\n<h3>Making new data types generally available today<\/h3>\n<p>Excel has always been great at helping people make the most of numbers. But now Excel can do even more: It can recognize real-world concepts, starting with Stocks and Geography. This new AI-powered capability turns a single, flat piece of text into an interactive entity containing layers of rich information. For instance, by converting a list of countries in a workbook to \u201cGeography\u201d entities, customers can weave location data into an analysis of their own data. And this new capability\u2014though deceptively simple\u2014opens a whole new world of possibilities. As we add new data types over time, Excel\u2019s rows, columns, cells, logic engine, and tools can be used to organize, analyze, and reason over any combination of numbers and sophisticated entities. The Stocks and Geography data types are generally available today. Read more about data types in this <a href=\"https:\/\/support.office.com\/article\/61a33056-9935-484f-8ac8-f1a89e210877\" target=\"_blank\" rel=\"noopener noreferrer\">support article<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-228618\" src=\"http:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-1-v2b-1.png\" alt=\"Image shows the Geography data type in Excel.\" width=\"900\" height=\"460\" srcset=\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-1-v2b-1.png 1400w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-1-v2b-1-300x153.png 300w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-1-v2b-1-768x392.png 768w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-1-v2b-1-1024x523.png 1024w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/p>\n<h3>Saying goodbye to manual data entry<\/h3>\n<p>With <strong>Insert Data from Picture<\/strong>, you can take a picture of a hand-drawn or printed data table with your Android device and convert that analog information into an Excel spreadsheet with a single click. New image recognition functionality automatically converts the picture to a fully editable table in Excel, eliminating the need for you to manually enter data. Insert Data from Picture will be available in preview for the Excel Android app soon.<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-228663\" src=\"http:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-3.png\" alt=\"An animated image shows Insert Data from Picture being used on a mobile device.\" width=\"306\" height=\"410\" srcset=\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-3.png 306w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-3-224x300.png 224w\" sizes=\"(max-width: 306px) 100vw, 306px\" \/><\/h3>\n<h3>Calculating with ease using dynamic arrays<\/h3>\n<p>With dynamic arrays, we continue to invest in making advanced formulas easier to use. Using dynamic arrays, any formula that returns an array of values will seamlessly \u201cspill\u201d into neighboring unoccupied cells, making it as easy to get an array of values returned as it is to work on a single cell. You can immediately harness the power of dynamic arrays by using one the new FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, SINGLE, and RANDARRAY functions to build spreadsheets that would previously have been nearly impossible. So now, rather than writing many complex formulas to solve a multi-cell problem, you can write one simple formula and get an array of values returned.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-228664\" src=\"http:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-4.png\" alt=\"An animated image shows Dynamic Arrays in Excel.\" width=\"675\" height=\"378\" srcset=\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-4.png 675w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-4-300x168.png 300w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-4-539x303.png 539w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/p>\n<h3>Faster LOOKUP and MATCH<\/h3>\n<p>We\u2019re not only adding new capabilities to Excel, we\u2019re also continually improving the features customers already know and love. For example, we have invested in significant performance improvements for important lookup functions. We\u2019re pleased to announce that VLOOKUP, HLOOKUP, and MATCH functions operating on large data sets will now execute in seconds instead of minutes. We\u2019ve also improved performance on many key operations like copy\/paste, undo, conditional formatting, cell editing, cell selection, filtering, file open, and programmability.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-228665\" src=\"http:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-5.png\" alt=\"An animated image shows the LOOKUP function in Excel.\" width=\"760\" height=\"427\" srcset=\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-5.png 760w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-5-300x169.png 300w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-5-539x303.png 539w, https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-AI-image-5-465x262.png 465w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/p>\n<p>We\u2019re excited about these new features and hope you are, too. For us, Excel isn\u2019t just a tool\u2014it\u2019s a way of life! And today\u2019s announcements not only deliver incremental improvements in data handling and performance, they also push the app into new territory with new data types and AI-powered analysis services. We look forward to showing you more at Ignite this week and can\u2019t wait to see what you do with it all. As always, we\u2019d love to hear from you, so please send us your thoughts through <a href=\"https:\/\/excel.uservoice.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">UserVoice<\/a>\u2014and keep the conversation going by following Excel on <a href=\"https:\/\/www.facebook.com\/microsoftexcel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Facebook<\/a> and <a href=\"https:\/\/twitter.com\/msexcel?ref_src=twsrc%5egoogle%7ctwcamp%5eserp%7ctwgr%5eauthor\" target=\"_blank\" rel=\"noopener noreferrer\">Twitter<\/a>.<\/p>\n<h3>Availability<\/h3>\n<ul>\n<li>Ideas will be available starting today.<\/li>\n<li>New data types are rolling out to users of Excel in Office 365, in the English language only starting today.<\/li>\n<li>Performance improvements are rolling out first to Excel in Office 365 starting today.<\/li>\n<li>Dynamic arrays is available in preview for users signed up for the Office 365 Insiders Program starting today.<\/li>\n<li>The Insert Data from Picture feature will be available in preview for users signed up for the Office 365 Insiders Program on the Android Excel app soon.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u2019s power comes from its simplicity. At its core, Excel is three things: cells of data laid out in rows and columns, a powerful calculation engine, and a set of tools for working with the data. The result is an incredibly flexible app that hundreds of millions of people use daily in a wide variety<\/p>\n","protected":false},"author":0,"featured_media":603,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[148,149],"product":[162,151,178],"audience":[196,216,217],"tags":[],"coauthors":[],"class_list":["post-597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-events","content-type-news","product-excel","product-microsoft-365","product-powerpoint","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bringing AI to Excel\u20144 new features announced today at Ignite - Microsoft 365 Blog<\/title>\n<meta name=\"description\" content=\"AI-powered features for Excel, including new data types, dynamic arrays, Ideas, and more, will help you expedite data analysis and make better decisions.\" \/>\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.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bringing AI to Excel\u20144 new features announced today at Ignite - Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"AI-powered features for Excel, including new data types, dynamic arrays, Ideas, and more, will help you expedite data analysis and make better decisions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-24T13:00:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-28T17:51:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2018\/09\/Excel-Ai-featured-image-SOCIAL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2018\/09\/Excel-Ai-featured-image-SOCIAL.png\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"Bringing AI to Excel\u20144 new features announced today at Ignite\",\"datePublished\":\"2018-09-24T13:00:22+00:00\",\"dateModified\":\"2022-06-28T17:51:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/\"},\"wordCount\":836,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png\",\"inLanguage\":\"en-ZA\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/\",\"url\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/\",\"name\":\"Bringing AI to Excel\u20144 new features announced today at Ignite - Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png\",\"datePublished\":\"2018-09-24T13:00:22+00:00\",\"dateModified\":\"2022-06-28T17:51:48+00:00\",\"description\":\"AI-powered features for Excel, including new data types, dynamic arrays, Ideas, and more, will help you expedite data analysis and make better decisions.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#breadcrumb\"},\"inLanguage\":\"en-ZA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-ZA\",\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png\",\"width\":440,\"height\":268,\"caption\":\"Image of a man at work in front of a laptop.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bringing AI to Excel\u20144 new features announced today at Ignite\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-ZA\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-ZA\",\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2022\/06\/ms-logo-amp.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2022\/06\/ms-logo-amp.webp\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bringing AI to Excel\u20144 new features announced today at Ignite - Microsoft 365 Blog","description":"AI-powered features for Excel, including new data types, dynamic arrays, Ideas, and more, will help you expedite data analysis and make better decisions.","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.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/","og_locale":"en_US","og_type":"article","og_title":"Bringing AI to Excel\u20144 new features announced today at Ignite - Microsoft 365 Blog","og_description":"AI-powered features for Excel, including new data types, dynamic arrays, Ideas, and more, will help you expedite data analysis and make better decisions.","og_url":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2018-09-24T13:00:22+00:00","article_modified_time":"2022-06-28T17:51:48+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2018\/09\/Excel-Ai-featured-image-SOCIAL.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2018\/09\/Excel-Ai-featured-image-SOCIAL.png","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/"},"author":{"name":"","@id":""},"headline":"Bringing AI to Excel\u20144 new features announced today at Ignite","datePublished":"2018-09-24T13:00:22+00:00","dateModified":"2022-06-28T17:51:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/"},"wordCount":836,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png","inLanguage":"en-ZA","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/","url":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/","name":"Bringing AI to Excel\u20144 new features announced today at Ignite - Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png","datePublished":"2018-09-24T13:00:22+00:00","dateModified":"2022-06-28T17:51:48+00:00","description":"AI-powered features for Excel, including new data types, dynamic arrays, Ideas, and more, will help you expedite data analysis and make better decisions.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#breadcrumb"},"inLanguage":"en-ZA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/"]}]},{"@type":"ImageObject","inLanguage":"en-ZA","@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png","contentUrl":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2018\/09\/Excel-Ai-featured-image-1.png","width":440,"height":268,"caption":"Image of a man at work in front of a laptop."},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/2018\/09\/24\/bringing-ai-to-excel-4-new-features-announced-today-at-ignite\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Bringing AI to Excel\u20144 new features announced today at Ignite"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"","publisher":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-ZA"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-ZA","@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2022\/06\/ms-logo-amp.webp","contentUrl":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-content\/uploads\/sites\/21\/2022\/06\/ms-logo-amp.webp","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/597"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=597"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/597\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/media\/603"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=597"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=597"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=597"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=597"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-za\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}