Thanks all for attending today’s session on getting started with Advanced Analysis with Python for Copilot in Excel. The recording is now available at and you can download the slides and exercises file from I’d appreciate your feedback on today’s session if you were able to attend. Feel free to share what you enjoyed, what you'd like to see differently, or any additional topics you'd like me to cover. You can also leave a testimonial if you found the session valuable: . Lastly, if you're looking to elevate your finance or operations teams to operate like data analysts, scientists and engineers using Excel—without the need for costly software or IT delays—check out my services at . I also offer specialized workshops and training for research, procurement, and supply chain teams, both onsite and online. My goal is to build lasting partnerships that enhance your analytics capabilities for the long term. Thanks again for attending, and I hope to see you at future events! You can sign up for upcoming sessions here: Timestamps: 0:03 - Introduction and objectives 5:27 - Python and Excel trends 9:36 - Challenges with Copilot 11:27 - Advanced Analysis with Python 20:44 - Demo: Getting started with Python in Excel 34:00 - Handling missing values 38:59 - Outlier detection 47:59 - Text analysis demo 52:09 - Upcoming events and feedback

Today we passed through Leonidio, a village that still speaks Tsakonian, the old Spartan dialect of Greek. The signs were in both Greeks!

7 Excel Slicer Tips You Wish You Knew Earlier!

🤨

Driving around Greece and the Peloponnese hasn't been as rough as I was expecting! The mountains in California were way rougher to drive and honestly driving in America has gotten so bad since COVID that I didn't notice much of a difference 😅

Met two of my heroes today 🇬🇷

Tim O'Reilly: "This is the end of programming as we know it" Some random financial analyst on LinkedIn: "AI is overhyped and won't change the way I use Excel"

Thank you Celia Alves for sharing this awesome photo of me at the Global Excel Summit last week! What an incredible stage, both literally (looks just like a TED talk) and metaphorically (what's better than envisioning an even brighter future with Excel?). Maybe I'm a little more forgiving about some of the current integration struggles between Excel and AI, but that just means we need to get creative and find some workarounds. If that's not what Excel is all about, then I don't know what is. If you'd like to learn more about using Python, Excel and Copilot together and what that might mean for the future of self-service BI and citizen data science, you can check out the presentation resources at

Seeing a new technology transforming roles and industries adjacent to yours offers a great opportunity to ponder if your field might be next. Overlooking it by saying "it doesn't help me" or "it's not very good" is somewhat like saying "it doesn't work." Not exactly the open-minded approach that characterizes a thoughtful analyst. That's what bothers me so much about the collective shrug and groan that the Excel community seems to have about AI.

Big biznis in Napflio!

Contracting with a university be like:

@EuSpRIG IMO it serves as a huge drop in barrier to entry for setting up basic solutions where it otherwise would have been too technical. Whether that's in data retrieval, transformation, visualization and so forth. Guess we'll let the market decide

Essential techniques to get great results from any LLM via @ztobi

Befriending the locals in Athens!

Made it to Athens!

And that's a wrap from London and the @ExcelSummit! I had such a fun time with the most inquisitive students I've had in a while for our in-person masterclass on Excel Power Tools. We covered getting the most out of AI for Excel through structured data via Markdown and Power Query, the basics of using Python in Excel, and then put it all together with the Advanced Analysis with Python features of Copilot in Excel. We then ended the class with a brief survey of Power Automate and Office Scripts, which put us at a place of being citizen data analysts, scientists, engineers, and developers—all AI-powered and all in Excel. I'm so excited for the future of Excel and for next year's summit! Until then, it's time for a little holiday in Greece 🇬🇷

After 2 days of an absolute knowledge dump and an amazing time meeting everyone in this lovely world of Excel, it's time for my masterclass here at the Global Excel Summit. I'll be covering a survey of tools to help analysts get deeper insights and prepare and present them more effectively. We'll be running the gamut from AI and Copilot to Python in Excel, to even a bit of Power Automate and Office Scripts. If you'd like to see the course resources, head over to . Please consider joining us at future Global Excel Summit events. You can follow their page for updates and follow me for more analytics in Excel in the meantime.

What’s new in Copilot Studio: January 2025

CIOs need to make technology education and literacy a proactive strategy — because HR and user departments struggle to establish digital literacy and IT’s on the hook for results.

Yeah I'm an Anglophile