Using Python from Excel

Using Python from Excel: Unlock Advanced Analytics in Your Spreadsheets

Microsoft now supports native Python integration within Excel, opening up powerful new possibilities for data analysis, automation, and advanced modelling—all within the familiar Excel environment. In this hands-on masterclass, you’ll learn how to bring the power of Python into your spreadsheets to elevate your productivity and analytical capabilities.

Ideal for analysts, data professionals, and Excel power users, this session will show you how to embed Python code, use key libraries, and extend what’s possible with your existing Excel workflows.

Learning Outcomes

• Learn How to Embed Python in Excel
  Step through the process of inserting Python code directly into your Excel worksheets using Microsoft’s built-in functionality.

• Explore Supported Python Libraries
  Discover which Python libraries are available and how they can be used to enhance your data processing, visualisation, and analysis.

• See Practical Applications Within Excel
  Understand how Python can complement traditional Excel features—unlocking new use cases for automation, advanced calculations, and data insights.

By the end of the session, you’ll be ready to combine the flexibility of Python with the accessibility of Excel—enabling smarter, faster, and more powerful spreadsheet solutions.

Target Audience

This masterclass is designed for Excel users who want to incorporate Python into their workflows. No prior Python experience is required, though familiarity with Excel formulas and functions will be helpful.