EARTH WEEK
Go paperless and save 40% on eligible eBooks, 70% on video now through April 26. Shop the sale.
Register your product to gain access to bonus material or receive a coupon.
Video accessible from your Account page after purchase.
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:
Course Requirements:
Who Should Take This Course:
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.
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