Name: The Hidden Keys to Unlocking Dynamic Array Calculations in Excel | Mark Proctor
Start: 2025-08-07T17:00:00.000Z
Location: Canada Water Library

In this meetup, we welcome Agnieszka Nyka to present on how creating and solving puzzles for fun in Excel can improve our skills for when it really matters.

**What to Expect**
What do a Rubik’s cube, a Galton board, and a spreadsheet have in common? For this Excel-obsessed accountant, they’ve each sparked some of her most unexpected breakthroughs in problem-solving.

In this light-hearted (but sneakily deep) session, Agnieszka Nyka shares her journey of recreating traditional puzzles in Excel—not to show off advanced formulas, but to explore how creativity, logic, and structured thinking can transform how we think about spreadsheets – at work and beyond.

This isn’t a technical deep dive, but rather an exploration of creative logic, real-world problem- solving and seeing Excel as a thinking tool—not just a reporting one. Expect quirky builds, nerdy humour, and a reminder that what looks complex is often powered by simple, structured ideas. And sometimes the fastest way to grow is to build something just for the fun of it.

This is an **in-person only** event.

The event will be held in
Meeting room 3,
Canada Water Library,
21 Surrey Quays Rd, London SE16 7AR.

London Excel Meetup Group

Alan Murray

Tea Kuseva

Dean Forbes (PERS)

Kunj

Alberto Fogale

Giorgaki Potsi

Ju Yen Tan

Mark Wilcock

Iwona

bidemi Olatunji

Roopesh

JACEK

Aristotle Liu

Jess S

Stephen Leung

Anh Hoang

agianp

Naveen Ganpat

Agnieszka Nyka

Mark Proctor

Puzzle Path: Excel Fun & Getting Better at the Serious Stuff | Agnieszka Nyka

Canada Water Library

In this meetup, David Johnston will be presenting on smarter ways to visualise variance in Power BI.

Of course, techniques learnt can be adapted for Excel reports too. But this session is all about Power BI and crafting effective variance visuals for your reports..

**What to expect**
In this session, we’ll explore smarter ways to visualise variance in Power BI, moving beyond the basics to create clear, impactful reports.

We’ll cover a range of techniques, from using native visuals and customising tables, to enhancing dashboards with SVG’s. You’ll also learn how to incorporate visual-level calculations to drive dynamic, context-aware variance displays.

Whether you’re building executive dashboards or operational reports, this session will give you practical ideas to make your variance visuals more effective and meaningful.

This is an **in-person only** event.

The event will be held in;
Meeting room 3,
Canada Water Library,
21 Surrey Quays Rd, London SE16 7AR.

Radek Minařík

Charles Brason

Nataliya

Rose Delcour-Min

Martin Richter

Olabanji k

michaelbrown1980

Ebenezer Asare

Paul Martin

David Da Silva Pereira

Shakeel Ahmad

Alan

Kate

Srividya Praveen

Visualising Variance: Smarter Ways to Show Change in Power BI | David Johnston

In this meetup, Mark Proctor returns to speak on some technical aspects of dynamic array calculations in Excel. Expect to learn something.

**What to Expect**
This session focuses the overlooked basics which underpin all calculations in Excel. It will reset your understanding and give you the clarity to perform advanced dynamic array calculations with ease.

This is an **in-person only** event.

The event will be held in
Meeting room 3,
Canada Water Library,
21 Surrey Quays Rd, London SE16 7AR

Ankur Shukla

Spyros

Julien Londeix

John Duddy

Fernanda Domingues

Roger Van Decraen

Sandeep Kothari

Abhijit Mandal

Gurdeep

Joseph K

Ben W

The Hidden Keys to Unlocking Dynamic Array Calculations in Excel | Mark Proctor

London Excel Meetup

Search {networkName}

Groups

{PRO_NETWORK_NAME} is on Meetup Pro with more than {PRO_MEMBER_COUNT} members across {PRO_GROUP_COUNT} Meetups worldwide. Meetup Pro is the professional tool for organizing and communicating a network of users, partners, contributors and members.

The **London Excel Meetup Group** is a community of Excel enthusiasts, professionals, and data lovers who come together to explore, learn, and master Microsoft Excel.

### **What We Offer:**

🔹 **Regular Meetups** – Sessions covering Excel formulas, data visualisation, automation with VBA, Power Query, and Power BI.
🔹 **Expert-Led Talks** – Industry professionals and Excel MVPs share insights, tips, and best practices to help you work smarter.
🔹 **Networking Opportunities** – Connect with like-minded individuals, share experiences, and expand your professional network.
🔹 **Latest Excel Features & Updates** – Stay ahead with the newest tools and functionalities released by Microsoft.

Provides organisation and marketing services to the group.

Computergaga

Provide hosting services for the online events.

Datel Productions

London Excel Meetup

Where Meetups Excel - Learn, Network, and Grow!

London Excel Meetup

Who we are

Sponsors

Computergaga

Datel Productions

Computergaga

Datel Productions

Computergaga

Datel Productions

Search London Excel Meetup

Upcoming events

Groups