The transpose method I swear by šŸ¤ž

Plus: The Nervous System Olympics šŸ‘Ÿ

Hey! Up for a mini Microsoft challenge? Try putting these products in the order they were released: Excel, OneNote, PowerPoint, Outlook, and PowerBI. 

Iā€™ll give you a hint: The oldest on this list dates back to the 1980s, while the newest arrived within the last decade. Scroll down for the answers. šŸ‘€

The Transpose Trick šŸŖ„

Picture this: Itā€™s Thursday afternoon. After working on your quarterly presentation (due tomorrow šŸ„“) all day long, youā€™re about to head out when your boss walks by and glances at your spreadsheet. 

ā€œThis would be clearer if the employees category were columns instead of rows,ā€ they say. 

*cue internal screaming* šŸ™‚

Youā€™ve spent hours compiling this data. Re-entering everything manually would mean staying late. But donā€™t panicā€”thereā€™s a better way. Enter: the Transpose feature!  

This tool lets you flip your columns into rows and vice versa in seconds. There are two ways you can use it:

Method 1 

Step 1) In cell A8, type =TRANSPOSE(

Step 2) Select the full array (in our case, thatā€™s A1:I15) and press Enter. Done! 

Method 2 

Step 1) Select cell A1 and press CTRL + A (the shortcut to select your entire worksheet) 

Step 2) Right-click and click Copy 

Step 3) In your home ribbon, go to Paste and hit Transpose

 

There you have it! Your presentation is still on track to be ready first thing tomorrow morning. šŸ˜Ž

Missed Last Weekā€™s Dashboards Class?

ICYMI: Last week, we rolled out our first Excel dashboards classā€”where I showed you how to transform boring data into visual stories that command attention (and practically do all the analysis for you!).

Iā€™ve led over 100 Excel webinars. But this dashboards class? It was one of our best reviewed classesā€”ever!

To celebrate, if you missed last weekā€™s class, Iā€™ve made the replay available completely free! Give it a watch right here if youā€™re ready to level up your Excel game.

Hope it helps! šŸ’š 

Jet Fuel For Newsletters

I launched The Workbook on beehiiv in 2022 to create a space where we could all learn, share, and master Excel together. Fast forward to today: nearly 400K subscribers and counting! ā¤ļø

The secret? Having a platform that enables you to grow and scale at lightspeed. beehiiv's growth features, revenue tools, and global ad network help creators transform passion projects into money-making, community-driven platforms.

If youā€™re ready to build, ready to grow, and ready to make the world take notice, switch to beehiiv today and get 20% off your first 3 months with code WORKBOOK.

The Nervous System Olympics šŸ‘Ÿ

Ever found yourself anxious about somethingā€”maybe asking your boss for a promotion or quitting your jobā€”so you just keep avoiding it? šŸ« 

The problem: When we avoid the things that trigger our anxiety, weā€™re telling our nervous systemā€”the control center that regulates our stress responsesā€”that said thing is dangerous. Ultimately, we reinforce our fear and never end up making progress. 

This is exactly why I created what I call the Nervous System Olympics. Itā€™s a series of challenges ranked by difficulty that gently expose you to uncomfortable situations. 

The why: training our nervous systems through small, intentional exposure = building the resilience to face big, scary (but life-changing) opportunities, like moving to a new country or nailing an interview with your dream company

Hereā€™s how it works: 

šŸ„‰ Bronze: a small challenge thatā€™s mildly uncomfortable

Example: going for a 10-minute drive alone to my neighborhood coffee shop (Iā€™m not a big driver so this is outside my comfort zone!)

šŸ„ˆ Silver: a medium challenge that pushes the edges 

Example: going on the freeway to visit a friend who lives on the other side of town

šŸ„‡ Gold: a big challenge that gets your palms sweaty 

Example: renting a car in a new state or country (I know Iā€™m not the only one who gets nervous about this šŸ˜‰)

The key is to start small and slowly work your way up. Let yourself celebrate each winā€”no matter how smallā€”and youā€™ll eventually chip away at your fear. Is there a bronze-level challenge you can tackle today? 

Now, if you'll excuse me, Iā€™m going to go for a drive! šŸ˜Ž

Drumroll, pleaseā€¦šŸ„ Hereā€™s the correct release order: 

  1. Excel (1985) 

  2. PowerPoint (1987) 

  3. Outlook (1997) 

  4. OneNote (2003) 

  5. Power BI (2015) 

If you got these all right? Youā€™re a tried-and-true Microsoft history buff.

Stay Exceling,

Kat