The Hogwarts Excel trick đŸȘ„

Wingardium Leviosa your data out of Excel ✹

February 12, 2026

Hey there! AI is moving fast right now. Like, blink-and-you’ll-miss-it fast. New updates are dropping every other day, and if you’re feeling overwhelmed
you’re not alone. 😅

The good news? That’s exactly what my AI Bundle is for! It’s packed with 250+ bite-sized training videos and ready-to-use prompts across three courses—AI with Miss Excel, Advanced AI with Miss Excel (launching soon), and Copilot with Miss Excel (launching soon). By the end of these courses, you’ll: 

  • Turn your overwhelm into clarity and confidence 

  • Save hours at work (and get ahead on all your projects!) 

  • Become the person your boss can’t stop talking about đŸ˜‰

Want 20% off the bundle of courses designed to help you level up your AI game? Use the code WORKBOOKAI and get going now.

The Hogwarts Excel Trick Hermione Would Approve Of đŸȘ„

POV: You landed your dream job at Hogwarts: managing data. You’ve got your butterbeer, cozy office, and the good life. Then, one day, your boss asks you, “Could you fill out some data on our student, Luna?” 

Easy! All you have to do is manually pull Luna’s information: 

Five minutes later: “Can you do the same for Ron?” Then it’s Cedric. Fred. Ginny. Before you know it, you’ve spent 20 minutes playing human search engine. đŸ« 

If you’re extracting data like this manually, it’s going to take forever. Luckily, you can just use =DGET: a function that pulls specific data from a table based on criteria you set. 

Here it is in action: 

Step 1) Type =DGET

Step 2) Select your entire data table (including the headers) 

Step 3) Add dollar signs between each cell reference (the shortcut for this is F4 if you’re on a PC!) 

Step 4) Type a comma, then click the header of what you want to extract (like “Status”) 

Step 5) Add another comma, then select your criteria cell. In our case, that’s B2 and B3. Add dollar signs again to lock the criteria reference!

Step 6) Close the formula and drag it across 

✹ Here’s the real magic: If you change the student name in your criteria cell or header (like from “Status” to “Grade”), the formula will automatically adjust. 

Jump on AI Before It’s Too Late! 

Do you know what AI reminds me of? The early 2000s internet boom. 🌐

The people who went all-in on learning how to use the internet—building websites, writing code, blogging—became indispensable leaders with skyrocketing careers. 

AI is that same moment all over again. Except this time? You’re not late. You’re actually early! Enter: My AI Bundle, packed with 250+ bite-sized training videos and ready-to-use prompts across three courses—AI with Miss Excel, Advanced AI with Miss Excel (launching soon), and Copilot with Miss Excel (launching soon).

This bundle is designed to get you up to speed fast with easy, digestible lessons that make AI feel less like a technical mystery and more like your new favorite work tool. Don’t just take my word for it âžĄïž

Ready to turn AI into the career accelerant you know it can be? Use code WORKBOOKAI for 20% off!

3 Dead Giveaways for ChatGPT 💀

The other day, I was reviewing applications for a role on my team when I had dĂ©jĂ  vu. Three different cover letters in a row all said some version of: “It’s not about the tasks. It’s about the impact.” 

That’s when it hit me: ChatGPT wrote these cover letters. đŸ€–

The "It's not X, it's Y" sentence structure is everywhere now, from emails to LinkedIn posts to (apparently) job applications. Once you see it, you can’t unsee it! 

But this sentence structure is just one tell. There are three other ChatGPT giveaways you should know about, because if I can spot them? So can your boss. 👀

  1. Framing phrases 

Phrases like “This shows that
” or “This highlights the importance of
” are the ultimate filler! ChatGPT loves to over-explain it instead of letting the facts speak for themselves. 

  1. Wonky formatting 

Extra spaces between sentences. Commas instead of colons. Words bolded for no clear reason. These little formatting quirks signal that the text was probably copied and pasted directly from ChatGPT. 

  1. “Not ____. Not ____. Just _____.” 

Another phrase structure I’m seeing everywhere lately. (e.g., “Not perfect. Not polished. Just real.”) ChatGPT is having a moment with this dramatic three-part rhythm. 

And of course, we can’t forget the trusty em dash—the OG giveaway that started it all. 😅 

P.S. Looking for a more in-depth explanation on these AI giveaways? Watch my video on Instagram!

Thanks for reading! If you had a 9 AM meeting this Monday morning after the Super Bowl
here’s to hoping the rest of your week makes up for it. 💚

Stay Exceling,

Kat