How to Break Apart Upper & Lower Case Text with Power Query

https://youtu.be/WNdqlCMsroE

Struggling with messy text like “JOHNsMiTH” in Excel or Power Query? In this quick tutorial, learn how to split text into uppercase and lowercase parts using custom Power Query logic—fast, clean, and easy. Perfect for cleaning names, form inputs, and messy CSV imports.

This method saves time and improves data accuracy for Excel users and data analysts. Boost your data cleaning skills and get professional results with this simple trick!

Duplicate & Customize Tables Across Worksheets in Seconds

https://youtu.be/0O6g3W5V-wY

If you're a student drowning in assignments or a corporate warrior juggling deadlines, mastering Microsoft Excel isn't optional—it's your secret weapon. This isn't one of those “watch me click things for 45 minutes” tutorials. We're slicing through the clutter to show you what actually matters: formulas that don’t make your brain leak, pivot tables that actually pivot, charts that don’t look like 2005 PowerPoint rejects, and shortcuts that’ll make your keyboard start smoking.

Whether you're managing grades, budgets, presentations, or an existential crisis over your to-do list—this video is for you. Clear, fast, slightly snarky, and totally useful. Get ready to learn Excel like your job depends on it (because, let’s be real, it probably does).

📊 Perfect for: College students, interns, analysts, anyone who's ever pretended to know Excel in a job interview.

How to Use REGEX in Excel (Complete Guide for Smarter Data!)

https://youtu.be/sogoDpuf4Kw

Think REGEX in Excel is only for tech wizards or keyboard jedis? Yeah, no. If you've ever had to wrestle with busted emails, funky phone numbers, or text strings that look like a cat walked across the keyboard—this one’s got your name on it.

In this video, I’ll break down exactly how to use Excel’s REGEX functions to clean up messy, inconsistent data without crying into your coffee. No PhD in computer science required. Just straight-up, real-world examples that make “Find & Replace” look like your grandma’s knitting tool.

🧼 Here’s what you’ll walk away with:

How REGEX can fix emails, phone numbers, and text chaos with surgical precision

Real-life examples that’ll turn junk data into spreadsheet gold

Why REGEX is the Excel upgrade you didn’t know you needed (until now)

Still manually patching up bad data like it’s a 1998 Clippy tutorial? Smash that play button. Let Excel handle the mess—you’ve got better things to do.

Control Multiple Pivot Tables with One Slicer in Excel

https://youtu.be/b7hGDNyMWgw

Trying to filter multiple pivot tables in Excel at the same time—without losing your sanity? You’re not the only one. In this quick tutorial, I’ll show you how to use a slicer (a.k.a. Excel’s way of making filters way less painful) to sync filters across pivot tables automatically. No more toggling each one like it's 2003. Whether you're building dashboards for coworkers, clients, or your own peace of mind, this trick will save time and frustration. Perfect for anyone who's ever screamed, "Why won’t these pivot tables just talk to each other?!"

How to Delete Specific Characters in Power Query

https://youtu.be/W5q7D_sMoyo

Learn how to clean text data in Power Query using Text.Select and Text.Remove—no coding required. In this step-by-step Power Query tutorial, you’ll discover how to remove unwanted characters from text columns in Excel or Power BI. Whether you're dealing with extra spaces, special symbols, or strange characters from messy data imports, this video shows you how to clean it all up fast. We’ll cover how to use Text.Select and Text.Remove functions to streamline your data cleaning process and keep your queries running smoothly. Open Power Query and follow along—your spreadsheets will thank you.

Excel + M365 Copilot: First Impressions You NEED to See

https://youtu.be/LOHjjC3Mnak

Curious about how Microsoft 365 Copilot works in Excel? Here's what really happens when AI meets spreadsheets. In this video, I share my first hands-on experience using Copilot in Excel, exploring how it handles tasks like generating formulas, analyzing data, and suggesting insights—all with just a few prompts. It's not exactly magic, but it does make some of Excel’s most tedious tasks way easier. I’ll break down what worked, what felt clunky, and the moments that actually impressed me. If you’ve been wondering whether Copilot in Excel is worth using for real-world tasks or just another shiny feature you’ll ignore, this one’s for you.

Stop Using INDEX MATCH! Try This Two-Way XLOOKUP Trick Instead

https://youtu.be/TkncclDZliM

Want to do two-way lookups in Excel without getting tangled in helper columns or INDEX MATCH gymnastics? In this video, you’ll learn how to use XLOOKUP for advanced 2D lookups—referencing both rows and columns with one clean formula. We’ll walk through the XLOOKUP syntax, break down the logic step-by-step, and plug it into a real-world example using sales reports and financial data. Whether you're building dashboards or wrestling messy spreadsheets into submission, this trick will seriously upgrade your Excel skills—fast, accurate, no fluff.