Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Python in Excel For The Real World
Section 1: Getting Started with Python in Excel
Welcome! What You’ll Learn in Python for Excel (3:42)
⚙️ How to Use the Platform for Best Learning Experience
How to Check If You Have Python in Excel (0:47)
What is Python? (1:58)
Warm up: Inputting Python Code (4:33)
📥 Download Files & Cheat Sheets
🔍 Looking for a Specific Topic? Use the Transporter
Section 2: Advanced Data Analysis for Python Beginners
Your First Python Formula – Is THIS Even Possible?! (10:18)
How Python in Excel Works (Behind the Scenes Explained) (4:22)
How to Find Valid Python Function Parameters (4:15)
Build a Quick Python-Powered Dashboard in Excel (11:46)
Bonus Tip - Use a Swarmplot to Spot Outliers Instantly (2:32)
Free vs. Premium Python in Excel: What’s the Difference? (4:43)
💪 Challenge: Finding the Slowest with a Violin Plot (6:46)
Use AI to Help with Python – Copilot & ChatGPT (4:12)
🎯 Quiz - Python Basics in Excel
📝 Key Takeaways from Your First Look at Python in Excel
Section 3: Core Python Skills for Working in Excel
What are Dataframes? (plus describe them) (10:00)
How to Find What You Need in Pandas (value_counts, mean, etc.) (10:13)
Naming Your DataFrames and Column Shortcuts (6:00)
Why Knowing Objects, Methods & Properties Saves You Hours (8:43)
Python Rules You Need to Know: Return Values, Order etc. (8:54)
Python Editor Tips - References, Help & More (8:30)
Connect to External Data in Python – Excel Files, CSV, etc. (9:35)
💪 Challenge: Import Data From CSV Into a DataFrame
✅ Solution: Import Data From CSV Into a DataFrame
Keyboard Shortcuts to Work Faster with Python in Excel (3:07)
🎯 Quiz - DataFrames & Pandas
📝 Key Takeaways - Core Python Skills (0:50)
🎁 Help Someone Learn - and Save on Your Next Course
Section 4: Real-World Data Fixes With Python
Excel Can’t Fix These Dates... But Python Can (7:34)
Extract Info From Dates - Quarter, Leap Year, Custom etc. (8:16)
Turn Columns into Rows with melt (Unpivot) (8:22)
Group and Summarize with groupby (7:40)
💪 Challenge: Grouping to Find the Top Complaint (External Data)
✅ Solution: Grouping to Find the Top Complaint (8:54)
Grouping Dates by Year, Quarter, Month, Week (8:57)
Create Pivot-Like Summaries with pivot_table (7:36)
📝 Key Takeaways - Data Fixes
Section 5: Half-Time Tactics for Python in Excel
Do Cells Go Inside or Outside Parentheses? (7:09)
🎯 Quiz - Python Logic and Referencing
Filter Data with One Short Line (9:48)
How to Add Calculated Columns to DataFrames (6:13)
Create Conditional Columns – The Python Way to Write IF (9:02)
💪 Challenge: Conditional Logic Tested
✅ Solution: Conditional Logic Tested
📝 Key Takeaways - Filtering and Adding Columns
Section 6: Smarter Charting with Python in Excel
Seaborn vs. Matplotlib - What Excel Users Should Know (10:30)
Bar Charts: Excel vs. Python - When to Use Each Tool (9:46)
Font Size Fixes - Making Python Charts Easier to Read (2:49)
Customizing Charts with Matplotlib (and AI) (9:41)
Smart Charts That Aggregate Automatically (Seaborn) (4:02)
💪 Challenge: Time Tracking Analysis (External Data)
✅ Solution: Time Tracking Analysis (External Data) (8:57)
💪 Bonus Challenge: Daily Averages Breakdown
✅ Bonus Solution: Daily Averages Breakdown
Switch Chart Types with a Drop-Down – No VBA Needed (9:34)
Bullet Charts Inside Cells (15:40)
🎯 Quiz - Charting with Python
📝 Key Takeaways - Smarter Charting
Section 7: Level up Tactics
Python Functions (The Blueprint for Reusable Code) (11:16)
Bar Chart Function to Include Data Labels (8:48)
Mastering if, else - Conditional Logic in Python (11:12)
F-Strings in Python - Combining Text & Numbers Easily (7:30)
Combine Data Easily with concat (7:34)
💪 Challenge: Combine & Summarize by Region Dropdown
✅ Solution: Combine & Summarize by Region Dropdown (6:39)
Importing Python Libraries (Word Cloud Example) (10:01)
(Don't Skip) Core Python Library - Everything Starts Here (7:42)
Data Structures - The Key That Makes Everything Work (12:14)
🎯 Quiz - Level Up
📝 Key Takeaways - Level Up Tactics
Section 8: Reveal Patterns and Insights with Seaborn Visuals
Start Here: Project Overview & Data Reshape (5:04)
Bar Chart Toggle with Checkbox (Smart Python Trick) (10:33)
Trends Over Time with relplot (Multiple Charts) (10:07)
boxplot & stripplot – Spot Outliers and Variability (5:33)
catplot - One Line, Many Charts (5:45)
pairplot - Discover Hidden Data Connections (5:59)
Correlation, Heatmap, and lmplot - Explore Relationships (11:29)
💪 Challenge: How Do Meetings Affect Productivity?
✅ Solution: How Do Meetings Affect Productivity?
📝 Key Takeaways - Reveal Insights with Seaborn Visuals
Section 9: Time Series & Forecasting
Create Dynamic Rolling Averages in Excel with Python (9:52)
Exponential Smoothing: A Better Way to Spot Trends (6:21)
Calculate Growth Rates in Python (4:05)
Plot Multiple Charts in One: Growth + Sales (w/ Copilot & ChatGPT) (7:07)
Forecast Trends with Holt-Winters (Exponential Smoothing) (11:13)
Forecast with ARIMA (include Seasonality) (14:21)
Which Forecasting Model to Choose? (Plus More Resources)
📝 Key Takeaways - Time Series & Forecasting
Section 10: Machine Learning
Machine Learning in Excel - What You Need to Know First (5:10)
Anomaly Detection with Isolation Forest (12:28)
Smarter Anomaly Detection with Isolation Forest (Using Context) (11:05)
Clustering with K-Means (Find Natural Segments) (12:54)
💪 Challenge: Which Salaries Raise Red Flags?
✅ Solution: Which Salaries Raise Red Flags?
🎯 Quiz - Machine Learning
📝 Key Takeaways - Machine Learning
❓🗝️ Q&A Resource Hub
🔐 Answer Vault
🎁 BONUS 1: Python Vs. Power Query
Power Query or Python? Use This Based on Your Scenario (3:48)
Cleaning the Same Data in Python and Power Query (10:19)
Watch Out: Power Query Nulls Break Python Cleaning
Combining the Same Data in Python and Power Query (7:34)
Python Cleaning Features That Beat Power Query
Extra Resources to Learn Power Query
🎁 BONUS 2: CoPilot & ChatGPT
AI & ChatGPT - Top Tips for Python in Excel (9:17)
Copilot - Best Tips for Python Users (16:22)
AI Prompt Pack
🎁 BONUS 3: Code Book
The Copy-Paste Code Book
🥳 Wrap-Up & Next Steps
Closing - Where Python Fits In (2:29)
✍️ Got a Minute? We'd Love Your Feedback
My Favorite Resources
🏅 You Earned It - Now Show It Off (0:40)
Cleaning the Same Data in Python and Power Query
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock