Stop fighting Excel by hand 🥊

Hey there! Fall Planning Mode 🍂 is in full swing here at Miss Excel HQ, and I’d love to create lessons based on what’s actually tripping you up the most with Excel. Respond to the poll below and let me know!

Stop Fighting Excel By Hand 🥊

POV: It’s the intern’s first day. But when you stroll past their cubicle, you spot them doing this: 👇

They’ve been at it for hours, manually separating Product IDs, Order IDs, and Order Dates into individual columns. With each ctrl+c, you can practically see their soul leaving their body. 🙃

Not so long ago, you were in that exact same position…but then you realized that TEXTSPLIT could do the job in two seconds. Here’s how to show them this simple time-saver: 

The magic happens because TEXTSPLIT looks for your delimiter (the space) and splits everything around it. Got commas instead? Use =TEXTSPLIT(A2,”,”). Pipes? =TEXTSPLIT(A2, “ | “). 

This function works with any delimiter, so you can tackle any messy data that comes your way. 💪

Becoming an Excel Master Starts Now 🍂 

It’s September! Cue: that Back-to-School feeling™. While we’re no longer going to Staples to buy fuzzy pens and binders for class, that “new semester, new me” energy is still there—and now is a great time to learn something useful for your career.

That’s where The Excelerator Course comes in! Whether you’re a beginner who breaks into a sweat at the sight of a Pivot Table or an intermediate user who knows their way around but suspects there’s a whole world of shortcuts you’re missing, The Excelerator Course meets you where you are—as Taryn will tell you!

Join now and become noticeably better at a skill you use at work every day (just in time for your annual review 😉). Use the code WORKBOOK20 for 20% off The Excelerator Course and make this September count!

3 Little-Known Use Cases for AI 🧠

Everyone knows you can use AI to help craft that delicate “Can we push back that deadline?” email or help distill complicated data or research into super simple takeaways. But there’s so much more AI can do to simplify your life! 

Here are my three favorite underrated ways to use AI: 

🎁 Bonus: Upload a picture of the contents of your fridge and ask AI for dinner ideas. I’ve actually made some pretty good meals this way. Who knew? 

Now if only AI would actually listen when we tell it to stop using em dashes. If you know, you know. 🫠

• This Outlook shortcut will change how you attach files forever. 👀

• How to stop images in Excel cells from going rogue. 🏃 

• Create org charts in Excel faster than you can say “hierarchy.” 👪

• This Reddit post shares which “boring” routines are life-changing. ⚡

• New PowerPoint transition skill unlocked. 🔓️ 

Thanks for reading! Shoutout to Ariel Fischman, who holds the Guinness World Record for owning the largest collection of physical spreadsheets. While 99% of us open Excel in a browser these days, Fischman has managed to amass 506 hard-copy versions that hardly exist anymore.  

Now that’s what I call thinking outside the cell. 🤣

Stay Exceling,

Kat