Python in Excel: 1-minute Hacks You Can Use Today

In this video, you'll learn how to use Python in Excel to clean data, switch columns into rows, and uncover insights—all in under a minute per task. I’ll show you 3 quick tricks that solve common Excel problems: 🔄 Fix broken or inconsistent dates 🔁 Unpivot data from columns to rows 📊 Create...

Intermediate - 10 min - AI & Data - Leila Gharani

The full course: Learn Excel & Sheets free

What you'll need

Laptop stand: Screen at eye level for long study sessions.
Noise-cancelling headphones: Focus through long video lessons.
Second monitor: Video on one screen, practice on the other.
Wireless keyboard and mouse: Comfortable for hours of typing.

Books

Excel Formulas and Functions for Dummies by Ken Bluttman - View on Amazon
Storytelling with Data by Cole Nussbaumer Knaflic - View on Amazon
Excel VBA Programming For Dummies by John Walkenbach - View on Amazon
Interactive Computing Series by Kenneth C. Laudon - View on Amazon

Next lessons

3 Cool Effects You Did NOT Think are Possible in PowerPoint | Morph (11 min, Leila Gharani, Intermediate)
Excel for Data Analytics - Full Course for Beginners (660 min, Luke Barousse, Beginner)
Stop Writing Huge Excel Formulas. (Use ONE DOT Instead) (10 min, Leila Gharani, Intermediate)
Pictogram Charts in Excel: Add Icons to Bars [Rounded + Dynamic] (16 min, Leila Gharani, Intermediate)
The Excel Timeline chart you'll actually keep using (free template included) (11 min, Leila Gharani, Intermediate)
14 New Excel Functions: TEXTSPLIT, VSTACK, TAKE and More (11 min, Leila Gharani, Intermediate)
Microsoft PowerToys Tutorial: Free Tools for Windows 11 (13 min, Leila Gharani, Intermediate)
TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included (13 min, Leila Gharani, Intermediate)