Conference Agenda

Browse Agenda Download Agenda

The Excel community is a diverse bunch. Different professions, different needs, and different desires.

5 action-packed tracks, 30+ speakers, Masterclasses, the Global Excel Awards, and networking deliver an all-encompassing package that fully lives up to the Excel Connected theme.

We cover Copilot, Python in Excel, Dynamic Arrays, Office Scripts, Power Query, Power BI, and much more.

What we cover?

Tech & Innovation

Discover how AI, Python and the latest new functions are shaping the Excel world and the ways you can take advantage of it. Plus, immerse yourself in thought-provoking panel discussions.

▶︎ ChatGPT and Copilot
 
▶︎ Excel, Python and Copilot: The new trinity of data analysis
‍
▶︎ The power of Data Models in Excel
‍
▶︎ Raising spreadsheet standards: How do we avoid the next disaster?

Data Viz & Analytics

Showcase your data with flair and flamboyance while hammering home your message effectively, thanks to Excel’s and Power BI’s bucket load of tools.

▶︎ Interactive data visualisation for decision making

▶︎ Combining Excel and Power BI for seamless data analysis

▶︎ Dynamic dashboard creation for KPI reporting

▶ Masterclass: Excel power tools for data analytics

Finance & Accounting

Learn the art and craft of budgeting, forecasting, and modelling to build rock-solid financial models in Excel that won’t implode.

▶︎ Excel and PowerPoint: Creating high-impact financial presentations

▶︎ How to ensure a model balance sheet always balances

▶︎ Financial modelling best practices

▶︎ Masterclass: Budget and forecast modelling in Excel

The Power Stack

Master Power Query, Power Pivot, and Power BI as you discover effective ways to clean, transform, and analyse data.

▶︎ Clean and transform data with Power Query and M
 
▶︎ The power of Power Query for updating reports

▶︎ Scalable enterprise reporting using Power BI
‍
▶︎ Masterclass: Power BI for advanced data visualisation

Formulas & Automation

Complete tasks quicker by constructing more efficient formulas and tapping into Excel’s range of automation capabilities.

▶︎ Collaboration & Sharing using Excel's AI-driven features
 
▶︎ Writing powerful custom functions with LET and LAMBDA
‍
▶︎ Ditch PivotTables — unlock the power of GROUPBY and PIVOTBY
‍
▶︎ Masterclass: Automate Excel with Office Scripts and Power Automate

Network & have fun!

Don't hide! There are a range of ways to interact and build relationships, ensuring an experience that spills beyond the duration of the event.

▶︎ Dedicated networking area — meet and mingle with other like-minded gatherers
 
▶︎ Speaker Talent Show
‍
▶︎ Global Excel Awards 2025
‍
▶︎ FREE refreshments and drinks reception at the end of each day

4 FEB 2025

Conference (Day 1)

📍Soho Place, London & Streamed Online

Event registration

Registration for all onsite attendees begins at 9:00 am.

Welcome and opening keynote

The summit kicks off with a short intro by event hosts Matthew Bernath, Liam Bastick, and Elena Lalovska, followed by an opening keynote.

Opening keynote by Leila Gharani

The world-renowned Microsoft MVP delivers an opening presentation.

That's great! But can you make it work online?

In this session, with Celia Alves, we will explore various ways to securely deliver Excel solutions to the web, and how you can extend those solutions beyond internal users.

Morning Break ☕️

Take a break, grab a coffee and enjoy a quick snack.

"Deal or no deal" — Best practice modelling tips

Discover new functions like TRIMRANGE with dynamic arrays, sequential logic with LAMBDA, conditional formatting, and data validation.

Creating high-impact financial presentations in Excel and PowerPoint

Create information-rich, visually compelling PowerPoint presentations driven by Excel data.

3 new financial modelling rules to embrace, break (or ignore!)

Discover how Taglo can help financial modellers create three rules that are tricky to implement in Excel.

Lunch Break 🥯

Get some food, rest a bit and get ready for what's coming next!

The Swiss Army knife for finance professionals

Discover the versatility of Excel to solve disparate problems faced by finance professionals as they model company cashflows and valuations.

2:50 pm

–

3:30 pm

Data Visualisation & Analytics

Guerrilla data analysis using Microsoft Excel and Power BI together

Explore data deeply to reveal insights, identify trends, and challenge assumptions using Excel and Power BI.

3:30 pm

–

4:00 pm

Data Visualisation & Analytics

Excel + Python + Copilot: The new trinity of data analysis?

Seamlessly integrate Excel, Python, and Copilot for everyday data analysis tasks and solve complex scenarios.

Talent Show 🤩

A 30 minute talent show with our Guest Speakers.

Networking 🍸

Free networking time for all event attendees.

5 FEB 2025

Conference (Day 2)

📍Soho Place, London & Streamed Online

Don't panic! A guide to error handling in Power Query

Tackle Power Query errors head-on by turning frustrating mistakes into learning moments, plus learn about priceless debugging methods.

The magic of the CONCATENATEX function in Power BI

Uncover the power of CONCATENATEX in Power BI to enhance reports with visuals, itemised breakdowns, and simplified calculations.

From mockups to masterpiece: Designing Power BI reports that delight stakeholders

Explore the importance of mockup creation in Power BI, capturing stakeholder needs early to align expectations before the final report.

Morning Break ☕️

Take a break, grab a coffee and enjoy a quick snack.

11:30 am

–

12:10 pm

Formulas & Automation

