Python-Powered Excel: Boost Your Excel Productivity with the Power of Python by Microsoft Press
With Shaun Wassell and Microsoft Press
Liked by 105 users
Duration: 3h 32m
Skill level: Intermediate
Released: 7/11/2025
Course details
Description
What is this course about?
This course covers the exciting integration of Python into Excel, showing you how to leverage Python’s capabilities directly into your spreadsheet workflow. By combining these two powerful tools, instructor Shaun Wassell demonstrates how to build custom functions, automate data processing, and unlock analysis methods that go far beyond Excel's native features. With live training, you’ll learn the basics of Python, as well as how to work seamlessly across Python and Excel, using Python for both in-cell calculations and broader spreadsheet editing. Whether you’re looking to streamline data tasks, integrate external data, or build complex models, this course provides the foundational skills you need.Note: This course was created by Microsoft Press. We are pleased to host this training in our library.
Objectives
What will I be able to do by the end of this course?
- Write and execute Python code directly within Excel.
- Reference and manipulate Excel cells, ranges, and tables using Python.
- Automate reading from and writing to Excel spreadsheets with Python scripts.
- Build advanced, custom Python functions for detailed data analysis.
- Integrate data scraping and generative AI techniques to enhance spreadsheet capabilities.
Audience
Who is this course for?
- Data analysts
- Business analysts
- Power users
Prerequisites
What do I need to know before taking this course?
- Basic understanding of Excel and its functions
- Familiarity with Python programming basics
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructors
Learner reviews
Contents
What’s included
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.