{"id":19434,"date":"2026-01-15T08:54:26","date_gmt":"2026-01-15T13:54:26","guid":{"rendered":"https:\/\/events.iofm.com\/conference-spring\/session\/building-dynamic-reports-with-microsoft-excel\/"},"modified":"2026-04-09T11:28:57","modified_gmt":"2026-04-09T15:28:57","slug":"building-dynamic-reports-with-microsoft-excel","status":"publish","type":"session","link":"https:\/\/events.iofm.com\/conference-spring\/session\/building-dynamic-reports-with-microsoft-excel\/","title":{"rendered":"Building Dynamic Reports with Microsoft Excel"},"content":{"rendered":"<p>With the modern Excel power tools, you can transform raw data into insightful and interactive reports. Then, when new data comes in, the reports can update themselves with a simple button-press. In this session, we&#8217;ll leverage tools like Power Query and Power Pivot to build dashboards you can use to make data-driven decisions.<\/p>\n<p>Topics include:<\/p>\n<ul>\n<li>Importing and cleaning data with Power query<\/li>\n<li>Transforming and shaping data sets<\/li>\n<li>Designing dynamic PivotTables for flexible reports<\/li>\n<li>Building interactivity with slicers and timelines<\/li>\n<\/ul>\n","protected":false},"excerpt":{"raw":"With the modern Excel power tools, you can transform raw data into insightful and interactive reports. Then, when new data comes in, the reports can update themselves with a simple...","rendered":"<p>With the modern Excel power tools, you can transform raw data into insightful and interactive reports. Then, when new data comes in, the reports can update themselves with a simple&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","session_category":[141,45,76,66,134,145,143,138],"class_list":["post-19434","session","type-session","status-publish","hentry","session_category-141","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":["c298fa6b-7f71-4c9c-b6e2-9429ced25102"],"session_speakers":[19078],"session_topics":[],"session_date":["2026-05-12 00:00"],"session_start":["2026-05-12 15:00"],"session_end":["2026-05-12 15:50"],"session_updated_at":["2026-03-05T01:39:30.800Z"],"session_display_priority":[null],"session_weblink":[null],"session_sponsored_by":[null],"_eael_post_view_count":["147"],"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\/19434","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=19434"}],"version-history":[{"count":1,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session\/19434\/revisions"}],"predecessor-version":[{"id":20048,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session\/19434\/revisions\/20048"}],"wp:attachment":[{"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/media?parent=19434"}],"wp:term":[{"taxonomy":"session_category","embeddable":true,"href":"https:\/\/events.iofm.com\/conference-spring\/wp-json\/wp\/v2\/session_category?post=19434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}