Modern Excel … a Replacement for the Spreadsheet?

The introduction of Dynamic Arrays has fundamentally altered how spreadsheets are built! Watch to hear from Peter Bartholomew to explore how ad-hoc end-user practices are giving way to structured, programming-like approaches, thanks to new capabilities like LET variables, LAMBDA functions, recursion, and advanced array handling. The talk will highlight how these innovations enable the creation of robust, algorithm-driven spreadsheet solutions, moving far beyond traditional tips and tricks. This presentation draws on insights from Peter’s recent paper delivered at the EuSpRIG conference, where he explored how embracing “array thinking” and the new Excel programming paradigm can reduce risks and unlock unprecedented flexibility for spreadsheet developers and modellers. ★ Follow Peter Bartholomew on LinkedIn ► https://www.linkedin.com/in/peterbartholomew/ ★ Follow Danielle Stein Fairhurst on LinkedIn ► https://www.linkedin.com/in/daniellesteinfairhurst/ ★ Register for another Virtual Meetup ► https://plumsolutions.com.au/meetup/