{"id":20775,"date":"2026-04-02T15:59:39","date_gmt":"2026-04-02T19:59:39","guid":{"rendered":"https:\/\/events.iofm.com\/conference-fall\/session\/pm-workshop-neil\/"},"modified":"2026-05-28T15:59:39","modified_gmt":"2026-05-28T19:59:39","slug":"pm-workshop-neil","status":"publish","type":"session","link":"https:\/\/events.iofm.com\/conference-fall\/session\/pm-workshop-neil\/","title":{"rendered":"Microsoft Excel: Modern Skill Refresh"},"content":{"rendered":"<p>In the last decade, Microsoft has seen the introduction of several new tools \u2013 not just individual buttons, but entire systems for working. If you haven\u2019t gone on a deep-dive with these features, you\u2019re being left behind. This session will cover tools like Power Query and Power Pivot, as well as many of the fifty-plus new functions introduced this decade.<\/p>\n<p>Topics include:<\/p>\n<ul>\n<li>Automating data imports and cleaning with Power Query<\/li>\n<li>Building Pivot Tables from multiple data tables with Power Pivot<\/li>\n<li>Leveraging new dynamic array functions to solve complex data issues<\/li>\n<li>Creating online scripts for automation in cloud-based spreadsheets<\/li>\n<\/ul>\n<p>($) Additional Registration is Required\u00a0<\/p>\n","protected":false},"excerpt":{"raw":"In the last decade, Microsoft has seen the introduction of several new tools \u2013 not just individual buttons, but entire systems for working. If you haven\u2019t gone on a deep-dive...","rendered":"<p>In the last decade, Microsoft has seen the introduction of several new tools \u2013 not just individual buttons, but entire systems for working. If you haven\u2019t gone on a deep-dive&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","session_category":[219,216,169,220,234,73],"class_list":["post-20775","session","type-session","status-publish","hentry","session_category-219","session_category-leadership-career-development-2","session_category-main-agenda","session_category-monday-2026","session_category-specialist","session_category-workshop-additional-registration-required"],"thumbnail":[],"metadata":{"rank_math_internal_links_processed":["1"],"session_id":["e6d254c8-6a22-4c56-95f5-5deb30ad335b"],"session_topics":[],"session_date":["2026-11-02 00:00"],"session_start":["2026-11-02 13:30"],"session_end":["2026-11-02 16:30"],"session_updated_at":["2026-05-28T18:41:56.110Z"],"session_display_priority":["2"],"session_weblink":[null],"session_sponsored_by":[null],"_eael_post_view_count":["136"],"session_speakers":[16185],"_session_board_event_id":["6107"],"session_moderators":[],"session_chairpersons":[],"_elementor_page_assets":["a:0:{}"]},"_links":{"self":[{"href":"https:\/\/events.iofm.com\/conference-fall\/wp-json\/wp\/v2\/session\/20775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/events.iofm.com\/conference-fall\/wp-json\/wp\/v2\/session"}],"about":[{"href":"https:\/\/events.iofm.com\/conference-fall\/wp-json\/wp\/v2\/types\/session"}],"author":[{"embeddable":true,"href":"https:\/\/events.iofm.com\/conference-fall\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/events.iofm.com\/conference-fall\/wp-json\/wp\/v2\/comments?post=20775"}],"wp:attachment":[{"href":"https:\/\/events.iofm.com\/conference-fall\/wp-json\/wp\/v2\/media?parent=20775"}],"wp:term":[{"taxonomy":"session_category","embeddable":true,"href":"https:\/\/events.iofm.com\/conference-fall\/wp-json\/wp\/v2\/session_category?post=20775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}