- The Workbook
- Posts
- My boss thought this would take me all day... 🙃
My boss thought this would take me all day... 🙃
...but with this function it won’t!
Hi there! I just left Nashville, where I spent the weekend with some of the most incredible women I know for a little networking meet up. 💚 Every time I go to one of these events, I leave bubbling with ideas. Now? We execute!
Starting with this: The Miss Excel Copilot Course!
I’ve been building this for months, and I’m so excited to finally get it into your hands. If you’ve been watching Copilot from a distance and thinking: “I know this could change everything for me at work…but where do I even start?” This is where.
We cover it all: How to use Copilot across Excel, PowerPoint, Teams, Outlook, and Word. Ready to get up to speed and save hours at work? Use the code COPILOT20 for 20% off!


From ‘This Will Take All Day 😩’ to ‘Already Done 😎’
Imagine you open your inbox to find a hefty spreadsheet from your sales manager. It’s got every salesperson, their region, and their sales numbers. And the email? Just one sentence:
“Tell me how much each region made by EOD please.”
No pressure. 🙃

Good thing you know a shortcut. 😉 Here are two formulas that’ll turn this from a 20-minute headache to a 20-second fix:
First: Let’s pull each division with =UNIQUE. This function returns a list of unique values from a range or array.
Step 1) Under your Division column, type =UINQUE(
Step 2) Select the Division column (hit Ctrl + Shift + ↓ to select all!)
Step 3) Press F4 to lock your selection
Step 4) Close the parentheses and hit Enter

Now, let’s calculate how much each division made with =SUMIF:
Step 1) In your desired cell, type =SUMIF(
Step 2) Select the original Division column (press F4 to lock it!)

Step 3) Select your criteria (the column UNIQUE just populated for you)
Step 4) Select the sum range and press F4
Step 5) Close the parentheses, hit Enter, and drag down. Done!

Not bad for a day’s work! (Or in this case, 20 seconds of it 😅)


Master Microsoft Copilot With Miss Excel!
Stop me if this sounds familiar. 👀 You’ve seen Copilot. You know it could make your work easier. But each time you open it, you’re not sure where to start. So you tell yourself you’ll learn it “tomorrow.” Tomorrow comes and goes. 🙃
Meanwhile? That little voice in the back of your head worries that everyone is figuring it out faster than you.
But it doesn’t have to be this way! The Miss Excel Copilot Course will help catch you up to speed and seriously level up your career. By the end of this course, you’ll:
Have smarter workflows that save you hours every week
Nail rock-solid processes across Excel, Word, PowerPoint, Outlook, and Teams
Go from feeling behind to feeling like the most prepared person in the room 😎
While our Copilot Course is brand new, we’ve launched AI courses before—and making AI clear and approachable is kind of our thing, as our past students will tell you!
If you’re ready to get ahead of the AI curve—to finally impress your boss and turn “someday” into “today”—you can get 20% off with the code COPILOT20. Hope to see you inside!


Why Your Work Feels ‘Off’ 🎨
“I hate being in my Excel Beginner Era. 😭”
That’s what one of my good friends told me the other day. She was merging cells 24/7, hard-coding values into formulas, and constantly forgot to remove duplicates.
The worst part was that she could tell something was off. Every time she’d finish a spreadsheet, she’d know in her gut it could be better. “How long until I’m actually good at this?” she asked.
Turns out, producer Ira Glass has a name for that feeling: The Taste Gap. It’s when you get into creative work because you have taste (you know what good looks like), but your skills aren’t there yet. That distance between what you see and what you make is the uncomfortable gap.
(And yes—Excel counts as creative work! From elegant formulas to colorful dashboards, you can get pretty creative in Excel. And have you seen the Michelangelo of Microsoft? 🧑🎨)
So how do you close that gap? Ira’s answer: Produce. A lot. The more you create, the more chances you give your skills to catch up to your taste.
Whether you’re creating PowerPoints, TikToks, or spreadsheets, the solution is the same: Practice! Bit by bit, the taste gap closes. And one day, you’ll look at something you made and think: That’s the one. 💫


The shortcut that writes your numbered list (so you don’t have to). 👀
16K people just made =COUNTIF their new BFF. 👯
Instead of spending $150+ on a new monitor, try this Excel tip.
How to write an unignorable cold email to land new opportunities. ✨
These AutoSum shortcuts will save you an embarrassing amount of time. 🫠


Thanks for reading! Fun fact: In 2020, scientists had to rename 27 human genes because Excel auto-corrected their names into dates, causing widespread confusion in published genetic research. 🧬
Turns out Excel has been in our DNA longer than we thought. 😂
Stay Exceling,
Kat

