Flex Data & Analytics Meetup

Dynamic arrays are great for creating ranges that change shape as the data changes. Charts based on dynamic arrays will also change their source data to match the array.

But it's not always that simple and there are important things you need to be aware of.

Join us and learn from world-leader in Excel charting and Microsoft Excel MVP, Jon Peltier.

In this informal session, we'll look at two of the features of Anaconda Toolbox for Excel:

1. Anaconda Code:
- Configurable environment that runs locally in the add-in (data does not leave the workbook)
- Ability to define Excel User-Defined Functions with Python (including functions that return charts!)
- Use pyscript.com to build and share libraries of functions
- Isolated Mode vs. Linked Mode

2. Anaconda Assistant - chat with an LLM directly in the add-in to get help with writing Python

Take a look at this!
https://www.linkedin.com/posts/owenhprice_data-analytics-python-activity-7308895458838360064-_o3H?utm_source=share&utm_medium=member_desktop&rcm=ACoAAAYENJ4BwzD1Qrj8qZ03t5NKQTylKYE3hhM