- The Workbook
- Posts
- Find success through subtraction š§®
Find success through subtraction š§®
Plus: These 2 functions are a match made in heaven
Hey there! In a perfect world, our data is always āØ neat āØ and formatted. But in most cases? We deal with messy spreadsheets and inconsistent data that leaves us overwhelmed and ready to give up. š«
Thatās why Iām hosting a free live Excel class on Data Cleaning and Data Analytics! Youāll get tons of Excel tips to help you turn even the most chaotic spreadsheet into beautiful and organized data.
Interested? Hereās the schedule for our classes:
Wednesday, October 9 at 3 PM ET
Thursday, October 10 at 12 PM ET
Friday, October 11 at 12 PM ET
If none of these times work, you can sign up here to get the replay. See you soon!
These Two Functions are a Match in Data Cleaning Heaven š¼š¼
Itās another day in the office when you glance over your new interns' shouldersāand see theyāre about to send this spreadsheet to your boss.
āItās going to take way too long to fix these manually,ā they explain. Because you want your intern to become your future co-worker, you show them this data-cleaning tip:
Step 1) In your desired cell, type =TRIM(PROPER(A2))
š” Excel Foundations:
The TRIM function removes all spaces from text except the spaces between words.
Example: āHello thereā ā āHello thereā
The PROPER function capitalizes the first letter of each word.
Example: āHeLLO tHeReā ā āHello Thereā
Step 2) Drag down and youāre good to go! (and the intern lives to see another day š )
Become a Data Cleaning and Analysis Excel Pro
Weāll be covering more tips just like the one above in my free live Excel class next week! Itāll give you all the tools you need to be a data cleaning pro and is perfect for all Excel skill levels.
Unlike other Excel classes, our free live class is fun, interactive and upbeat. I promise youāll learn something new and have fun while doing so (just like John did š„¹):
Save your seat and register today!
Find Success Through Subtraction
When I was in high school, I enrolled in this one extracurricular that seemed great on paper but quickly overwhelmed me. Juggling that activity alongside my classes and part-time job was stressful (to put it lightly). š«
To pull it off, I downloaded the latest productivity software, bought one of those fancy bullet-journals, and even learned how to color-code my calendar.
Me trying to convince myself I could handle it all š
But no matter how organized I tried to be, I was still scrambled and stressed. Then I asked myself: āWhat if instead of adding things to āfixā the problem, I removed the problem?ā
I opted out of the extracurricular activity. And you know what happened? I had more time and energy to focus on my classes, job, and relationshipsāall the things most important to me.
Sometimes, the answer to our dissatisfaction lies in subtracting whatās not serving us instead of adding more and more stuff.
For example, if youāreā¦
š¼ Unhappy at your job ā Instead of going after bigger and better projects, consider leaving your current field to find something thatās a better fit.
š¤³ Addicted to social media ā Instead of putting your phone on grayscale and purchasing social-media blocking apps, delete the apps from your phone.
š„± Tired 24/7 ā Instead of downing coffee and energy drinks, cut out the late-night Netflix sessions.
This is easier said than done. For starters, itās difficult to let go of things once theyāre in our possession (this is known as the endowment effect!). Second, adding āsolutionsā is simpler than changing our behavior and die-hard habits.
But getting rid of things that donāt serve us will always have outsized returns. And in most cases? Less is definitely more. š
Three foolproof ways to hide zeros in your spreadsheets.
493 people now know slicers can elevate their data analysis. Do you?
Itās been a long time since a book excerpt left me speechless.
73% of employers say this is the most in-demand skill of 2024.
This just in: Office 2024 is available without a subscription!
Thanks for being here! Iām on cloud nine heading into this weekend after going to Joe Dispenzaās meditation retreat last week! I spent 35 hours meditating (which is wildāmeditation used to be so tough for me!). Have a good one!
Stay Exceling,
Kat
P.S. See you in my free live Excel class next week! I canāt wait for you to get these Data Cleaning & Analysis tips under your beltātheyāre going to forever change the way you see Excel.