- Published 5/30/2025
- 1st Edition
- Online video 978-0-13-546502-8
3 Hours of Video Instruction
This course introduces the exciting integration of Python into Excel, allowing you to leverage Pythons capabilities directly in your spreadsheet workflow.
Python-Powered Excel walks learners through the exciting integration of Python into Excel, allowing users to leverage Pythons capabilities directly in their spreadsheet workflow. By combining these two powerful tools, users can build custom functions, automate data processing, and unlock analysis methods that go far beyond Excel's native features.
Experienced trainer Shaun Wassell provides the hands-on training you need, whether youre looking to streamline data tasks, integrate external data, or build complex models, this course provides the training you need to succeed.
Skill Level:
Learn How To:
- Write and execute Python code directly within Excel
- Refer 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
Course Requirements:
- Basic knowledge of Microsoft Excel
- Familiarity with basic programming concepts
Who Should Take This Course:
- Business Analysts, Data Analysts, Financial Analysts
- Accountants
- Project Managers
- Power Users
About Pearson Video Training:
Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.
Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.
Table of Contents
Introduction
Lesson 1: Learning Basic Concepts
1.1 Learn reference cells in Python
1.2 Learn reference ranges in Python
1.3 Learn how to reference tables
1.4 Control cell output
1.5 Deal with errors
Lesson 2: Formatting and Styling with Python
2.1 Format and style spreadsheets with Python
2.2 Demo: Insert and hide rows
2.3 Demo: Manipulating borders
2.4 Demo: Coloring by value
2.5 Demo: Creating custom themes
Lesson 3: Building Custom Excel Functions
3.1 Set up custom functions
3.2 Write your first custom function
3.3 Demo: Grade calculator
3.4 Demo: Income tax calculator
3.5 Demo: Investment growth calculator
3.6 Demo: Currency converter
Lesson 4: Learning Data Scraping and Integration
4.1 Learn the basics of data scraping
4.2 Demo: Convert HTML data to a spreadsheet
4.3 Demo: Create a scrape custom function
4.4 Demo: Load up-to-date values from sites
Lesson 5: Incorporating Generative AI
5.1 Let Generative AI edit spreadsheets
5.2 Query Generative AI APIs
5.3 Demo: Translate text
5.4 Demo: Automatic image generation
5.5 Demo: Write emails automatically
Summary