Unlocking Excel’s Power: Dynamic Formulas, Advanced Functions, and Python Integration at ASC’s First Meetup

We recently held our first Excel Meetup for the Association for Survey Computing (ASC), and it was a resounding success! This event brought together Excel enthusiasts, data professionals, and survey computing experts to explore the latest advancements in Excel, specifically tailored for survey analysis.

Watch the recording

Key Highlights from the Event

1. Edward Zavertyaev from BespokeSlides.com: Dynamic Formulas

We kicked off the session with an insightful presentation by Edward Zavertyaev, the founder of BespokeSlides.com. Edward introduced us to the benefits of dynamic formulas in Excel. These powerful formulas allow users to perform calculations across a range of data that automatically adjusts as new data is added. This feature is a game-changer for survey data analysis, where data sets are often updated and expanded over time. Edward’s demonstration showcased how dynamic formulas can streamline data processing and ensure accuracy, making it easier to manage large and evolving data sets.

2. Andrew Le Breuilly from Arrowstream: LET and LAMBDA Functions

Next, Andrew Le Breuilly from Arrowstream shared some incredibly useful Excel features that are particularly beneficial for those of us involved in survey analysis. Andrew focused on the LET and LAMBDA functions, which allow users to create more complex calculations and reuse formulas efficiently. He demonstrated how these functions can be leveraged to quickly create significance test formulas—a crucial tool for survey analysts. Andrew’s examples made it clear how these features can save time and reduce errors in survey data processing, enhancing both productivity and accuracy.

3. Owen Price, Microsoft MVP: Embedding Python in Excel

Our final presenter, Owen Price, a Microsoft MVP, gave us an exciting glimpse into the future of Excel. Owen introduced a forthcoming feature that will allow users to embed Python code directly within an Excel cell. This integration opens up a world of possibilities, enabling users to harness the power of Python’s extensive libraries and functions without leaving the Excel environment. For those working in survey computing, this feature could significantly enhance data analysis capabilities, allowing for more sophisticated data manipulation and visualization directly within Excel.

Looking Forward

This first meetup was just the beginning. We plan to hold regular sessions where we continue to explore the evolving landscape of Excel and its applications in survey computing. Stay tuned for announcements about our next event—we can’t wait to see you there!

Thank you to our presenters, Edward, Andrew, and Owen, for sharing their expertise, and to all attendees for making this a successful and engaging event. If you have any feedback or suggestions for future topics, feel free to reach out.

Let’s continue to push the boundaries of what’s possible with Excel in survey computing!