Formulas & Automation

14 Mar

5:00 pm

-

5:45 pm

Excel Expedition: A Global Journey Through Modern Iteration Formulas

Speakers:

No items found.

Pack your virtual bags and join Alan Murray for a global Excel adventure. Each continent brings a new data challenge and a new modern Excel superpower.

Iterate across rows and columns with BYROW and BYCOL, transforming datasets with MAP, building cumulative insight with SCAN, and simplifying complex aggregation with REDUCE and PIVOTBY, this session showcases how iteration-style formulas are reshaping Excel.

Get ready to rethink how Excel works.

Other Sessions

12:00 pm

-

12:45 pm

Calculation Efficiency in Excel

With Diarmuid Early, 2025 Excel World Champion

12:50 pm

-

1:20 pm

Model in Excel, run at cloud-scale, immediately.

Pebble Stream is a spreadsheet product that enables Excel users to create cloud-scale computing workflows.

02:20 pm

-

03:00 pm

From text chaos to clarity using REGEX

With Victor Momoh

6:00 pm

-

6:30 pm

Excel Tips That Will Make You Say “WOW”

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

All sessions include Q&A time and networking opportunities

Download Full Agenda

19-23 May 2026

One week, two premier events

Join the European Excel Week - from learning and mastering new skills at Global Excel Summit to elite performance at the Excel Esports European Open.