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