{"id":17319,"date":"2025-01-17T11:30:58","date_gmt":"2025-01-17T16:30:58","guid":{"rendered":"https:\/\/events.iofm.com\/conference-spring\/session\/updating-your-skillset-12-powerful-new-excel-functions-you-should-be-using\/"},"modified":"2025-03-26T09:40:07","modified_gmt":"2025-03-26T13:40:07","slug":"updating-your-skillset-12-powerful-new-excel-functions-you-should-be-using","status":"publish","type":"session","link":"https:\/\/events.iofm.com\/conference-spring\/session\/updating-your-skillset-12-powerful-new-excel-functions-you-should-be-using\/","title":{"rendered":"Updating your Skillset: 12 Powerful New Excel Functions You Should be Using"},"content":{"rendered":"<p>This session is designed for finance professionals looking to enhance their Excel skills with the latest functions. You&#8217;ll learn how to leverage these powerful tools to streamline your workflow, improve data analysis, and make more informed decisions. By the end of this course, you&#8217;ll be equipped with the knowledge to use these functions effectively in your daily tasks.<\/p>\n<p>Topics Covered<\/p>\n<ul>\n<li><strong>Introduction to the New Dynamic Array Functions: <\/strong>Understanding the revolutionary change in calculations<\/li>\n<li><strong>Data Management Functions: <\/strong>Organizing, cleaning, and managing data with new dynamic array functions<\/li>\n<li><strong>Advanced Lookup Functions: <\/strong>Replacing VLOOKUP, INDEX, and MATCH with a new generation of tools<\/li>\n<li><strong>Understanding LAMBDA: <\/strong>Custom function development<\/li>\n<\/ul>\n","protected":false},"excerpt":{"raw":"This session is designed for finance professionals looking to enhance their Excel skills with the latest functions. You'll learn how to leverage these powerful tools to streamline your workflow, improve...","rendered":"<p>This session is designed for finance professionals looking to enhance their Excel skills with the latest functions. You&#8217;ll learn how to leverage these powerful tools to streamline your workflow, improve&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","session_category":[134,75],"class_list":["post-17319","session","type-session","status-publish","hentry","session_category-main-agenda","session_category-tuesday-2025"],"thumbnail":[],"metadata":{"session_id":["a3d9fb62-f349-4db2-b6b5-30f035c32636"],"session_speakers":[17315],"session_topics":[],"session_date":["2025-05-13 00:00"],"session_start":["2025-05-13 14:10"],"session_end":["2025-05-13 15:00"],"session_updated_at":[null],"session_display_priority":["5"],"session_weblink":[null],"session_sponsored_by":[null],"_eael_post_view_count":["681"],"session_room_number":["Grand Caribbean 3-4"],"rank_math_internal_links_processed":["1"],"_session_board_event_id":["5937"],"_elementor_page_assets":["a:0:{}"]},"_links":{"self":[{"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session\/17319","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=17319"}],"version-history":[{"count":0,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session\/17319\/revisions"}],"wp:attachment":[{"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/media?parent=17319"}],"wp:term":[{"taxonomy":"session_category","embeddable":true,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session_category?post=17319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}