- The Workbook
- Posts
- One formula = 10 hours of your life back 😱
One formula = 10 hours of your life back 😱
Master the LOOKUP function in seconds!
Hey there! Most people approach dashboards the wrong way. They open Excel, plug in some numbers, get confused, and the voice in their head goes:
Ugh. I’ll never be technical enough. This isn’t for me.
But dashboards aren't just reserved for the Excel pros or data analysts. They're for anyone ready to stop wasting hours and start making their work speak for itself. 🙌
That's what my free Excel Dashboard training gives you! In just one hour, you'll learn how to build dashboards that turn your data into clear, visual insights (without the frustration or guesswork!).
Ready to make your data impossible to ignore? Click below to register!


Save 10 Hours a Year With One Excel Function 🎒
Pop quiz: If it takes 10 seconds to manually type in each student's letter grade, how long will it take you to grade 100 students?

Answer: About 17 minutes.
Now, 17 minutes might not sound like much. But what if you're grading tests every week? Over a nine-month school year, that's about 36 tests. 36 tests × 17 minutes = 10.2 hours of typing.
I don't know about you, but I can think of about 1,000 better ways to spend 10 hours. 😅
Fortunately, Excel has our backs. Meet LOOKUP! Just set your grade thresholds (90, 80, 70, 60), and this handy function will assign the right letter grade for any score that falls in between.
Here it is in action:
Step 1) Type =LOOKUP( and select the lookup value. For us, that’s C4

Step 2) Select the lookup vector and press F4 to lock them with dollar signs
Step 3) Select the result vector and press F4 again

Step 4) Close your formula and double-click to copy down!

10 hours saved? That deserves an A+. 💯


Get So Good at Excel People Think You Have a Data Team 👀
Imagine building dashboards that are so clean, so intuitive, and so effortlessly clear that, when you present them, someone leans over and whispers: Who built this for you?
And you get to smile and say: I did.
That's what we’re going for in my free Excel Dashboard Class! After spending just one hour together, you’ll:
✔️ Transform messy data into clear visuals so you can spot trends instantly (no more endless scrolling)
✔️ Make smarter, faster decisions with charts that update on their own
✔️ Automate and enhance your reporting to eliminate manual updates
But don’t just take it from me! Here’s what a previous attendee had to say:
Save your spot before seats fill up! ⬇️


The Power of Wonder 😯
Recently, I listened to an episode of To Be Magnetic (my favorite podcast!) with Monica Parker, author of The Power of Wonder. That conversation got me thinking: When was the last time I truly felt wonder?
It was in 2022, when I visited a tiny (three-miles-long-tiny) mystical island off the Western coast of Scotland called Iona. Fun fact: Iona has more sheep than people!
I spent that entire weekend in awe—feeling inspired, curious, and aware that the problems I'd been stressed about back home were so much smaller when compared to how beautiful and vast the world is.
This isn’t a coincidence: There’s real science showing that experiencing wonder can increase creativity and gratitude while reducing stress and impatience.
But awe doesn’t have to be reserved exclusively for mystical islands. (As much as I would love to relocate to Scotland, Miss Excel HQ can't operate from a place with more sheep than spreadsheets. 🐑)
You can find awe in the everyday moments. Entrepreneur Amanda Goetz pulled together six ways to find awe in your day-to-day. One example I loved? Going on awe walks:
“Once a week, 20 minutes, no podcasts. Look for one thing that makes you feel tiny (big tree, endless sky, city skyline) and one thing that makes you feel the beauty in human connection (people hugging, neighbors helping each other, a barista knowing someone in their coffee shop).”
This idea of pursuing wonder and awe flips productivity advice on its head. Usually, it's all about doing more. But sometimes, the best thing you can do is pause and remember you're part of something way bigger than your to-do list. ✨


The Excel shortcut that turns your data into tiny charts instantly. 📊
Do you know the two magic keys that auto-fill today's date and time?
How treating yourself like a 4-year-old helps with your goals. 🙇
The formula that generates 365 days without typing a single date.
“This is brilliant and so simple!” says a comment under my video on bar charts in Excel.


Thanks for reading! Before you go, don’t forget to grab your free seat for my Excel Dashboard Class! 💚 The last time I hosted a dashboards class back in July, it was one of my most popular classes ever!
Spots are going fast, so grab yours before they're gone!
Stay Exceling,
Kat

