You'll never have to do this in Excel again 😦

Hey you! As you might already know, earlier this year I signed a book deal with my dream publisher—and its slated to hit the shelves in 2027. (Still pinching myself! 🥹 )

I’m pouring my heart into this book (and no…it’s not an Excel book 🤣 ). It’s all about how harnessing the power of opposites can help you work smarter, adapt faster, and create exponential results in your career and life.

But I need your help. I haven’t decided on a title yet and I’d love your opinion on which title pops out the most to you.

Thank you so much for your help. 💚 

Never Type Lists in Excel Again ⚡

“This is going to take forever.” 🥲

That’s you, five minutes after volunteering to handle team assignments for your company offsite. With over 30 names and four teams, you’re going to be typing “Team 1, Team 2, Team 3, Team 4” for way too long.  

Fortunately, Excel is on your team. 😉 There’s a formula that combines two functions—MOD and ROW—and together they’ll fill your entire list. 

Here’s how it works: 

Done! Now the only thing left to do is decide which games to play at the offsite. (Excel trivia, anyone? 👀) 

P.S. If your data starts in a different row, just swap out the -3 for whatever row your list begins in—so if your names start in row 4, you'd use -4 instead!

Stop Thinking People Are Just Being Nice 🙇

Recently, a friend of mine told me that someone bought a year-long subscription to their paid newsletter. “It was so nice of them!” they gushed. 

My response? “I don’t think they were just being nice.” 🙃

Here’s what I mean: When people support you, it’s not always out of the kindness of their hearts. They’re also doing it because you’re giving them something valuable in return. For example, if your: 

• Boss promotes you. → Not to be nice, but because you proved you were ready for more responsibility. 

• Co-worker compliments your presentation. → Not just to flatter you, but because what you put together impressed them. 

• Manager asks you to take on a new project. → Not as a favor, but because they trust you’re the right person to get it done. 

Of course, sometimes people really are just being supportive to be supportive—nothing wrong with that! 

But presuming that’s always the case? I call that “reverse people-pleasing.” We know people-pleasing does us zero favors, but assuming others are doing it to us can also chip away at your (well-deserved) credit. 

The next time someone supports you—whether it be a compliment, sale, promotion—don’t write it off as “niceness.” 

See it for what it is: proof that you bring value to the table. ✨

• Why CTRL + E is one of the most underrated shortcuts in Excel. 

• How to autosum multiple rows and columns at the same time. 👀

• Did you know you could create a custom search bar in Excel? 🔍

• “Love this!” says a comment under my video on interactive charts! 📊

• This Pivot Chart Report is the difference between “Can you explain this?” and “This is incredible.” 🤩

Thanks for reading! P.S. The next time someone tries to tell you that Excel is “just for work,” kindly point them to this list of games people have recreated entirely inside a spreadsheet—Monopoly, Chess, Tetris, Scrabble, and my personal favorite, Excel soccer. 🤣

Stay Exceling,

Kat