Achieving the zero-click dream with Office Scripts and Power Automate

Create dynamic workflows with Office Scripts and Power Automate by automating tasks that require no manual intervention.

12:10 pm

–

12:50 pm

Formulas & Automation

Ditch PivotTables — unlock the power of GROUPBY and PIVOTBY

Transform your reporting with a more flexible alternative to traditional PivotTables that involves just a single formula.

Cultivating a community of in-house Excel wizards

Learn how the Excel skills gap was closed at Forvis Mazars by promoting foundational skills, self-sufficiency, and gamified learning.

Lunch Break 🥯

Get some food, rest a bit and get ready for what's coming next!

Rethinking beginner, intermediate, and advanced Excel

This topic pops up frequently, and opinions vary greatly. Find out why one of the biggest Excel stars has changed his mind about it.

Decoding complexity: Empowering organisations to validate and trust their financial models

Col will discuss a key issue in financial modelling: the reliance on trust rather than systematic validation of the model.

Panel Discussion: Raising spreadsheet standards: How do we avoid the next disaster?

Industry figures discuss why spreadsheet standards across organisations are notoriously poor and how they can be improved.

Global Excel Awards 2025 ceremony 🏆

The Global Excel Awards 2025 reaches its climax, as the winners of five prestigious awards are revealed.

Networking 🍸

Free networking time for all event attendees.

6 FEB 2025

Conference (Day 3)

Streamed Online-only

Welcome and platform demo

The day kicks off with a welcome session with the Event hosts and a walk through the virtual event platform.

9:00 am

–

9:40 am

Data Visualisation & Analytics

You don't need Power BI to make sexy charts

Unlock the methods to make Excel charts that look even better than Power BI's.

Breaking the spreadsheet mould

Set aside formulas and best practices — think of Excel as Lego. Unleash your creativity as you witness imaginative and unconventional uses.

Adapt and Excel: Keeping up with Copilot’s fast-paced innovations

Explore the capabilities of Copilot in Excel, whether you are a free or Pro user.

Morning Break ☕️

Take a break, grab a coffee and enjoy a quick snack.

Keep your model balanced with a reliable cashflow

Learn the 'Twin Towers' approach for reliable cashflows and avoid common errors.

Establishing a single source of truth with Data Models in Excel

Discover how to use Excel's data modelling capabilities to build a robust and accurate system for financial data.

Lunch Break 🥯

Get some food, rest a bit and get ready for what's coming next!

The power of Power Query in updating reports

Find out how Power Query can be used to automate and optimise your reporting processes.

Scalable enterprise reporting with Excel & Power BI

Learn how the ReportStudio add-in can enhance Excel when dealing with very large datasets

Building custom business apps without coding

With April Dunnam, Microsoft

4:00 pm

–

4:40 pm

Formulas & Automation

Writing powerful custom functions with LET and LAMBDA

Learn the basics of LET and LAMBDA to give you a framework for building complex but easy-to-use functions.

4:45 pm

–

5:30 pm

Formulas & Automation

Create a wizard using VBA

Discover how to create a wizard using VBA, involving a multi tab userform created from scratch with all the VBA shown.

Panel Discussion: The spreadsheet trap: Why Excel isn’t always the answer

Industry figures discuss Excel’s drawbacks and how these contribute to inefficiencies, errors, and scalability challenges at organisations.

Conference Agenda

What we cover?

Tech & Innovation

Data Viz & Analytics

Finance & Accounting

The Power Stack

Formulas & Automation

Network & have fun!

4 FEB 2025

Event registration

Welcome and opening keynote

Opening keynote by Leila Gharani

That's great! But can you make it work online?

Morning Break ☕️

"Deal or no deal" — Best practice modelling tips

Creating high-impact financial presentations in Excel and PowerPoint

3 new financial modelling rules to embrace, break (or ignore!)

Lunch Break 🥯

The Swiss Army knife for finance professionals

Guerrilla data analysis using Microsoft Excel and Power BI together

Excel + Python + Copilot: The new trinity of data analysis?

Talent Show 🤩

Networking 🍸

5 FEB 2025

Don't panic! A guide to error handling in Power Query

The magic of the CONCATENATEX function in Power BI

From mockups to masterpiece: Designing Power BI reports that delight stakeholders

Morning Break ☕️

Achieving the zero-click dream with Office Scripts and Power Automate

Ditch PivotTables — unlock the power of GROUPBY and PIVOTBY

Cultivating a community of in-house Excel wizards

Lunch Break 🥯

Rethinking beginner, intermediate, and advanced Excel

Decoding complexity: Empowering organisations to validate and trust their financial models

Panel Discussion: Raising spreadsheet standards: How do we avoid the next disaster?

Global Excel Awards 2025 ceremony 🏆

Networking 🍸

6 FEB 2025

Welcome and platform demo

You don't need Power BI to make sexy charts

Breaking the spreadsheet mould

Adapt and Excel: Keeping up with Copilot’s fast-paced innovations

Morning Break ☕️

Keep your model balanced with a reliable cashflow

Establishing a single source of truth with Data Models in Excel

Lunch Break 🥯

The power of Power Query in updating reports

Scalable enterprise reporting with Excel & Power BI

Building custom business apps without coding

Writing powerful custom functions with LET and LAMBDA

Create a wizard using VBA

Panel Discussion: The spreadsheet trap: Why Excel isn’t always the answer

6 FEB 2025

Budget and Forecast Modelling in Excel

Save your seat