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

Join the Master Club

Your exclusive all-access pass to our entire digital learning experience for a whole year.

Get 365-Day Digital Pass