This might be your next career path 📂

Hey there! I’ve been in full ✨ creative mode ✨ lately, brainstorming fresh Excel ideas for you. I have been dying to bring you guys a new mini-course! So, I’d love to get your two cents: Which one would you like to see next? 

How to Use Excel’s Find and Replace Tool in 30 Seconds ⏲️

Excel’s Find and Replace tool lets you quickly find specific words, numbers, or data in a spreadsheet and replace them with something else in seconds. Translation? This tool saves you from the all-too-familiar pain of editing cells one by one. 🙃

For example, say you’d like to edit this spreadsheet so the State column reads “CA” instead of “California.”

Instead of manually typing “CA” (and probably missing a few in the process), here’s how you can use Find and Replace: 

That’s it! Excel’s Find and Replace tool is super simple–but there’s a lot more cool things you can do with it. 👀 I cover its full potential in Module 4 of The Excelerator Course…which brings me to this:

Get Really Good at Excel. Really Fast.

From the Find and Replace tool to Chart Building to data analysis, The Excelerator Course covers all the Excel essentials so you can become the office’s go-to Excel wizard.

The best part? The course explains everything super simply.

No matter your experience level or how much Excel intimidates you, after The Excelerator Course you’ll finally be able grasp any concept—just like Rachel did with functions!

I’m giving Workbook readers 20% off with the code WORKBOOK20. Happy Exceling!

What’s a Portfolio Career? 📂

When I started Miss Excel in 2020, my goal was to have fun and help people learn Excel while balancing my 9–5. But as it grew and I launched courses and landed freelance clients, I (unintentionally) stepped into a new chapter: a portfolio career. 

What’s a portfolio career? Basically, it’s when someone has several unrelated jobs or multiple income streams instead of focusing on just one full-time role.

A portfolio career can be a mix of a bunch of things: a part- or full-time job, a done-for-you service (like freelance work), a do-it-yourself offer (like online courses), creative work (like newsletters or TikToks), or even volunteering (like pro-bono work).

Another helpful way to visualize it, as creator Anna Mack puts it, is to think of it as the “various pieces of your career pie.” 

I’m a huge fan of portfolio careers not only because they diversify your income, but also because they let you explore your curiosities without putting you in a box.

Because honestly? Our careers aren’t so black-and-white considering we’re constantly evolving, growing, and finding new interests and passions (we’re human, after all)! 

If you’re thinking of building out your own portfolio career, my advice is to start by listing everything you love and feel curious about. For me, that list included Excel, dancing, and teaching—which led me to post on TikTok. 

Of course, your list will be different, but the outcome will be the same: a roadmap to your future portfolio career. And who knows? It might just be the perfect recipe for a fulfilling professional life. 🥧

• How to earn the respect of your peers and boss at the office. 🏢

• Tired: Using a Dictionary in Excel. Wired: Using Smart Lookup. 

• Author Patricia Mou shares her advice on getting into a creative flow.  

• Feel like there’s a better way to switch files in Excel? I got you. 

• This OneNote hack is one of my most saved quick tips (and for good reason!).

Thanks for being here! With Halloween just seven days away, I’ll close out with a short Excel horror story. 🎃

In 2012, JP Morgan Chase & Co. lost over $6 billion after an employee copied and pasted the wrong data—using a sum total instead of an average—into their value-at-risk (VaR) Excel spreadsheet. 

Now that is what I call a terrifying day at work. 🙃

Stay Exceling,

Kat