- The Workbook
- Posts
- Why attention is your superpower š„
Why attention is your superpower š„
Plus: Lazy analysts will love this Excel tip
Hey hey! Hereās a wild story to spice up your Thursday: Williams Racing was reportedly using a 20,000-part Excel spreadsheet to piece together its racing cars.
Apparently, the monster of a spreadsheet was āimpossible to navigate and impossible to update,ā causing the company to lose its status and fall on hard times.
BRB, adding this story to my list of why you should become proficient in Excel. š
Pivot Table Hack For The Lazy Analysts
Do you self-identify as a lazy analyst? Donāt worry, I wonāt tell your boss. š But I will tell you about the Recommended Pivot Tables featureāwhich just might become your Excel BFF.
POV: Youāre just discovered the Recommended Pivot Tables feature š
This tool analyzes your data and suggests several pivot table layouts that might be useful.
Letās walk through an example, starting with a basic spreadsheet of expenses:
Not bad, butā¦there are simpler ways to view this data. Luckily, Recommended Pivot Tables will tell us exactly what those are. Hereās how:
Step 1) Highlight your data set
Step 2) Go to Insert and select Recommended Pivot Tables
Step 3) Scroll through and select the Pivot Table that suits you best!
Step 4) Select OK and youāre all set!
š” Pro Tip: After selecting a recommended Pivot Table, you can still customize it! Use this tool as a base to save you time (and headaches) before adjusting it to fit your needs.
Attention = Opportunities
Letās play a game: Find everything thatās red in this image. š
You probably noticed the red notebook, candy, and pushpin. Great job! Butā¦can you recall everything blue?
Way harder, right? Thatās because you channeled your focus on what was red and ignored everything else. This is exactly what happens when you miss out on opportunities because youāre focused on something else.
For example: Youāre having a hard time at your job, so you funnel your attention into finding a new job. You would:
ā Notice the job listings on your local coffee shopās bulletin board.
ā Find and message recruiters that arenāt in your exact niche, because you never know who they could connect you with.
ā See a LinkedIn post of a friend switching jobs as an opportunity to get a foot in the door at a new company.
But someone who only pours their attention into hating their current job? They miss out on all of these opportunitiesānot because they arenāt there, but because they canāt even see them in the first place. Theyāre so focused on finding the red, they miss all the blue.
This is why where you place your attention is so important.
To be clear, the law of attraction isnāt an oversimplified belief that āpositive thoughts always lead to positive outcomesā (reaching your goals is h-a-r-d). Instead, itās about adjusting your focus to spot opportunities where other people miss them.
Because oftentimes, theyāre right in front of you: You just have to be willing to notice. š
Still manually creating bar charts? Let me introduce you to āØ dynamic bar charts. āØ
Boss: Ugh, this data is a mess. You: Hold my coffee.
Seven life lessons from a career coach who charges $3,700/month (Iām a huge fan of #7).
Listen to my episode on the HR Besties podcast to learn about my top Excel pros and noās. š āāļø
An Outlook tip for my digital nomads (timezones are tricky!).
Thanks for being here! Before we part ways: The Workbook just hit over 370,000 subscribers! Thank you for letting me in your inboxāIām honored to play a part in your professional (and personal) growth. š„²
Stay Exceling,
Kat