My 5 best tips for digital nomads 🌍

Hey hey! It’s not every day you have to ask yourself “Is my WiFi strong enough to stream to over 30,000 people?” But thanks to the thousands of you who registered for my Pivot Table & Data Cleaning Class, that’s the question of the week here at Miss Excel HQ. 🥹 So things can go without a hitch, I rented a house in upstate NY with super fast WiFi. If you’d like to join the class (it’s free!), we still have spots available! Here are your date options.

P.S. Can’t make any of those time slots? No worries, when you register you automatically get access to a replay in the future. I got you. 🤝

VSTACK Is About To Become Your Best Friend

Last year, Excel released one of my now-favorite functions: VSTACK. 🤩 If you haven’t heard of VSTACK yet, let me introduce you to your future BFF.

VSTACK combines lists and arrays vertically into a single array. It might sound simple, but this function can save you from the worst time-suck: manually consolidating data from different tables.

Not only does this task cost you time, but it’s also prone to human error. And considering 88% of Excel spreadsheets already have some kind of mistake, we don’t want to leave anything to chance. 😅

Here’s how to combine data using VSTACK in three easy steps!

💡 The other cool thing about VSTACK? It uses a dynamic array, which means if you change the original column, the VSTACK array automatically updates. Happy VSTACKING!

My 5 Best Tips for Navigating Your 9–5 While Traveling

Congratulations, you’ve done the hardest part! 🥂 You found a fully remote job or set up your own business that allows you to work from anywhere in the world. But the challenges aren’t over just yet.

The next step is figuring out how you’ll stay productive despite time differences, new routines, and unexpected challenges. Fortunately, your girl’s been there, done that (I was a digital nomad for almost two years!), and I can teach you a lesson or two.

• How to reduce the costs of context switching (FYI: It takes 23 minutes to get back into the zone after being distracted).

• Never lose your active cell again (with the help of VBA!).

• Here are more tips on how to navigate a 9–5 while working remotely.

• Horse organizes all your tabs into a spreadsheet so you stay focused and don’t get lost in 4,136 open tabs.

• A weird but powerful productivity trick (Hint: It includes picking a theme song 🎶).

Major news: The Workbook hit 250,000 subscribers (for context, that’s the size of the University of Michigan football stadium times 2.5. 🤯)! What the heck! I want to thank you for being here. 🤗 I could’ve never imagined a year ago that I’d have the chance to talk to so many of you about Excel.

Stay Exceling,

Kat