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.