Python in Excel: Foundations for Non-Coders
Discover the next evolution of Excel with the power of Python directly into Microsoft 365.
Take your analysis, reporting, and modelling skills to the next level by combining the familiarity of Excel with the flexibility and speed of Python. Learn how to automate tasks, handle larger datasets, and create dynamic insights and visuals that go far beyond traditional spreadsheet limits.
Join industry expert Carolina Lago for this hands-on one-day Masterclass, designed for intermediate to advanced Excel users. Cut through the complexity and focus on the practical, real-world applications of Python in Excel without needing to become a programmer. Don’t miss this opportunity to stay ahead of the curve and transform the way you work with data.
What you'll learn?
- Master the essentials of Python in Excel - understand how it integrates with formulas and complements tools like Power Query and VBA.
- Automate and streamline your workflows - use Python to handle repetitive analysis, large datasets, and performance-heavy calculations effortlessly.
- Create richer insights and visuals - build advanced analyses, reports, and visualizations that go beyond Excel’s native capabilities.
- Leverage Python’s most powerful libraries - including NumPy, Pandas, Matplotlib, and Seaborn.
- Build a complete project from scratch - apply your new skills in a hands-on capstone exercise that brings together data cleaning, analysis, and visualization.
This class will be delivered by Caroline Lago in central London, UK on 21 May 2026.
This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.
What's included
Who is it for
This Masterclass is designed for professionals who use Excel regularly and are confident with its formulas, functions, and data tools. It focuses on the practical application of Python in Excel to enhance analysis, reporting, and automation without requiring any prior coding experience. Building on participants’ existing Excel skills, the course demonstrates how to integrate Python seamlessly to create faster, more powerful, and more flexible workflows.
- Data analysts and business professionals looking to modernize their Excel skills
- Finance professionals who want to automate and enhance reporting
- Power users of Excel interested in exploring data science and AI tools
- Professionals working with large or complex datasets
- Advanced Excel learners seeking to future-proof their analytical capabilities
Download Course Brochure
About your trainer
Carolina Lago
Carolina is the Managing Director at Tactic Financial, where she helps SMEs and finance professionals enhance their skills through corporate training and hands-on advisory services. With over 15 years of experience in Financial Planning & Analysis (FP&A) and a Master's degree in Accountancy specializing in Data Analytics, Carolina's expertise spans multiple industries and global locations. Recognizing a gap in the market for flexible yet robust financial models, she developed the TACTIC Financial Modeling Framework, designed to create versatile and adaptable models with solid calculations. Carolina's multi-industry experience and strong academic background make her a strategic planner capable of interpreting data to drive actionable insights and business success.
What people think of
Carolina Lago
Course contents
Carolina Lago
Training requirements
Intermediate Excel skills and a basic understanding of data analysis concepts are recommended. No prior coding experience required.
Each delegate must bring their own laptop with their preferred version of Excel installed.
Buy ticket
Buy 365-Day Digital Masterpass
If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
.png)