Python-Powered Excel: Boost Your Excel Productivity with the Power of Python by Microsoft Press

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.

Learning objectives
Write and execute Python code directly within Excel.
Reference Excel cells, ranges, and tables, and then perform advanced calculations on them using Python code.
Automatically read from and write to Excel spreadsheets using Python scripts.
Build custom Python-powered Excel functions for tailored data analysis.