The spell every spreadsheet needs 🪄

Hi there! There are some things in life that come with an eternal repeat button: Vacuuming. Dishes. Laundry. (So. Much. Laundry. 🫠) 

But Excel reports shouldn’t be one of them! With Dashboards and AI, you can build your report once, and from then on it refreshes automatically with every new batch of data. 

The result? Hours of your life back and a boss wondering how you make it look so effortless. (No need to tell them it practically runs itself. 😉) 

Come join my free live class and I’ll show you how it’s done! Save your spot before seats run out, and I’ll see you there. 💫

The Spell for Stress-Free Weighted Scores 🧙

POV: Final grades are due at midnight, and you’re the professor stuck calculating them. But every class—from Duels to Potions to Charms—counts for a different percentage of the total.

Oh no. 😖 Unsure, you start typing the formula, cell by cell: 

Put down the wand. 🪄 There’s a better way with SUMPRODUCT! This function returns the sum of the products of corresponding ranges or arrays. In plain English? It takes each score, multiplies it by its matching weight, and adds it up for you. 

Here’s how it works: 

Voila! Every weighted score, calculated faster than you can say Wingardium Leviosa.

Become a Powerhouse at Work With AI and Dashboards ⚡️ 

No matter your industry, the challenge is the same: turning those mountains of data into a dashboard that makes sense at a glance. 🫠 

That's where AI and Dashboards come in! Once you know how to use both, those mountains of data stop being a hassle and start being your secret weapon: reports that build themselves and save hours of your time.

That’s exactly what we’re covering in my free live class! In just one hour, you’ll learn how to:

• Build a report once that updates itself automatically (no more Monday morning rebuilds)

• Save 3+ hours every week with automations in Copilot, ChatGPT & Claude

• Spot key trends from your data in seconds, so you're the one with the answers in every meeting

“But what if I’m non-techy?” I’ve got you. 🤝 This class is built to be beginner-friendly and easy to follow, and previous attendees like Megan can confirm!

Can’t wait to see you there!

Do You Like What’s Making You Tired? 

The other night, I face-planted onto my couch. 🛋️

It had been a week at Miss Excel HQ. We were onboarding an incredible new social media manager, I’d just given a presentation for Girls Mentorship, and my book had me writing every spare minute. 

So when my partner Mike asked me: “Are you tired?” …the dramatic couch flop sort of answered for me. 😅 But then I also remembered what actress (and absolute icon) Anne Hathaway said.

She was at The Devils Wears Prada screening when an interviewer asked how exhausted she must be from this press whirlwind. Her response? 

Oof. Reframe unlocked. 🔓

That’s exactly where I’ve landed. Yes, I’m tired. But I couldn’t be more grateful for what we’re building at Miss Excel. 💚

So the next time you find yourself horizontal on the couch, ask yourself: Do you like what’s making you tired? Because as the quote goes: “What a privilege to be tired from work you once begged the universe for.” ✨

• “This is my favorite Excel function” says a comment under my video! 

• If you're painting the background white to hide gridlines…let’s chat.  

• Keep hitting your usage limits in Claude? Try these five easy fixes! 

• 10 ChatGPT shortcuts every 9-5er should know. 👀(No. 3 is my fav!)

• Don’t watch this Pivot Chart tip (unless you want to impress your boss 😉).

Thanks for reading! One more thing before you go: I’ve given my Instagram (@kat_norton) a little refresh! ✨ Think of it as your new corner of the internet for all things energetics, mindset, and productivity to help you find Your Untapped Edge. 

Come hang out! Let’s make this chapter our best one yet. 🤍

Stay Exceling,

Kat