{"id":1065,"date":"2019-02-06T10:00:18","date_gmt":"2019-02-06T18:00:18","guid":{"rendered":"https:\/\/www.microsoft.com\/en-au\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/"},"modified":"2022-06-28T10:43:11","modified_gmt":"2022-06-28T17:43:11","slug":"excel-with-microsoft-excel-in-office-365","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/","title":{"rendered":"Excel with Microsoft Excel in Office 365"},"content":{"rendered":"<p><em>Today\u2019s post was written by Jeremy, one of the twins who took part in <\/em><em><a href=\"https:\/\/www.microsoft.com\/microsoft-365\/blog\/2019\/02\/06\/the-twins-challenge-office-365-crushes-office-2019\/\" target=\"_blank\" rel=\"noopener noreferrer\">The Twins Challenge: Office 365 versus Office 2019<\/a><\/em><em>.<\/em><\/p>\n<p><iframe loading=\"lazy\" width=\"1152\" height=\"648\" src=\"https:\/\/www.youtube.com\/embed\/Zz-lxoHKfMg?start=5&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p>When Microsoft invited me and my twin brother Nathan to come to Redmond to its film studios to participate in a \u201cchallenge,\u201d we had no idea what we were getting into. They told us it would be fun and all we had to do was be ourselves. Always up for a challenge, we took the offer and, when we got there, found out we\u2019d be competing against each other, but not in a way we ever had before.<\/p>\n<p>We were given a handful of tasks to complete using two different versions of Excel. Nathan had Excel for Office 2019 and I had Excel for Office 365. Neither of us even knew there were different versions of Excel, much less how one would compete against the other.<\/p>\n<p>As it turns out, I smoked Nathan at all the tasks, thanks to the help of artificial intelligence (AI) and a feature called Data Types in Excel for Office 365.<\/p>\n<p>Since that time, I\u2019ve been using Excel for Office 365 in new ways and thought it would be a shame to keep all these newfound skills I\u2019ve learned from Microsoft to myself.<\/p>\n<p>Here are some of my favorite time-savers:<\/p>\n<ol>\n<li><strong>Data types in Excel<\/strong>\u2014This is a super cool research tool. While you can see me use it to add the capitals, population, and largest cities for all 50 states in the U.S. in almost no time (seriously, I embarrassed my brother with this one), I\u2019ve been using it lately to track my stock investments. I can easily see a range of data on all my positions with a simple click, letting me identify trends and (hopefully) make better investing decisions. My friends at Microsoft told me there will be more data types rolled out in the future, so keep an eye on this one to see what it will do next.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-229120 size-full\" src=\"http:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-1b-1.png\" alt=\"Image of an Excel spreadsheet open on a laptop. Data types are being used.\" width=\"1400\" height=\"715\" srcset=\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-1b-1.png 1400w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-1b-1-300x153.png 300w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-1b-1-768x392.png 768w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-1b-1-1024x523.png 1024w\" sizes=\"(max-width: 1400px) 100vw, 1400px\" \/><\/p>\n<ol start=\"2\">\n<li><strong>Ideas<\/strong>\u2014Identify trends, patterns, and outliers in a data set and understand your numbers in seconds with Ideas, which is basically like having a data guru look at your numbers and provide suggestions as to what it could indicate\u2014all without having to have the guru! Ideas also helps you graphically display your data in the best chart or graph format for the data type. To get Ideas, click the <strong>lightning bolt<\/strong> icon in the top right corner of the ribbon under the <strong>Home <\/strong>tab.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-229140\" src=\"http:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-2b.png\" alt=\"\" width=\"1520\" height=\"777\" srcset=\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-2b.png 1520w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-2b-300x153.png 300w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-2b-768x393.png 768w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-2b-1024x523.png 1024w\" sizes=\"(max-width: 1520px) 100vw, 1520px\" \/><\/p>\n<ol start=\"3\">\n<li><strong>Dynamic Arrays<\/strong>\u2014This one is a little complex, but it takes something that was <em>really<\/em> complex before and makes it much easier. If you struggle to filter data to find actionable insights, Dynamic Arrays will make you feel like a data-slicing pro. You can filter, sort, and single out data without writing a bunch of custom formulas. 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. There are a bunch of new functions that make it easy to build spreadsheets that would previously have been nearly impossible. Joe McDaid, senior program manager at Microsoft, <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/Excel-Blog\/Preview-of-Dynamic-Arrays-in-Excel\/ba-p\/252944\" target=\"_blank\" rel=\"noopener noreferrer\">explains it way better than I can<\/a>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-229141\" src=\"http:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-3.png\" alt=\"\" width=\"673\" height=\"377\" srcset=\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-3.png 673w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-3-300x168.png 300w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-3-539x303.png 539w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/p>\n<ol start=\"4\">\n<li><strong>Threaded comments<\/strong>\u2014Long-time Excel users know how important this feature is. It used to be difficult to leave a comment on a specific cell of a workbook. Now using @mentions and nested replies, you can easily follow conversations taking place around content in a cell and directly interact with coworkers. Along with the ability to coauthor in real-time, it\u2019s so much easier to work in spreadsheets with multiple collaborators and make edits from any device. While I think this is awesome for Excel, it also works in Word and PowerPoint, should you be so inclined.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-229144\" src=\"http:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-4-1.png\" alt=\"\" width=\"896\" height=\"597\" srcset=\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-4-1.png 896w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-4-1-300x200.png 300w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-4-1-768x512.png 768w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-4-1-293x195.png 293w\" sizes=\"(max-width: 896px) 100vw, 896px\" \/><\/p>\n<ol start=\"5\">\n<li><strong>Coming soon: Insert Data from Picture<\/strong>\u2014This one is just between us, but I had to share it. When I was at Microsoft, I got a preview of a feature that\u2019s in the works that you should look out for soon (early spring 2019). How many times have you been in a meeting and someone has drawn a concept on a whiteboard that has to be manually re-created in Excel? You don\u2019t have to retype that data anymore! No really, you don\u2019t have to retype it. You can simply use the Insert Data from Picture feature. Excel takes the contents of the picture and converts it into cells. Click. Boom. Done!<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-229143\" src=\"http:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-5b.png\" alt=\"\" width=\"209\" height=\"409\" srcset=\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-5b.png 209w, https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-5b-153x300.png 153w\" sizes=\"(max-width: 209px) 100vw, 209px\" \/><\/p>\n<p>And, these are just a handful of my favorite features in Excel for Office 365. If you want to try them out but don\u2019t have Office 365, you can get a <a href=\"https:\/\/products.office.com\/try\" target=\"_blank\" rel=\"noopener noreferrer\">free trial and give it a test run<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em>Note: Ideas, Dynamic Arrays<\/em><\/strong><em>, and<strong> Insert Data from Picture <\/strong>are available <\/em><em>in preview to Office 365 subscribers enrolled in the <\/em><em><a href=\"https:\/\/insider.office.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Office Insiders program<\/a><\/em><em>.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today\u2019s post was written by Jeremy, one of the twins who took part in The Twins Challenge: Office 365 versus Office 2019. When Microsoft invited me and my twin brother Nathan to come to Redmond to its film studios to participate in a \u201cchallenge,\u201d we had no idea what we were getting into. They told<\/p>\n","protected":false},"author":0,"featured_media":1071,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[146],"product":[159,148],"audience":[193,213,214],"tags":[],"coauthors":[],"class_list":["post-1065","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-news","product-excel","product-microsoft-365","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>Excel with Microsoft Excel in Office 365 - Microsoft 365 Blog<\/title>\n<meta name=\"description\" content=\"A twin, Jared, shares his top tips and tricks from The Twins Challenge: Office 365 versus Office 2019.\" \/>\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-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel with Microsoft Excel in Office 365 - Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"A twin, Jared, shares his top tips and tricks from The Twins Challenge: Office 365 versus Office 2019.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-06T18:00:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-28T17:43:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-full-size.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: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-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"Excel with Microsoft Excel in Office 365\",\"datePublished\":\"2019-02-06T18:00:18+00:00\",\"dateModified\":\"2022-06-28T17:43:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/\"},\"wordCount\":820,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png\",\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/\",\"url\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/\",\"name\":\"Excel with Microsoft Excel in Office 365 - Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png\",\"datePublished\":\"2019-02-06T18:00:18+00:00\",\"dateModified\":\"2022-06-28T17:43:11+00:00\",\"description\":\"A twin, Jared, shares his top tips and tricks from The Twins Challenge: Office 365 versus Office 2019.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png\",\"width\":440,\"height\":268,\"caption\":\"Image of an Excel document open on a laptop.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel with Microsoft Excel in Office 365\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2022\/06\/ms-logo-amp.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2022\/06\/ms-logo-amp.webp\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel with Microsoft Excel in Office 365 - Microsoft 365 Blog","description":"A twin, Jared, shares his top tips and tricks from The Twins Challenge: Office 365 versus Office 2019.","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-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/","og_locale":"en_US","og_type":"article","og_title":"Excel with Microsoft Excel in Office 365 - Microsoft 365 Blog","og_description":"A twin, Jared, shares his top tips and tricks from The Twins Challenge: Office 365 versus Office 2019.","og_url":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2019-02-06T18:00:18+00:00","article_modified_time":"2022-06-28T17:43:11+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-full-size.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/"},"author":{"name":"","@id":""},"headline":"Excel with Microsoft Excel in Office 365","datePublished":"2019-02-06T18:00:18+00:00","dateModified":"2022-06-28T17:43:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/"},"wordCount":820,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png","inLanguage":"en-AU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/","url":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/","name":"Excel with Microsoft Excel in Office 365 - Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png","datePublished":"2019-02-06T18:00:18+00:00","dateModified":"2022-06-28T17:43:11+00:00","description":"A twin, Jared, shares his top tips and tricks from The Twins Challenge: Office 365 versus Office 2019.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png","contentUrl":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-card.png","width":440,"height":268,"caption":"Image of an Excel document open on a laptop."},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/2019\/02\/06\/excel-with-microsoft-excel-in-office-365\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel with Microsoft Excel in Office 365"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"","publisher":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2022\/06\/ms-logo-amp.webp","contentUrl":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-content\/uploads\/sites\/13\/2022\/06\/ms-logo-amp.webp","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/1065"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=1065"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/1065\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/media\/1071"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=1065"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=1065"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=1065"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=1065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=1065"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-au\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=1065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}