{"id":19433,"date":"2026-01-15T08:50:52","date_gmt":"2026-01-15T13:50:52","guid":{"rendered":"https:\/\/events.iofm.com\/conference-spring\/session\/modern-excel-new-microsoft-365-functions-and-ai-integrations\/"},"modified":"2026-04-30T07:37:00","modified_gmt":"2026-04-30T11:37:00","slug":"modern-excel-new-microsoft-365-functions-and-ai-integrations","status":"publish","type":"session","link":"https:\/\/events.iofm.com\/conference-spring\/session\/modern-excel-new-microsoft-365-functions-and-ai-integrations\/","title":{"rendered":"Modern Excel: New Microsoft 365 Functions and AI Integrations"},"content":{"rendered":"<p>Discover the latest updates to Excel &#8211; the new dynamic array functions that replace everyday features like VLOOKUP and PivotTables included. Additionally, find new ways for Copilot to accelerate analysis and decision-making. This session will show you dozens of new features you can use tomorrow.<\/p>\n<p><strong>Topics include:<\/strong><\/p>\n<ul>\n<li>Leveraging new Excel functions for text manipulation<\/li>\n<li>Replacing VLOOKUP and INDEX and MATCH for everyday workbooks<\/li>\n<li>Designing custom formulas with LAMBDA<\/li>\n<li>Using Copilot for AI insights in seconds<\/li>\n<\/ul>\n","protected":false},"excerpt":{"raw":"Discover the latest updates to Excel - the new dynamic array functions that replace everyday features like VLOOKUP and PivotTables included. Additionally, find new ways for Copilot to accelerate analysis...","rendered":"<p>Discover the latest updates to Excel &#8211; the new dynamic array functions that replace everyday features like VLOOKUP and PivotTables included. Additionally, find new ways for Copilot to accelerate analysis&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","session_category":[141,128,45,206,204,134,145,210,138],"class_list":["post-19433","session","type-session","status-publish","hentry","session_category-141","session_category-ai","session_category-digital-transformation","session_category-general-session","session_category-leadership-career-development-2","session_category-main-agenda","session_category-process-optimization","session_category-specialist","session_category-tuesday-2026"],"thumbnail":[],"metadata":{"session_id":["62286205-ef60-40de-8a4a-887f063910d2"],"session_speakers":[19078],"session_topics":[],"session_date":["2026-05-12 00:00"],"session_start":["2026-05-12 16:05"],"session_end":["2026-05-12 16:55"],"session_updated_at":["2026-04-30T11:35:01.829Z"],"session_display_priority":[null],"session_weblink":[null],"session_sponsored_by":[null],"_eael_post_view_count":["184"],"session_room_number":["Grand Caribbean 6"],"rank_math_internal_links_processed":["1"],"_elementor_page_assets":["a:0:{}"]},"_links":{"self":[{"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session\/19433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session"}],"about":[{"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/types\/session"}],"author":[{"embeddable":true,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/comments?post=19433"}],"version-history":[{"count":1,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session\/19433\/revisions"}],"predecessor-version":[{"id":20050,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session\/19433\/revisions\/20050"}],"wp:attachment":[{"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/media?parent=19433"}],"wp:term":[{"taxonomy":"session_category","embeddable":true,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session_category?post=19433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}