{"id":291,"date":"2017-02-24T09:07:06","date_gmt":"2017-02-24T09:07:06","guid":{"rendered":"http:\/\/themes.themegoods.com\/grandconference\/demo\/?page_id=291"},"modified":"2023-08-01T15:06:57","modified_gmt":"2023-08-01T15:06:57","slug":"agenda","status":"publish","type":"page","link":"https:\/\/2021.globalexcelsummit.com\/agenda\/","title":{"rendered":"Agenda"},"content":{"rendered":"<div  class=\"ppb_session_filterable one withsmallpadding \" >\n<div class=\"standard_wrapper\">\n<div id=\"1690902417435750452\">\n<ul class=\"scheduleday_wrapper themeborder one_half \">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">Main Stage (Day 1)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">Recordings available now<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_724\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2021\/02\/extra-speaker-2-150x150.png\" alt=\"Kaycee Reineke\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">09:00&nbsp;&#8211;&nbsp;10:00<\/div>\n<div class=\"session_title\">\n<h6>Opening Keynote by Microsoft<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/kaycee-reineke\/\">Kaycee Reineke<\/a><\/strong>&nbsp;Sr. Product Manager, Microsoft Excel,&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/chris-gross\/\">Chris Gross<\/a><\/strong>&nbsp;Sr. Product Manager, Microsoft Excel,&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/vaibhavi-phadnis\/\">Vaibhavi Phadnis<\/a><\/strong>&nbsp;Product Manager, Microsoft Excel<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_724\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">More details coming soon.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_272\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Randy-Austin-NEW-Pic-150x150.png\" alt=\"Randy Austin\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">11:00&nbsp;&#8211;&nbsp;11:45<\/div>\n<div class=\"session_title\">\n<h6>Finding Your Niche In Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/randy-austin\/\">Randy Austin<\/a><\/strong>&nbsp;Founder of Excel For Freelancers | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_272\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">In this session, Randy will show you how to step out of the box and into the spotlight, letting your unique Excel skills shine in a crowded marketplace.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_240\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Untitled-design-12-150x150.png\" alt=\"Leila Gharani\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">10:10&nbsp;&#8211;&nbsp;10:55<\/div>\n<div class=\"session_title\">\n<h6>How to create an online course that sells?<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/leila-gharani\/\">Leila Gharani<\/a><\/strong>&nbsp;Founder of XelPlus | 3x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_240\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">The online course market is booming. Both in demand and supply. You can spend months creating a course that will get buried in the noise. How can you differentiate yourself in a crowded market and create a course that sells? In this session Leila shares her course creation formula for success.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_271\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Michael-Olafusi-NEW-Pic-150x150.png\" alt=\"Michael Olafusi\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">11:50&nbsp;&#8211;&nbsp;12:25<\/div>\n<div class=\"session_title\">\n<h6>Earning High Consulting Income In Low Income Countries<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/michael-olafusi\/\">Michael Olafusi<\/a><\/strong>&nbsp;Founder of UrBizEdge | 6x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_271\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">In this session, Michael will share tested practical ways to go from a struggling consultant to a highly sought-after high fees\/ income consultant especially in low income countries. He will also touch on practical tips for scaling, pricing, marketing, product\/ service development and positioning.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_270\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">12:30&nbsp;&#8211;&nbsp;13:30<\/div>\n<div class=\"session_title\">\n<h6>Lunch Time!<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_269\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Oz-du-Solel-NEW-Pic-150x150.png\" alt=\"Oz du Soleil\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">13:30&nbsp;&#8211;&nbsp;14:15<\/div>\n<div class=\"session_title\">\n<h6>Taking Risks As A Content Creator<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/oz-du-soleil\/\">Oz du Soleil<\/a><\/strong>&nbsp;Founder of Excel on Fire | 6x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_269\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">On platforms like YouTube there is endless advice for growing a channel, but not so much on creativity, and the risks of stretching out to be creative. Oz du Soleil produces Excel tutorials for the YouTube channel Excel on Fire, known for its brash, overly dramatic, adventurous style. Oz will share some of the behind-the-scenes risks and rewards for going against common wisdom. He will also share a bit about the path that lead up to a call from LinkedIn Learning (formerly Lynda.com) and their 2-year relationship.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_268\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Gasper-Kamensek-NEW-Pic-150x150.png\" alt=\"Ga\u0161per Kamen\u0161ek\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:20&nbsp;&#8211;&nbsp;15:05<\/div>\n<div class=\"session_title\">\n<h6>Why Power Query Joins are even better than Xlookup?<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/gasper-kamensek\/\">Ga\u0161per Kamen\u0161ek<\/a><\/strong>&nbsp;Founder of Excel Olympics | 4x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_268\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Xlookup is the new kid on the block and a much-needed alternative to Vlookup. And whereas it will reign supreme among the functions, there are still a lot of things that Power Query Joins can do, that Xlookup just can\u2019t. This session will cover all the Join types with real-life examples that should make it clear, that Power Query Joins should be a vital part of every data analysts toolbelt.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_266\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Robin-Waite-NEW-Pic-150x150.png\" alt=\"Robin Waite\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">15:10&nbsp;&#8211;&nbsp;15:55<\/div>\n<div class=\"session_title\">\n<h6>The Magical Marketing Mystery Machine<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/robin-waite\/\">Robin Waite<\/a><\/strong>&nbsp;Founder of Fearless Business,  Business Coach, Book Author<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_266\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Who wants the ultimate quick win in marketing? Everyone, I bet. Imagine this though; Lewis Hamilton wasn\u2019t born in a car, he had to learn how to drive. As with marketing, you\u2019ve got to learn how to do it FOR YOUR BUSINESS! Here it is, the answer you\u2019re all waiting for. Marketing, or the art of creating brand awareness, is determined by the value you give away up front, for free.<\/p>\n<p>Websites, books, brochures, flyers, advice, speaking, podcasts, ads, pdf downloads etc \u2026there it is, the answer \ud83d\udc46\ud83d\udc46\ud83d\udc46<\/p>\n<p>Ok. Obvious. Now the difficult bit.<\/p>\n<p>You must find 2 or 3 things\/activities which work for your business. This is YOUR marketing mix. It is unique to YOU and YOU\u2019VE got to \u201clearn\u201d it. Robin will debunk all of the common marketing myths and show you all how to market your business moving forward, avoiding the common pitfalls and negative backlash along the way. This Marketing Mystery will be solved.<\/p><\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_265\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Celia-Alves-NEW-Pic-150x150.png\" alt=\"Celia Alves\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:00&nbsp;&#8211;&nbsp;16:40<\/div>\n<div class=\"session_title\">\n<h6>Converting A Collection Of CSV Reports Into An Efficient Business Application With Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/celia-alves\/\">Celia Alves<\/a><\/strong>&nbsp;Founder of Solve and Excel | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_265\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">\u201cCan you do this in Excel?\u201d is a question I often get from clients. Usually, they are looking to reduce the time it takes them to perform repetitive tasks, execute calculations fast, generate accurate and professional-looking documents and a way to get insights from their data on the fly. In this session will show how to bring together the different features, tools and capabilities of Excel to develop a business tool that addresses all the requests mentioned above (including importing data with Power Query, creating a Data Model with Power Pivot and DAX and automating procedures with VBA.)<br \/>\nOne of Excel\u2019s strengths is its flexibility to allow the development of custom solutions. Building and implementing a custom business tool can bring many challenges and rewards to both the developer and the client. Dealing with real-life challenges offers the developer an opportunity to expand knowledge and skills and the business owner a chance to deepen their understanding of their business.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_267\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:40&nbsp;&#8211;&nbsp;16:50<\/div>\n<div class=\"session_title\">\n<h6>Coffee Break<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_569\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Bob-Umlas-NEW-Pic-150x150.png\" alt=\"Bob Umlas\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:50&nbsp;&#8211;&nbsp;17:30<\/div>\n<div class=\"session_title\">\n<h6>Tips &#038; Tricks by Bob Umlas<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/bob-umlas\/\">Bob Umlas<\/a><\/strong>&nbsp;25x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_569\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">25x Microsoft MVP<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_765\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2021\/02\/Excel-data-visualization-Analytics-14-150x150.png\" alt=\"Samuel Arthur\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">17:35&nbsp;&#8211;&nbsp;18:30<\/div>\n<div class=\"session_title\">\n<h6>Product Demos<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/samuel-arthur\/\">Samuel Arthur<\/a><\/strong>&nbsp;Co-Founder &#038; CTO, Workscope,&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/joel-steendam\/\">Joel Steendam<\/a><\/strong>&nbsp;Marketing Executive,&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/john-michaloudis\/\">John Michaloudis<\/a><\/strong>&nbsp;Owner &#038; Chief Inspirational Officer<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_765\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">\u2022 PerfectXL demo by Joel Steendam<br \/>\n\u2022 MyExcelOnline.com Academy demo by John Michaloudis<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<ul class=\"scheduleday_wrapper themeborder one_half last\">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">Main Stage (Day 2)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">Recordings available now<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_734\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Chandoo-NEW-Pic-150x150.png\" alt=\"Chandoo\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">09:10&nbsp;&#8211;&nbsp;10:00<\/div>\n<div class=\"session_title\">\n<h6>How I created a million dollar Excel product? &#8211; lessons on design, marketing and customer service<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/chandoo\/\">Chandoo<\/a><\/strong>&nbsp;Founder of Chandoo.org | 12x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_734\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Come and learn how Chandoo created a million dollar software with Excel. How he designed it, marketed it and how he built the sales funnel. What worked, what failed and how you can apply the ideas for your own online (ad)ventures.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_746\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Danielle-Stein-Fairhurst-NEW-Pic-150x150.png\" alt=\"Danielle Stein Fairhurst\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">10:10&nbsp;&#8211;&nbsp;10:55<\/div>\n<div class=\"session_title\">\n<h6>Building the Excel Modelling Meetup Community<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/danielle-stein-fairhurst\/\">Danielle Stein Fairhurst<\/a><\/strong>&nbsp;Principal of Plum Solutions, Australia<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_746\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">In today\u2019s online world where we can access information instantly and learn how to do just about anything via pre-recorded tutorials and videos, why is there still such demand for live events? Since 2015, Danielle Stein Fairhurst has been running regular Financial Modelling in Excel Meetups in various locations in Australia. In March 2020, the meetups switched online and since then, she has run over 40 live virtual meetup events with various guest speakers and more than 8,000 participants. Come and hear the good, the bad and the ugly on how she leveraged her network to build a virtual \/ face to face community as well as a high-profile global online presence.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_750\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Liam-Bastick-NEW-Pic-150x150.png\" alt=\"Liam Bastick\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">11:00&nbsp;&#8211;&nbsp;11:45<\/div>\n<div class=\"session_title\">\n<h6>Excel Meets Programming (LET &#038; LAMBDA)<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/liam-bastick\/\">Liam Bastick<\/a><\/strong>&nbsp;Founder of SumProduct | 10x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_750\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Two new functions have entered the Excel 365 world: LET and LAMBDA.  This session looks at what these functions do and how they may be used both separately and collaboratively, to perform tasks that could never be performed before using standard Excel formulae.  Speeding up calculations, removing the need for user defined functions and even employing recursion are all now possible.  The future of Excel is now.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_740\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Tony-De-Jonker-NEW-Pic-150x150.png\" alt=\"Tony De Jonker\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">11:50&nbsp;&#8211;&nbsp;12:30<\/div>\n<div class=\"session_title\">\n<h6>Building a dynamic Cash Flow Forecast<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/tony-de-jonker\/\">Tony De Jonker<\/a><\/strong>&nbsp;Principal of De Jonker Consultancy | 6x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_740\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">During this session, Tony will provide you with his expertise on:<br \/>\n\u2022 the building blocks of setting up a dynamic cash flow forecast model<br \/>\n\u2022 how to create a dynamic timeline to cater for variable time views<br \/>\n\u2022 how to link sources such as AR &#038; AP downloads<br \/>\n\u2022 to create a custom Cash Flow Forecast Report<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_248\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">12:30&nbsp;&#8211;&nbsp;13:30<\/div>\n<div class=\"session_title\">\n<h6>Lunch Time!<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_742\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Boriana-Petrova-NEW-Pic-150x150.png\" alt=\"Boriana Petrova\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">13:30&nbsp;&#8211;&nbsp;14:15<\/div>\n<div class=\"session_title\">\n<h6>Useful Business Tips &#038; Tricks in Modern Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/boriana-petrova\/\">Boriana Petrova<\/a><\/strong>&nbsp;MOS Master, MCITP, MCTS | 5x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_744\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Jordan-Goldmeier-NEW-Pic-150x150.png\" alt=\"Jordan Goldmeier\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:20&nbsp;&#8211;&nbsp;15:05<\/div>\n<div class=\"session_title\">\n<h6>Strengthening our signal: how to turn your Excel passion into a business?<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/jordan-goldmeier\/\">Jordan Goldmeier<\/a><\/strong>&nbsp;Data Science Leader | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_744\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Excel is an old product but the challenges facing today\u2019s Excel freelancers are new. The way companies are using Excel has changed, and the old corporate workshop model is slowly fading. How do you reach your potential customer? And can an Excel freelancer actually make money in today\u2019s environment?<\/p>\n<p>For the last five years, Jordan has worked tirelessly to build Excel.TV into a thriving online community. He has learned and failed a lot. For the first time, he will be pulling back the curtain on his journey and show you what he has learned. Come with questions!<\/p><\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_736\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Boris-Hristov-NEW-Pic-150x150.png\" alt=\"Boris Hristov\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">15:10&nbsp;&#8211;&nbsp;15:55<\/div>\n<div class=\"session_title\">\n<h6>Create in Excel. Present in PowerPoint. Effectively.<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/boris-hristov\/\">Boris Hristov<\/a><\/strong>&nbsp;Founder of 356labs | 6x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_736\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Do you happen to create excel charts that you need to present as part of a PowerPoint presentation? What if I tell you that most data visualization are not as effective as they could be when used in a presentation context? In this session you will learn how to tune your charts in order to convey your message across ef\ufb01ciently, effectively and effortlessly. This is a demo-only session so get ready to have some fun!<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_748\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Sumit-Bansal-NEW-Pic-150x150.png\" alt=\"Sumit Bansal\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:00&nbsp;&#8211;&nbsp;16:40<\/div>\n<div class=\"session_title\">\n<h6>How to monetize your Excel Skills online?<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/sumit-bansal\/\">Sumit Bansal<\/a><\/strong>&nbsp;Founder of TrumpExcel.com | 7x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_748\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">In this session, you will learn how to turn your Microsoft Excel skills into an online pro\ufb01t. Sumit Bansal will share tested tips, tricks and methods for achieving \ufb01nancial freedom through Excel.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_235\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:40&nbsp;&#8211;&nbsp;16:50<\/div>\n<div class=\"session_title\">\n<h6>Coffee Break<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_738\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Cristiano-Galva-NEW-Pic-150x150.png\" alt=\"Cristiano Galv\u00e3o\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:50&nbsp;&#8211;&nbsp;17:30<\/div>\n<div class=\"session_title\">\n<h6>Data Analysis with Excel in Brazil and Abroad<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/cristiano-galvao\/\">Cristiano Galv\u00e3o<\/a><\/strong>&nbsp;Founder of GENECSIS, Excel Turbo &#038; Excel Weekend | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_738\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Based on experience with consulting services and training in Brazil and other countries, Cristiano will discuss different techniques available within Excel for analysing data. In addition, he will provide his insight on how global Excel practitioners have been evolving their use of the tool in order to achieve the desired valuable insight for their businesses.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_767\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2021\/02\/Excel-data-visualization-Analytics-12-150x150.png\" alt=\"Donald MacCormick\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">17:35&nbsp;&#8211;&nbsp;18:30<\/div>\n<div class=\"session_title\">\n<h6>Product Demos<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/donald-maccormick\/\">Donald MacCormick<\/a><\/strong>&nbsp;Chief Strategy Officer, Squirrel365,&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/tatiana-ufimtceva\/\">Tatiana Ufimtceva<\/a><\/strong>&nbsp;Founder and CEO, KeySkillset,&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/aydin-aliyev\/\">Aydin Aliyev<\/a><\/strong>&nbsp;Founder of \u201cXL Ribbon\u201d; Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_767\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">\u2022 &#8220;XLRibbon&#8221; Demo by Aydin Aliyev, Microsoft MVP and Founder of XLRibbon<br \/>\n\u2022 &#8220;Bring your spreadsheets to life with Squirrel&#8221; by Donald MacCormick, Chief Strategy Officer, Squirrel365<br \/>\n\u2022 &#8220;Increase of Excel Efficiency and Financial Modeling Speed Through Gamification&#8221; by Tatiana Ufimtceva, Founder and CEO, keySkillset<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Main Stage<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<ul class=\"scheduleday_wrapper themeborder one_half \">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">Masterclasses (Day 3)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">Recordings available now<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_2896\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Celia-Alves-NEW-Pic-150x150.png\" alt=\"Celia Alves\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:00&nbsp;&#8211;&nbsp;17:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>(NEW) Power Query Fundamentals in Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/celia-alves\/\">Celia Alves<\/a><\/strong>&nbsp;Founder of Solve and Excel | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_2896\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Do you spend too much time re-shaping your data (e.g. splitting and merging columns, adding calculating columns, sorting and filtering, summarising your data) to create additional reports, pivot tables, or charts? This Power Query in Excel Masterclass will equip you with what you need to know in order to automate your tedious, repetitive and time-consuming tasks. Power Query can help you automate all sorts of different data cleansing and analysis tasks without writing code. It is easy to learn, and we can guarantee it will be a one-way-and-not-going-back journey. From day one, you will be able to make use of what you learn in this Masterclass by applying it to your every day work&#8217;s specific requirements. This Masterclass will take place virtually over 2 days: 8 February 2020 | 18:00-21:30 GMT (Part 1) &#038; 9 February 2020 | 18:00-21:30 GMT (Part 2)<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_2878\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/10\/Untitled-design-22-150x150.png\" alt=\"Ken Puls\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">18:00&nbsp;&#8211;&nbsp;21:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>(NEW) Introduction to Dimensional Modeling for the Excel Pro<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/ken-puls\/\">Ken Puls<\/a><\/strong>&nbsp;President of Excelguru Consulting | 14x Micosoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_2878\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">The classic Excel PivotTable did a great job of letting us quickly pivot and slice data for years.  There was a ton of logic built into the tool in order to make it easy for end users, but that ease of use had a cost: it didn\u2019t scale to multiple data source tables.  And worse, it actually kept you from learning the terms to scale your own knowledge.<br \/>\nAt the core of every good Power Pivot or Power BI solution is the Data Model.  But do you really know how to work with it properly?  What shape your tables should have?  When you should split tables up, when you should flatten them, and how to manipulate the data on the fly to do so?<br \/>\nThis is an exciting course, as it pairs two of Excel\u2019s most powerful features (Power Query and Power Pivot) together in one place, using each for what they were designed to do.  You\u2019ll leave armed with not only the experience, but handy reference cards to apply these techniques to your own data, and to determine \u201cIs this a Power Query job, or a DAX job?\u201d<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_730\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Danielle-Stein-Fairhurst-NEW-Pic-150x150.png\" alt=\"Danielle Stein Fairhurst\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">18:00&nbsp;&#8211;&nbsp;21:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>Building the Financial Model Dashboard<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/danielle-stein-fairhurst\/\">Danielle Stein Fairhurst<\/a><\/strong>&nbsp;Principal of Plum Solutions, Australia<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_730\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Summarise the outputs of your financial model using standard Excel skills into a concise, dynamic and visually appealing one-page dashboard report which can effectively communicate the results of your model to others at a glance.<\/p>\n<p>This Masterclass will take place virtually over 2 days: 8 February 2020 | 18:00-21:30 GMT (Part 1) &#038; 9 February 2020 | 18:00-21:30 GMT (Part 2)<\/p><\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_728\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Boris-Hristov-NEW-Pic-150x150.png\" alt=\"Boris Hristov\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">09:00&nbsp;&#8211;&nbsp;16:30 | 8 February<\/div>\n<div class=\"session_title\">\n<h6>Story, Design, Delivery: Next Level Business Presentations.<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/boris-hristov\/\">Boris Hristov<\/a><\/strong>&nbsp;Founder of 356labs | 6x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_728\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Get ready for something different, and innovative. Learn the difference that sits behind those presentations that keep you on the edge of your seat, and those that send you right to sleep. Get ready to go behind the scenes and understand what makes top presentations out there so successful. Be ready for exercises and colours that will enrich your mind. We will cover each component of truly effective presentations while working on them \u2013 story, design, and delivery.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Masterclass Room 2<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_726\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Chandoo-NEW-Pic-150x150.png\" alt=\"Chandoo\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">18:00&nbsp;&#8211;&nbsp;21:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>Advanced &#038; Interactive Charts in Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/chandoo\/\">Chandoo<\/a><\/strong>&nbsp;Founder of Chandoo.org | 12x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_726\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Create beautiful, striking and insightful business dashboards &#038; charts in Excel with this 2 half day masterclass. Use powerful Excel features like slicers, maps, forecasting, formulas and tables to enhance your regular business charts. Understand the process for making executive dashboards to tell complete story in one picture.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_599\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Randy-Austin-NEW-Pic-150x150.png\" alt=\"Randy Austin\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">09:00&nbsp;&#8211;&nbsp;13:00 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>Creating Your Wealth &#038; Success With Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/randy-austin\/\">Randy Austin<\/a><\/strong>&nbsp;Founder of Excel For Freelancers | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_599\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">In this masterclass Randy Austin will teach you how to leverage your Excel skills to create incredible value for the marketplace and use those skills to gain the freedom, wealth &#038; success you desire. You will take a deep dive into the fundamentals of creating real solutions for real businesses that will enable you to create recurring &#038; passive income for life. This Masterclass will take place virtually over 2 days: 8 February 2020 | 09:00-13:00 GMT (Part 1) &#038; 9 February 2020 | 09:00-13:00 GMT (Part 2)<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<ul class=\"scheduleday_wrapper themeborder one_half last\">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">Masterclasses (Day 4)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">Recordings available now<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_2896\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Celia-Alves-NEW-Pic-150x150.png\" alt=\"Celia Alves\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:00&nbsp;&#8211;&nbsp;17:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>(NEW) Power Query Fundamentals in Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/celia-alves\/\">Celia Alves<\/a><\/strong>&nbsp;Founder of Solve and Excel | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_2896\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Do you spend too much time re-shaping your data (e.g. splitting and merging columns, adding calculating columns, sorting and filtering, summarising your data) to create additional reports, pivot tables, or charts? This Power Query in Excel Masterclass will equip you with what you need to know in order to automate your tedious, repetitive and time-consuming tasks. Power Query can help you automate all sorts of different data cleansing and analysis tasks without writing code. It is easy to learn, and we can guarantee it will be a one-way-and-not-going-back journey. From day one, you will be able to make use of what you learn in this Masterclass by applying it to your every day work&#8217;s specific requirements. This Masterclass will take place virtually over 2 days: 8 February 2020 | 18:00-21:30 GMT (Part 1) &#038; 9 February 2020 | 18:00-21:30 GMT (Part 2)<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_2878\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/10\/Untitled-design-22-150x150.png\" alt=\"Ken Puls\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">18:00&nbsp;&#8211;&nbsp;21:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>(NEW) Introduction to Dimensional Modeling for the Excel Pro<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/ken-puls\/\">Ken Puls<\/a><\/strong>&nbsp;President of Excelguru Consulting | 14x Micosoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_2878\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">The classic Excel PivotTable did a great job of letting us quickly pivot and slice data for years.  There was a ton of logic built into the tool in order to make it easy for end users, but that ease of use had a cost: it didn\u2019t scale to multiple data source tables.  And worse, it actually kept you from learning the terms to scale your own knowledge.<br \/>\nAt the core of every good Power Pivot or Power BI solution is the Data Model.  But do you really know how to work with it properly?  What shape your tables should have?  When you should split tables up, when you should flatten them, and how to manipulate the data on the fly to do so?<br \/>\nThis is an exciting course, as it pairs two of Excel\u2019s most powerful features (Power Query and Power Pivot) together in one place, using each for what they were designed to do.  You\u2019ll leave armed with not only the experience, but handy reference cards to apply these techniques to your own data, and to determine \u201cIs this a Power Query job, or a DAX job?\u201d<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_732\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Robin-Waite-NEW-Pic-150x150.png\" alt=\"Robin Waite\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">09:00&nbsp;&#8211;&nbsp;16:30 | 9 February<\/div>\n<div class=\"session_title\">\n<h6>&#8220;Productising a Service\u201d \u2013 Product Architecture, Pricing and Sales<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/robin-waite\/\">Robin Waite<\/a><\/strong>&nbsp;Founder of Fearless Business,  Business Coach, Book Author<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_732\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Business owners commonly sell a single core product and then, after seeing the price, wonder why potential customers turn around and walk out of the door before they\u2019ve even had a chance to engage in a conversation.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Masterclass Room 3<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_730\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Danielle-Stein-Fairhurst-NEW-Pic-150x150.png\" alt=\"Danielle Stein Fairhurst\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">18:00&nbsp;&#8211;&nbsp;21:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>Building the Financial Model Dashboard<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/danielle-stein-fairhurst\/\">Danielle Stein Fairhurst<\/a><\/strong>&nbsp;Principal of Plum Solutions, Australia<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_730\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Summarise the outputs of your financial model using standard Excel skills into a concise, dynamic and visually appealing one-page dashboard report which can effectively communicate the results of your model to others at a glance.<\/p>\n<p>This Masterclass will take place virtually over 2 days: 8 February 2020 | 18:00-21:30 GMT (Part 1) &#038; 9 February 2020 | 18:00-21:30 GMT (Part 2)<\/p><\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_726\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Chandoo-NEW-Pic-150x150.png\" alt=\"Chandoo\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">18:00&nbsp;&#8211;&nbsp;21:30 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>Advanced &#038; Interactive Charts in Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/chandoo\/\">Chandoo<\/a><\/strong>&nbsp;Founder of Chandoo.org | 12x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_726\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Create beautiful, striking and insightful business dashboards &#038; charts in Excel with this 2 half day masterclass. Use powerful Excel features like slicers, maps, forecasting, formulas and tables to enhance your regular business charts. Understand the process for making executive dashboards to tell complete story in one picture.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_607\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Gasper-Kamensek-NEW-Pic-150x150.png\" alt=\"Ga\u0161per Kamen\u0161ek\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">09:00&nbsp;&#8211;&nbsp;16:30 | 9 February<\/div>\n<div class=\"session_title\">\n<h6>THE Power Pivot data model<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/gasper-kamensek\/\">Ga\u0161per Kamen\u0161ek<\/a><\/strong>&nbsp;Founder of Excel Olympics | 4x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_607\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">This MasterClass could just as well be called optimization techniques for data modeling in Excel. In this whole day MasterClass we will use Power Query and Power Pivot to build a light, agile, fast and easily manageable data model. In other words, we will create THE data model. This MasterClass should give you clear guidelines for data modeling that you will be able to use on each model you will build in Excel.<\/p>\n<p>This Masterclass is sold out.<\/p><\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Masterclass Room 1<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_599\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2017\/02\/Randy-Austin-NEW-Pic-150x150.png\" alt=\"Randy Austin\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">09:00&nbsp;&#8211;&nbsp;13:00 | 8-9 February<\/div>\n<div class=\"session_title\">\n<h6>Creating Your Wealth &#038; Success With Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/randy-austin\/\">Randy Austin<\/a><\/strong>&nbsp;Founder of Excel For Freelancers | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_599\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">In this masterclass Randy Austin will teach you how to leverage your Excel skills to create incredible value for the marketplace and use those skills to gain the freedom, wealth &#038; success you desire. You will take a deep dive into the fundamentals of creating real solutions for real businesses that will enable you to create recurring &#038; passive income for life. This Masterclass will take place virtually over 2 days: 8 February 2020 | 09:00-13:00 GMT (Part 1) &#038; 9 February 2020 | 09:00-13:00 GMT (Part 2)<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Virtual Classroom<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<ul class=\"scheduleday_wrapper themeborder one_half \">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">Open Theatre (Day 1)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">Recordings available now<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1242\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/08\/23-150x150.png\" alt=\"Natalie Bayfield\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">10:00&nbsp;&#8211;&nbsp;10:45<\/div>\n<div class=\"session_title\">\n<h6>Welcome Keynote<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/natalie-bayfield\/\">Natalie Bayfield<\/a><\/strong>&nbsp;Chairwoman, Bayfield Training<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1244\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/25-1-150x150.png\" alt=\"Chris James\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">11:00&nbsp;&#8211;&nbsp;11:45<\/div>\n<div class=\"session_title\">\n<h6>How to Develop Advanced Spreadsheet skills?<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/chris-james\/\">Chris James<\/a><\/strong>&nbsp;Founder of WeAreExcel<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1244\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Have you ever been on an Excel training course only to forget much of the content covered? How does one remember all the complex techniques often covered on a typical Excel 1-day training course?<br \/>\nChris James is both clear and enthusiastic about what he describes as the \u201cthree key factors\u201d which need to happen for most people, in order to develop advanced and effective spreadsheet skills.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1258\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">12:00&nbsp;&#8211;&nbsp;13:00<\/div>\n<div class=\"session_title\">\n<h6>Lunch Break<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1246\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/Excel-data-visualization-Analytics-13-150x150.png\" alt=\"Charles Williams\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">13:00&nbsp;&#8211;&nbsp;13:45<\/div>\n<div class=\"session_title\">\n<h6>Making Excel run Faster<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/charles-williams\/\">Charles Williams<\/a><\/strong>&nbsp;Managing Director, Decision Models<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1246\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Making Excel run Faster:<br \/>\nIf you are a serious Excel user then you need to understand what the Excel slowdown pain points are, how to find them and how to reduce or eliminate them. This session will cover:<br \/>\n\u00b7 Whats fast and slow in Excel 2010 versus Excel M365<br \/>\n\u00b7 Speeding up Excel Calculations<br \/>\n\u00b7 Speeding up VBA<br \/>\n\u00b7 Dynamic Arrays: the missing functions<\/p>\n<p>This session will be led by Charles (Mr. Fast Excel) Williams, 12x Excel MVP<\/p><\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1260\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/08\/1-150x150.png\" alt=\"Tatiana Ufimtceva\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:00&nbsp;&#8211;&nbsp;14:45<\/div>\n<div class=\"session_title\">\n<h6>Excel Efficiency<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/tatiana-ufimtceva\/\">Tatiana Ufimtceva<\/a><\/strong>&nbsp;Founder and CEO, KeySkillset<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1260\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Introducing time-saving shortcuts and lesser-known functions and features to make you an Excel power user. Increase your efficiency by mouse-free use of Excel and save tons of time. Join our 45 min session to save 45 days this year.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1262\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/DELEGATE-TICKET-6-150x150.png\" alt=\"Jeff Lenning\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">15:00&nbsp;&#8211;&nbsp;15:45<\/div>\n<div class=\"session_title\">\n<h6>Excel Speed Loop<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/jeff-lenning\/\">Jeff Lenning<\/a><\/strong>&nbsp;CPA, President at Excel University<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1262\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Working fast in Excel requires both process and skills. The skills are the Excel features and functions. In this session, we&#8217;ll focus on a process that will help you optimize your workbooks for efficiency and accuracy. This Speed Loop process helped me reduce the time to update my Excel workbooks from 2 weeks per month to 2 days per month, and I&#8217;m sure it can help you as well!<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_2876\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/10\/Untitled-design-22-150x150.png\" alt=\"Ken Puls\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:00&nbsp;&#8211;&nbsp;16:30<\/div>\n<div class=\"session_title\">\n<h6>Build Better Excel Data Models Faster<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/ken-puls\/\">Ken Puls<\/a><\/strong>&nbsp;President of Excelguru Consulting | 14x Micosoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_2876\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">If you work with Power Query and Power Pivot regularly, you know that setting up a new data model can be a tedious process.  And even worse \u2013 when you pick up that model that was built by a colleague \u2013 how do you know it is reliable?<br \/>\nIn this session, Ken will give you a rapid fire demo of \u201cMonkey Tools\u201d; an Excel add-in that he developed in order to make your data modeling life easier.  You\u2019ll see how you can easily inject dynamic calendars into your data model, build multiple Explicit Measures with a few clicks, and audit models that have been handed to you.  And that is only the beginning\u2026 with tools to trace and time Power Query refreshes, trace DAX dependencies, and debug that irritating \u201cRelationships May Be Needed\u201d error, you\u2019ll see why it\u2019s worth getting to know the Data Monkey.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1266\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/08\/23-150x150.png\" alt=\"Natalie Bayfield\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:30&nbsp;&#8211;&nbsp;17:00<\/div>\n<div class=\"session_title\">\n<h6>New Functions in Excel \u2013 A Real Estate case study<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/natalie-bayfield\/\">Natalie Bayfield<\/a><\/strong>&nbsp;Chairwoman, Bayfield Training<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1266\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">This seminar will use some of the new features in Excel to solve a genuine business problem in Commercial Real Estate. Real Estate financial models have many unique features. One is the unusual set of dates that tenants of commercial property tend to pay and review their rent. New functions such as LAMBDA and LET allow improvements to be made on some of the traditional solutions.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<ul class=\"scheduleday_wrapper themeborder one_half last\">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">Open Theatre (Day 2)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">Recordings available now<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1270\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2021\/02\/Excel-data-visualization-Analytics-12-150x150.png\" alt=\"Donald MacCormick\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">10:00&nbsp;&#8211;&nbsp;10:45<\/div>\n<div class=\"session_title\">\n<h6>Transform Ordinary Spreadsheets into Interactive Content<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/donald-maccormick\/\">Donald MacCormick<\/a><\/strong>&nbsp;Chief Strategy Officer, Squirrel365<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1270\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Looking to take your spreadsheets to the next level? See how easy it is to build stunning interactive content from your spreadsheets and deliver it with one click in PowerPoint, via the web or even embed in your website.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1280\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/DELEGATE-TICKET-6-150x150.png\" alt=\"Jeff Lenning\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">11:00&nbsp;&#8211;&nbsp;11:45<\/div>\n<div class=\"session_title\">\n<h6>Excel Speed Loop<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/jeff-lenning\/\">Jeff Lenning<\/a><\/strong>&nbsp;CPA, President at Excel University<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1280\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Working fast in Excel requires both process and skills. The skills are the Excel features and functions. In this session, we&#8217;ll focus on a process that will help you optimize your workbooks for efficiency and accuracy. This Speed Loop process helped me reduce the time to update my Excel workbooks from 2 weeks per month to 2 days per month, and I&#8217;m sure it can help you as well!<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1276\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">12:00&nbsp;&#8211;&nbsp;13:00<\/div>\n<div class=\"session_title\">\n<h6>Lunch Break<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1278\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/Untitled-design-9-150x150.png\" alt=\"Fr\u00e9d\u00e9ric Le Guen\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">13:00&nbsp;&#8211;&nbsp;13:45<\/div>\n<div class=\"session_title\">\n<h6>Load historical currencies and stock history in Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/frederic-le-guen\/\">Fr\u00e9d\u00e9ric Le Guen<\/a><\/strong>&nbsp;10x Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_1272\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/08\/1-150x150.png\" alt=\"Tatiana Ufimtceva\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:00&nbsp;&#8211;&nbsp;14:45<\/div>\n<div class=\"session_title\">\n<h6>Financial Modelling Tricks<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/tatiana-ufimtceva\/\">Tatiana Ufimtceva<\/a><\/strong>&nbsp;Founder and CEO, KeySkillset<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_1272\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">Would you be able to build a DCF financial model in less than two minutes? We can prove you can do that! Excel speed, efficiency and accuracy are critical skills for aspiring financial modellers to learn in today&#8217;s competitive environment. &#8220;Sow an action, reap a habit&#8221; &#8211; join our session and master your skills.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_4240\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/12\/20201201_Indzara_GlobalExcelSummit_Logo_400x400_02-150x150.png\" alt=\"INDZARA\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">15:00&nbsp;&#8211;&nbsp;15:45<\/div>\n<div class=\"session_title\">\n<h6>Why you should choose Excel to develop applications?<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/indzara-com\/\">INDZARA<\/a><\/strong>&nbsp;Simple and Effective Excel Templates<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_4240\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">10 reasons why I chose Excel to develop applications. 10 examples to illustrate the versatility of Excel in developing applications in various industries. Simple framework to develop your own applications in Excel. All without any VBA. Just formulas.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_3249\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/11\/Untitled-design-24-150x150.png\" alt=\"Alan Murray\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">16:00&nbsp;&#8211;&nbsp;16:45<\/div>\n<div class=\"session_title\">\n<h6>The Secret Lookup Functions that Deserve your Love<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/alan-murray\/\">Alan Murray<\/a><\/strong>&nbsp;Founder of Computergaga | Microsoft MVP<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_6510\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2021\/02\/24-150x150.png\" alt=\"Jon Acampora\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">17:00&nbsp;&#8211;&nbsp;17:45<\/div>\n<div class=\"session_title\">\n<h6>Excel Add-ins: Get Off The Hamster Wheel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/jon-acampora\/\">Jon Acampora<\/a><\/strong>&nbsp;Founder of Excel Campus<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_6510\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">If you feel stuck with doing the same daily, weekly, or monthly tasks with Excel, then add-ins can help.  During this session you will learn what add-ins are, how they can drastically increase your productivity, make your spreadsheets easier for other users, and even how to build your own.<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Open Theatre<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<ul class=\"scheduleday_wrapper themeborder one_half \">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">The Academy (Day 1)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">(Beginner &amp; Intermediate)<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_4329\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/28-150x150.png\" alt=\"Kyle Pew\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">10:00&nbsp;&#8211;&nbsp;13:30<\/div>\n<div class=\"session_title\">\n<h6>An Introduction to Microsoft Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/kyle-pew\/\">Kyle Pew<\/a><\/strong>&nbsp;Microsoft Certified Trainer<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_4329\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">\u2714\ufe0e Entering and Editing Text Formulas<br \/>\n\u2714\ufe0e Working with Basic Excel Functions<br \/>\n\u2714\ufe0e Modifying an Excel Worksheet<br \/>\n\u2714\ufe0e Formatting Data in an Excel Worksheet<br \/>\n\u2714\ufe0e Inserting Images and Shapes into an Excel Worksheet<br \/>\n\u2714\ufe0e Creating Basic Charts in Excel<br \/>\n\u2714\ufe0e  Printing an Excel Worksheet<br \/>\n\u2714\ufe0e Working with Excel Templates<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Academy Room<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_3617\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">13:30&nbsp;&#8211;&nbsp;14:00<\/div>\n<div class=\"session_title\">\n<h6>Lunch Break<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_4330\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/28-150x150.png\" alt=\"Kyle Pew\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:00&nbsp;&#8211;&nbsp;18:00<\/div>\n<div class=\"session_title\">\n<h6>Intermediate Level Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/kyle-pew\/\">Kyle Pew<\/a><\/strong>&nbsp;Microsoft Certified Trainer<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_4330\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">\u2714\ufe0e Working with an Excel List<br \/>\n\u2714\ufe0e Excel List Functions<br \/>\n\u2714\ufe0e Excel Data Validation<br \/>\n\u2714\ufe0e Importing and Exporting Data<br \/>\n\u2714\ufe0e Excel PivotTables<br \/>\n\u2714\ufe0e Working with Excel&#8217;s PowerPivot Tools<br \/>\n\u2714\ufe0e Working with Large Sets of Excel Data<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Academy Room<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<ul class=\"scheduleday_wrapper themeborder one_half last\">\n<li class=\"scheduleday_title\" style=\"background:#2665b8;\">\n<div class=\"scheduleday_title_icon\"><span class=\"ti-calendar\" style=\"color:;\"><\/span><\/div>\n<div class=\"scheduleday_title_content\">\n<h4 style=\"color:;\">The Academy (Day 2)<\/h4>\n<div class=\"scheduleday_desc\" style=\"color:;\">(Advanced &amp; VBA)<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_4331\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/28-150x150.png\" alt=\"Kyle Pew\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">10:00&nbsp;&#8211;&nbsp;13:30<\/div>\n<div class=\"session_title\">\n<h6>Advanced Level Excel<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/kyle-pew\/\">Kyle Pew<\/a><\/strong>&nbsp;Microsoft Certified Trainer<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_4331\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">\u2714\ufe0e Working with Excel&#8217;s Conditional Functions<br \/>\n\u2714\ufe0e Working with Excel&#8217;s Lookup Functions<br \/>\n\u2714\ufe0e Working with Excel&#8217;s Text Based Functions<br \/>\n\u2714\ufe0e Auditing an Excel Worksheet<br \/>\n\u2714\ufe0e Protecting Excel Worksheets and Workbooks<br \/>\n\u2714\ufe0e Mastering Excel&#8217;s &#8220;What If?&#8221; Tools<br \/>\n\u2714\ufe0e Automating Tasks in Excel with Macros<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">Academy Room<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_4332\">\n<div class=\"session_speaker_icon\"><span class=\"ti-timer\"><\/span><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">13:30&nbsp;&#8211;&nbsp;14:00<\/div>\n<div class=\"session_title\">\n<h6>Lunch Break<\/h6>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<li class=\"themeborder visitor-ticket-sessions delegate-ticket-sessions master-delegate-ticket-sessions \">\n<div class=\"session_content_wrapper expandable\" data-expandid=\"excerpt_4333\">\n<div class=\"session_speaker_thumb\"><img decoding=\"async\" src=\"https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/28-150x150.png\" alt=\"Kyle Pew\"\/><\/div>\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_start_time\">14:00&nbsp;&#8211;&nbsp;18:00<\/div>\n<div class=\"session_title\">\n<h6>Master Microsoft Excel Macros and VBA in 6 Simple Projects<\/h6>\n<\/div>\n<div class=\"session_speakers\">By&nbsp;<strong><a href=\"https:\/\/2021.globalexcelsummit.com\/speaker\/kyle-pew\/\">Kyle Pew<\/a><\/strong>&nbsp;Microsoft Certified Trainer<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<div id=\"excerpt_4333\" class=\"session_content_extend hide session_content_wrapper\">\n<div class=\"session_content has_speaker_thumb\">\n<div class=\"session_excerpt\">\u2714\ufe0e Using Excel&#8217;s Macro Recorder Tool<br \/>\n\u2714\ufe0e Excel VBA Concepts<br \/>\n\u2714\ufe0e Moving Beyond the Basics and into VBA<br \/>\n\u2714\ufe0e Preparing and Cleaning Up Data with a little VBA<br \/>\n\u2714\ufe0e Using VBA to Automate Excel Formulas<br \/>\n\u2714\ufe0e Bringing it All Together and a Weekly Report<br \/>\n\u2714\ufe0e Working with Excel VBA User Forms<br \/>\n\u2714\ufe0e Importing Data from Text Files<\/div>\n<div class=\"session_title_list\"><span class=\"ti-bookmark\"><\/span><\/p>\n<div class=\"session_title_item\">(FREE) Visitor Ticket<\/div>\n<div class=\"session_title_item\">Delegate Ticket<\/div>\n<div class=\"session_title_item\">Master Delegate Ticket<\/div>\n<\/div>\n<div class=\"session_location themeborder\">\n<div class=\"session_location_label skin_color\">Where<\/div>\n<div class=\"session_location_content\">The Academy Room<\/div>\n<\/div>\n<\/div>\n<p><br class=\"clear\"\/><\/div>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<div  class=\"one withsmallpadding ppb_header parallax withbg \" style=\"background-image:url(https:\/\/2021.globalexcelsummit.com\/wp-content\/uploads\/2020\/09\/shutterstock_1199954740-scaled.jpg);background-position: center center;text-align:center;padding:100px 0 100px 0;color:#ffffff;\" >\n<div class=\"overlay_background\" style=\"background:#000000;background:rgb(0,0,0,0.6);background:rgba(0,0,0,0.6);\"><\/div>\n<div class=\"standard_wrapper\">\n<div class=\"page_content_wrapper\">\n<div class=\"inner\">\n<div style=\"margin:auto;width:60%\">\n<h2 class=\"ppb_title\" style=\";text-align:center;\">TAKE YOUR SKILLS TO THE NEXT LEVEL<\/h2>\n<div class=\"page_tagline\" style=\"color:#ffffff;;text-align:center;\">Complete 2021 Global Excel Summit event package now on sale.<br \/>\nFrom Main Stage speaker sessions to Open Theatre talks, to exclusive Product Demos you CANNOT and SHOULD NOT miss.<\/div>\n<div class=\"ppb_header_content\">\n<p><a class=\"button medium\" href=\"https:\/\/globalexcelsummit.com\/contact-us\">Get Event Package<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Main Stage (Day 1) Recordings available now 09:00&nbsp;&#8211;&nbsp;10:00 Opening Keynote by Microsoft By&nbsp;Kaycee Reineke&nbsp;Sr. Product Manager, Microsoft Excel,&nbsp;Chris Gross&nbsp;Sr. Product Manager, Microsoft Excel,&nbsp;Vaibhavi Phadnis&nbsp;Product Manager, Microsoft Excel More details coming soon. Delegate Ticket Master Delegate Ticket Where Main Stage 11:00&nbsp;&#8211;&nbsp;11:45 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2655,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/pages\/291"}],"collection":[{"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/comments?post=291"}],"version-history":[{"count":86,"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/pages\/291\/revisions"}],"predecessor-version":[{"id":7213,"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/pages\/291\/revisions\/7213"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/media\/2655"}],"wp:attachment":[{"href":"https:\/\/2021.globalexcelsummit.com\/wp-json\/wp\/v2\/media?parent=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}