{"id":9614,"date":"2018-11-07T20:28:58","date_gmt":"2018-11-07T19:28:58","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9614"},"modified":"2024-02-06T18:27:44","modified_gmt":"2024-02-06T17:27:44","slug":"022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen\/","title":{"rendered":"022: New Microsoft Office 365 Excel Features with Mr. Excel Bill Jelen"},"content":{"rendered":"<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"0be6122c\"><\/div><div class=\"spp-shsp-form spp-shsp-form-0be6122c\"><\/div>\n<p><a href=\"http:\/\/traffic.libsyn.com\/myexcelonline\/022_New_Excel_features_in_Office_365_With_Bill_Jelen.mp3\" target=\"_blank\" rel=\"noopener nofollow\">Listen on Web Browser &gt;&gt;<\/a><\/p>\n<p>Microsoft recently released some new Excel features\u00a0in their Office 365 subscription license.<\/p>\n<p>What better way to talk about these new Excel features than with <strong>Bill Jelen<\/strong> from <a href=\"https:\/\/www.mrexcel.com\" target=\"_blank\" rel=\"noopener nofollow\">MrExcel.com<\/a> who has published more than 50 books about Excel!<\/p>\n<p>In this Excel podcast we talk about:<\/p>\n<ul>\n<li>The difference between Office 365 subscription and Excel 2019 download version;<\/li>\n<li>The different Office 365 subscription options;<\/li>\n<li>The new Excel features released in Office 365\n<ul>\n<li>Geography &amp; Stock Data Type<\/li>\n<li>Artificial Intelligence with Ideas<\/li>\n<li>Dynamic Arrays: SORT, SORTBY, FILTER, UNIQUE &amp; RANDARRAY<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen\/#Interview_Links\" title=\"Interview Links\">Interview Links<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen\/#Bill_Jelens_New_Books\" title=\"Bill Jelen&#8217;s New Books\">Bill Jelen&#8217;s New Books<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen\/#Connect_with_Me\" title=\"Connect with Me\">Connect with Me<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen\/#Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\" title=\"Listen to the MyExcelOnline Podcast on your favorite platform!\">Listen to the MyExcelOnline Podcast on your favorite platform!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen\/#Free_Resources\" title=\"Free Resources!\">Free Resources!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen\/#Thanks_for_Listening\" title=\"Thanks for Listening!\">Thanks for Listening!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Interview_Links\"><\/span><strong>Interview Links<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/support.office.com\/en-us\/article\/what-s-new-in-excel-2019-for-windows-5a201203-1155-4055-82a5-82bf0994631f\" target=\"_blank\" rel=\"noopener nofollow\">New Excel 2019 Features<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/115-51.html\" target=\"_blank\" rel=\"noopener\">MyExcelOnline Academy Online Course<\/a><\/li>\n<li><a href=\"https:\/\/support.office.com\/en-us\/article\/what-is-office-insider-f4208185-b63a-4b68-9c7a-9a32d2411c16\" target=\"_blank\" rel=\"noopener nofollow\">Microsoft Office 365 Insider vs Monthly Channel<\/a><\/li>\n<li>The new Excel features released in <a href=\"https:\/\/microsoft-us.evyy.net\/c\/454175\/190407\/3327\" target=\"_blank\" rel=\"noopener nofollow\">Office 365<\/a>:<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/6otx12iIh50\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/YJSypQVTDwE\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Artificial Intelligence with Ideas &#8211; VIDEO COMING VERY VERY SOON!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/ATJgGWnS7Kg\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/m-w7fJTudig\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/vy8y4CN-IHY\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/QN8KJmRLilo\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\" style=\"text-align: center;\">\n<\/div>\n<ul>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=D9g-l6NjkIM\" target=\"_blank\" rel=\"noopener nofollow\">Excel Hash Competition<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Bill_Jelens_New_Books\"><\/span><strong>Bill Jelen&#8217;s New Books<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/www.mrexcel.com\/products\/excel-dynamic-arrays-straight-to-the-point\/\" target=\"_blank\" rel=\"noopener nofollow\">Excel Dynamic Arrays Straight To The Point<\/a>\u00a0&#8211; FREE to download up until December 31, 2018!!!<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.mrexcel.com\/products\/excel-dynamic-arrays-straight-to-the-point\/\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"022: New Microsoft Office 365 Excel Features with Mr. Excel Bill Jelen\"  class=\"alignnone wp-image-9622 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/excel-dynamic-arrays-straight-to-the-point.jpg\" alt=\"022: New Microsoft Office 365 Excel Features with Mr. Excel Bill Jelen\" width=\"375\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/excel-dynamic-arrays-straight-to-the-point.jpg 375w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/excel-dynamic-arrays-straight-to-the-point-225x300.jpg 225w\" sizes=\"(max-width: 375px) 100vw, 375px\" \/><\/a><\/p>\n<ul>\n<li><a href=\"https:\/\/amzn.to\/2RJGqrd\" target=\"_blank\" rel=\"noopener nofollow\">Excel 2019 Inside Out<\/a>\u00a0on Amazon<\/li>\n<\/ul>\n<p><a href=\"https:\/\/amzn.to\/2RJGqrd\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"022: New Microsoft Office 365 Excel Features with Mr. Excel Bill Jelen\"  class=\"alignnone wp-image-9624 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/Excel-2019-Inside-Out.jpg\" alt=\"022: New Microsoft Office 365 Excel Features with Mr. Excel Bill Jelen\" width=\"407\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/Excel-2019-Inside-Out.jpg 407w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/Excel-2019-Inside-Out-244x300.jpg 244w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/a><\/p>\n<ul>\n<li><a href=\"https:\/\/www.e-junkie.com\/ecom\/gb.php?cl=211017&amp;c=ib&amp;aff=277028\" target=\"_blank\" rel=\"noopener nofollow\">All of Bill Jelen&#8217;s Excel E-Books on PDF format<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><em>You can subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/em><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Connect_with_Me\"><\/span><strong>Connect with Me<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/www.linkedin.com\/profile\/view?id=145251116&amp;trk=nav_responsive_tab_profile\" target=\"_blank\" rel=\"noopener nofollow\">LinkedIn<\/a><\/li>\n<li><a href=\"https:\/\/www.facebook.com\/pages\/myexcelonlinecom\/264935273678340?sk=timeline\" target=\"_blank\" rel=\"noopener nofollow\">Facebook<\/a><\/li>\n<li><a href=\"https:\/\/twitter.com\/myexcelonline\" target=\"_blank\" rel=\"noopener nofollow\">Twitter<\/a><\/li>\n<\/ul>\n<h2 class=\"text-center\"><span class=\"ez-toc-section\" id=\"Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\"><\/span><strong>Listen to the MyExcelOnline Podcast on your favorite platform!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/itunes.apple.com\/us\/podcast\/my-excel-online-podcast\/id1019164720?l=en\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1057 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/available-on-itunes-logo-300x112.jpg\" alt=\"\" width=\"300\" height=\"112\" title=\"\"><\/a><\/p>\n<p><a href=\"http:\/\/www.stitcher.com\/s?fid=69832&amp;refid=stpr\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1051 size-full aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Stitcher-button.png\" alt=\"\" width=\"300\" height=\"150\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/play.google.com\/music\/m\/I5hjkav2s3dgtv72ovqol3qbgre?t=My_Excel_Online_Podcast&amp;pcampaignid=MKT-na-all-co-pr-mu-pod-16\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1052 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/google-300x116.png\" alt=\"\" width=\"300\" height=\"116\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.iheart.com\/show\/263-my-excel-online-podc\/\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1064 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/iheart-300x80.png\" alt=\"\" width=\"300\" height=\"80\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Free_Resources\"><\/span><strong>Free Resources!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li><strong>Excel Tutorial <\/strong><strong>Blog<\/strong><strong>:<\/strong> Learn all the essential tips to get you up and running and using Excel to its full potential.\u00a0 Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more &gt;&gt;\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/\" target=\"_blank\" rel=\"noopener\"><strong>CLICK HERE TO VIEW<\/strong><\/a><\/li>\n<li><strong>Free Excel Webinars:<\/strong> Learn the power of Pivot Tables and Power Query with our free webinars. <strong>\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener\">CLICK HERE TO VIEW NOW<\/a><\/strong><\/li>\n<\/ol>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1015 size-large\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/Free-Webinars-1024x512.jpg\" alt=\"\" width=\"1024\" height=\"512\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thanks_for_Listening\"><\/span><strong>Thanks for Listening!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Thank you for joining me this week. If you have some feedback that you\u2019d like to share, then please leave a note in the comment section below!<\/p>\n<p>If you enjoyed this episode, please\u00a0<strong>share<\/strong>\u00a0it using the social media buttons you see at the bottom of the post.<\/p>\n<p>Also,\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">please leave an honest review for The MyExcelOnline Podcast on iTunes<\/a>!<\/strong>\u00a0Ratings and reviews\u00a0are\u00a0<strong>extremely<\/strong>\u00a0<strong>helpful<\/strong>\u00a0and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.<\/p>\n<p>If you have any questions you can send me an email to <strong><a href=\"mailto:podcast@myexcelonline.com\" target=\"_blank\" rel=\"noopener\">podcast@myexcelonline.com<\/a><\/strong><\/p>\n<p>Don\u2019t forget to subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listen on Web Browser &gt;&gt; Microsoft recently released some new Excel features\u00a0in their Office 365 subscription license. What better way to talk about these new Excel features than with Bill Jelen from MrExcel.com who has published more than 50 books about Excel! In this Excel podcast we talk about: The difference between Office 365 subscription [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9615,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[334],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9614"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=9614"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9614\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/9615"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=9614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=9614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=9614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}