Welcome to the Global Excel Summit 2024 replay page!
All event sessions are now available to watch on-demand.
An action-packed opening day from London
featuring sessions exploring the latest AI trends in Excel.
Description:
โThe summit kicks off with a keynote from Microsoftโs Jack Williams, who dives deep into Excel's modern AI features and explains recent developments.
Files:
Presentation file - Download pptx
Description:
โThe world-renowned Microsoft MVP delivers an opening presentation demonstrating ย how Python in Excel can be utilised for machine learning.
Files:
N/A
Description:
โAI is changing data visualisation in Excel. Combine the best of both worlds with Zebra BI, so you can deliver the right story to your audience effortlessly.
Files:
N/A
Description:
The charismatic duo meet face-to-face to chat about the good, bad, and ugly of AI, security implications, and how it can be leveraged for the greater good.
Files:
N/A
Description:
Learn how to maximise the benefits of Python in Excel. Plus, discover how the recent integration can enable complex data visualisation and analysis with often just a single line of code.
Files:
Presentation files - Download here
Description:
Grasp the ways AI can be used to build better training and presentation materials for Excel, leveraging tools like ChatGPT, Mockaroo, and Copilot.
Files:
N/A
Description:
Discover the secret framework for changing AI generated VBA code into a machine that you can use to automate any task.
Files:
Presentation file - Download pptx
Working file - Download xlsx
Description:
Emma Chieppor dives into Excel's AI and data analytic capabilities, as well as getting to the bottom of what the future looks like for analysts.
Files:
Presentation file - Download pptx
โWorking file - Download xlsx
Discover the best practices in data visualisation, finance, Power Query, and Power BI in a set of wide-ranging sessions from London.
Description:
Learn how Power Query, dynamic arrays, form controls, and images can be combined to create stunning never-seen-before charts.
Files:
Working file - Download xlsx
Description:
Explore creative ways to use interactive data visualisation in Excel to view and interact with data from different angles and perspectives.
Files:
Presentation files - Download here
Description:
โDiscover innovative ways to create a visual app interface in Excel using Microsoft's new Script Lab and Excel Lab tool sets.
Files:
N/A
Description:
Unlock the power of actionable reporting with Zebra BI and transform data into strategic assets that drive decision-making!
Files:
N/A
Description:
Ian Bennett demonstrates the importance of emphasising quality when building financial models for present and future clients.
โ
Files:
Presentation file - Download here
Description:
Join Danielle Stein Fairhurst to learn how Excelโs dynamic array functions make it impossible to have inconsistent formulas when building financial models.
Files:
Presentation file -Download pptx
Working file - Download xlsx
Description:
Ben Johnstone and Iain Morrow show how Openbox can enable you to expertly craft financial models in hours, not weeks.
Files:
N/A
Description:
Learn to identify and work with advanced Power Query concepts like lists, records and custom functions to make your queries more robust and efficient.
Files:
Presentation files - Download here
Description:
Gaลกper Kamenลกek explains the five main differences between Power BI and Excel, so youโre better placed to judge when one should be used over the other for enterprise BI solutions.
Files:
Presentation file - Download here
Description:
Michael Olafusi demonstrates why Git integration in Power BI is necessary for effective collaboration amongst developers during report building.
Files:
Presentation file - Download here
Description:
โUnlock the power of actionable reporting with Zebra BI and transform data into strategic assets that drive decision-making!
Files:
N/A
Description:
Explore the world of Excel monetization and identify exciting opportunities to commercialise your spreadsheets with Sheetcast.
Files:
N/A
Description:
With LAMBDA, the ceiling has been removed and there is no stopping you. Discover the true potential of LAMBDA functions in Excel.
Files:
Working files - Download here
Description:
Bob Umlas's Tips & Tricks arenโt the standard run-of-the-mill kind. Theyโre elusive gems youโll be desperate to try out when you head back to the office!
Files:
Working file - Download xlsx
A marathon of online-only sessions, featuring the likes of ChatGPT, dashboard creation, innovative add-ins, and thought-provoking panel discussions.
Description:
โRichard Nero shares his six-week Excel training program designed to introduce children to the spreadsheet world. Thereโs pixel art, treasure hunts, and battleships!
Files:
Presentation - Download pptx
Description:
โUnlock the power of actionable reporting with Zebra BI and transform data into strategic assets that drive decision-making!
Files:
N/A
Description:
โWhat actually is ChatGPT and how can it improve your Excel experience? Learn useful tricks with the free model and dive into how you can get full bang for your buck with ChatGPT+.
Files:
Presentation file - Download pptx
Description:
Discover how to create visually appealing, memorable charts that not only grab attention but are also highly effective for business communication.
Files:
Working file - Download xlsx
Description:
Unlock the power of actionable reporting with Zebra BI and transform data into strategic assets that drive decision-making!
โ
Files:
N/A
Description:
Our Event Ambassador takes on your questions about all things Excel. Learn what her favourite function is, how she amassed so many YouTube subscribers, and much more!
Files:
N/A
Description:
Unlock the power of actionable reporting with Zebra BI and transform data into strategic assets that drive decision-making!
โ
Files:
N/A
Description:
โUnlock the power of actionable reporting with Zebra BI and transform data into strategic assets that drive decision-making!
โ
Files:
N/A
Description:
โWhat are simple things you can do to improve your budgets and forecasts in Excel using various established functions and features to get more buy-in to your models?
Files:
N/A
Description:
Siemens' Martin Angelov meets finance trainer Nicolas Boucher to discuss the impact AI is having on the finance sector.
Files:
Presentation file - Download pptx
Description:
Discover how you can use Zebra BI to identify key trends and insights from your data so you can act on them quickly and ย reliably.
Files:
N/A
Description:
Gustaw Dudek demonstrates how to build a dynamic and multidimensional dashboard to aid decision-making in executive teams.
โ
Files:
Presentation file - Download pptx
Description:
Jason Clarke and Alex Martin unlock the power of Sheetcast to build a watering schedule, travel app, and business directory in quick time!
Files:
N/A
Description:
Stephan Methner shows you how ย to create web apps using the full power of your spreadsheets to build business software incredibly fast.
โโ
Files:
N/A
Description:
โEver wondered how some of the best Microsoft Excel professionals think under pressure, compete, and solve real-life case studies within very limited timeframes?
โ
Files:
N/A
Description:
โExcel for Mac has come a long way. It is no longer "a toy to be laughed at" and the recent inclusion of Power Query has elevated its capabilities to new heights.
Files:
Working files - Download here
Description:
It's common to encounter problems in Power BI, but what are the solutions? Boriana Petrova demonstrates several real world examples so you're better equipped to solve them.
Files:
Working files - Download here
Description:
Discover how Excelโs 'Analyze Data' tool and AI integration enhances productivity to help you to achieve more with less effort.
โFiles:
Presentation file - Download pptx
Description:
Nabil Mourad demonstrates several methods for combining data in Excel, which can be applied to scenarios of varying complexity.
โ
Files:
Presentation files - Download here
Description:
Excel has massively evolved over the last few years, and we now have other tools to solve challenges where VLOOKUP falls short. Power Query is one of those tools.
Files:
Presentation file - Download pptx