SPEAKER

Jon Acampora

Jon Acampora runs ExcelCampus.com and he’s all about making Excel easier and more fun. As a Microsoft MVP for 10 years, with over 500,000 YouTube subscribers, and a regular host of the FMWC events, his love for Excel is probably obvious.  
 
But what really drives him? 
 
Helping people. At the heart of his mission is a genuine passion for helping the community harness the power of Excel. By eliminating mundane tasks, Jon strives to make Excel not only a tool for efficiency but also a canvas for fun and creativity. With innovative Excel add-ins and insightful online courses, he’s paving the way for a more efficient and enjoyable spreadsheet experience.

Make Your Data Spill the Beans with Dynamic Array Formulas

DEC 8 | 10:00 AM - 11:00 AM

Dynamic array formulas and spill ranges have arguably been the biggest change to the grid in the 38-year history of Excel. They make formulas much easier to write, allowing for quicker and more efficient data analysis.


But how do they compare to other tools in Excel like Pivot Tables and Power Query? And how do you know when to use one solution over the other?

In the spirit of competition, we are going to dive into 7 different “battles” to answer these questions.

We will start with the basics of dynamic arrays and also look at more advanced use cases.  So there will be something for every skill level. And the training will be packed with tips for formatting, keyboard shortcuts, and other time-saving hacks.

Future of Microsoft Excel - What to Expect in The Coming Years

DEC 9 | 9:10 AM - 9:55 AM

Hosts Microsoft Excel World Championship 2023 - Finals

DEC 9 | 7:00 PM - 10:00 PM

Meet Jon!

OTHER SPEAKERS

Stephanie Annerose

Acquisition, capital raise, project finance and corporate lending professional. Has MSc in civil engineering & construction, and project & structured finance.

Linkedin Address-card

Emilie Williams

An independent mining engineer and a university lecturer in Mining Engineering.

Linkedin Address-card

Kevin Bernstein

Practice Lead for Governance, Adoption and Change Management, SoftwareOne North America

Linkedin Address-card

Laurence Lau

Founder of The Golden Company. FMWC 2022 and 2023 Champion. Ex Wall Street quant.

Linkedin Address-card

Michael Clarke

Previously worked as actuary in PwC and Taylor Fry. Five times ModelOff finalist and one time bronze medalist. Two time MEWC finalist.

Linkedin Address-card

Patrick Chatain

Worked at Operis for 2 years together with Michael Jarman. Active FMWC and MEWC participant. Part of the case design team. Currently pursuing an MSc. in Mathematics and Statistics.

Linkedin Address-card

Jaq Kennedy

Contractor with an impressive 23-year track record in the actuarial departments of leading insurance providers in Europe and the UK.

Linkedin Address-card

Peter Scharl

Road to Las Vegas and MEWC cases' author, Consultant at Oliver Wyman

Linkedin Address-card

Andrew Ngai

Microsoft Excel World Championship Winner 2021, 2022.

Linkedin Address-card

Jordan Goldmeier

Award-winning author in analytics, data science, and data visualization. 11-time Microsoft MVP Award winner

Linkedin Address-card

Andrew Grigolyunovich

Founder & CEO of Financial Modeling World Cup. Financial Modeling World Championship 2-time finalist

Linkedin Address-card

Bob Umlas

25-time Excel MVP Award winner, author of 5 Excel books, Excel user since version 0.99

Linkedin Address-card

Ian Schnoor

Executive Director at Financial Modeling Institute. Chartered Financial Modeler

Linkedin Address-card

KEY PARTNERS