The chocolate cure for multi-criteria in Excel 🍫

Hey! Did you know that most people only use Excel at 10% of its potential, according to the Financial Post? 🤯 That means 90% of Excel’s time-saving, productivity-enhancing, career-boosting magic sits untouched on your computer. 

Let’s change that, shall we? This is your last chance to join my free Advanced Excel Functions class to unlock the best of what Excel has to offer before it’s gone! 

In just one power-packed hour, you’ll become the go-to problem solver your team can’t live without. And when you’re one of few Excel experts, you get the upper hand on promotions, raises, and more. 👀 

The Multi-Criteria Candy Search 🍫

It’s a Monday morning, and you cruised through your to-dos. Just as you start debating whether it’s socially acceptable to unwrap your lunch at 10:49 am, your boss pings you: 

“Can you pull the price of a Hershey’s in this spreadsheet real fast?” 

“No problem! I’ll just use XLOOKUP,” you think. But when you open the file, you realize this isn’t just any Hershey’s. You need to find the exact price for a specific candy type based on its size and ingredients.

Multiple criteria? That’s not in your usual toolkit. 🫠

Don’t panic! Here’s how to use XLOOKUP to sort through all those conditions at once:  

Multi-criteria searching is just one of dozens of powerful advanced functions in Excel. Come join my free Advanced Excel Functions class so you can blaze through the workday and save over 144 hours a year (more than enough time to enjoy your lunch break, no matter what time you take it 😉). 

Forget Everything You Know About Excel Classes 🙇

“Excel is pretty boring.”

I used to hear this all the time. But the truth is it’s not Excel itself that’s boring: It’s the way most people use it that is!

Because when you finally get Excel—like when you build a formula that saves you hours or design a spreadsheet that wows your boss—that’s anything but boring. It’s actually pretty thrilling.

That’s exactly what you’ll find in my free Advanced Excel Functions class (I call them Excel parties for a reason! 💃 ). But don’t just take my word for it—here’s what past attendees had to say:

Come join the party?

What Taxis Can Teach Us About Productivity 🚕

Back in the ’90s when people actually hailed cabs, economists wanted to know how taxicab drivers chose how to work. 30+ years later, and their findings could help you save hours of frustration while boosting your output. 👀

Let me explain →

Most taxi drivers set a fixed income goal—say, $120—and only stopped driving once they hit that target, regardless of how long it took, researchers found. 

On average, they’d drive about eight hours. But this number varied—on busy days when it rained or the subway was down, drivers might hit their goal in just four hours. But on slow days? That might take closer to 12.

It sounds logical, but drivers worked the most hours precisely when their earning power was lowest! If the drivers flipped their strategy—driving longer on high-earning days and cutting losses on slow ones—they could have earned 5-10% more. 

As someone big on harnessing our energy, this really resonates. I get so much more done when I ride a flow wave for as long as possible. But when I’m feeling blah, pushing myself almost never leads to my best work.

Of course, not all jobs allow for this flexibility, and it’s important to know the difference between forcing yourself and being disciplined. But capitalizing on your high-productivity hours can be such an unlock. 

So the next time you find yourself wrestling with an Excel formula for an hour when it should take minutes (I’ve been there 😅), don’t feel bad if you need to hit pause and return when your mental meter is running at full capacity. 💚

• Reason #976 why TEXTSPLIT is one of the best functions. ❤️‍🔥

• Got a super messy spreadsheet from your client? Try this. 

• Two ridiculously simple quotes to get you out of your own way. 

• If you hate typing emails, you’ll love this 19-second Outlook hack. 

• This is the most passive aggressive thing I’ve ever seen inside a spreadsheet. 👀

Don’t forget to join my free Advanced Excel Functions class! This is your last chance to register for my most-requested class ever before it’s gone. 

If you can’t make the time slots work, register anyway to catch the replay! 

Stay Exceling,

Kat