- The Workbook
- Posts
- The transpose method I swear by š¤
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! š


Drop your mouse and head to the (spreadsheet) dance floor. š
This PowerPoint presentation is seriously Picasso-worthy. šØ
How to count how many worksheets you have in 20 seconds. š
This one question will immediately get you into a gratitude mindset.
The client just sent you a super messy spreadsheet? š« Hereās your fix.


Drumroll, pleaseā¦š„ Hereās the correct release order:
Excel (1985)
PowerPoint (1987)
Outlook (1997)
OneNote (2003)
Power BI (2015)
If you got these all right? Youāre a tried-and-true Microsoft history buff.
Stay Exceling,
Kat