Get 2 hours of Excel done in 30 seconds 🏃

Hello from California! ☀️ I’m here for some podcast and networking events that I’ve been looking forward to for weeks! The sun, salt, and sea have me feeling inspired to create some new Excel classes. Speaking of, I’d love to hear your two cents on which one would be most useful to you.

Turn 2 Hours of Excel Work Into 30 Seconds

POV: You spent Monday morning creating a sales report with employee names spanning the columns and regions down the rows (North, South, East, and West). 

You’re feeling pretty good about yourself. The data looks clean and the numbers add up. But right before you dig into your lunch, HR slides into your inbox: 📧

“Hey, can you flip this around? Our new CRM system needs employee names as rows to import properly. Thanks!”  

Ouch. But before you manually re-type everything (while your Sweetgreen slowly wilts), let me introduce you to the Transpose feature. 

This feature flips columns into rows and vice versa. There are two ways you can use it (keep reading for the second one to preserve your formatting!). 

Method 1 

Method 2 

Done! Now you can go eat your salad before it becomes a sad and soggy mess. 

The Mood Menu of 1% Moves 📋

It’s 3 PM on a Tuesday when your mood crashes.  

Maybe it was your coworker’s passive-aggressive email. Maybe it was the gray skies. Or maybe it’s just one of those days. 

Earlier this year, I found myself in a similar kind of funk. As Miss Excel was scaling, tough decisions were piling up and weighing on me. I wanted to turn my mood around, but it felt overwhelming. 

“Wait a second,” I realized. “There’s something off with that phrase.” 

“Turning your mood around” implies an entire emotional overhaul. But your mood isn’t a light switch that flips only up or down. It’s more like a dimmer you slide up 1% at a time. That’s when I had the idea for the Mood Menu of 1% Moves. 🔆

• The What: A list of tiny actions that inch you toward a higher emotional state. For example, dancing (badly) for three minutes, going for a stroll without your phone, or hopping in the shower to “wash the bad mood away.”  

• The How: Tiny moves feel effortless, and once you’ve done one, momentum kicks in. Before you know it, you climb from a 0 to 50 without forcing anything. 

You can use OneNote to jot down a few things that make you feel slightly better (use my code WORKBOOK30 to get 30% off the OneNote Mini Course!). The next time you’re feeling blah, you’ll have a menu of options to help you slowly slide into a more radiant state.

• The 10 Excel formulas I use every single day at work. 💼

• Avoid these five Excel mistakes that’ll cost you hours (and your sanity). 

• The 12-step questionnaire for discovering what you’re good at. ✨

• Only 1% of people can spot what’s wrong with this formula. Can you? 

• Create the dynamic Excel calendar of your dreams in 60 seconds. 💭

Thanks for reading! Did you know Excel turns 40 on September 30?  

To celebrate, Microsoft is doing a 40-day countdown with Excel creators who are sharing their favorite features. We’re 31 days in, which means there are 31 battle-tested tips right here (with 9 more still to come!). 

Stay Exceling,

Kat