SLW#043: Data Cleansing Practice
Just a quick update—I've been doing some one-on-one coaching sessions lately, and a lot of them have focused on data structure and cleansing. Remember how I talked about it in the last newsletter? Knowing your data structure inside out is key, so that's where we're starting!
Prepare a clean data set with proper structure.
Alright, let's talk about the 3 key types of functions for cleaning up data: TEXT AND DATE, LOOKUP, and LOGICAL FUNCTION.
This week, you're diving into the newest text functions in MS 365 to spruce up your data.
We'll cover TEXTSPLIT, TEXTBEFORE, and TEXTAFTER, along with the handy logical function IFERROR.
Don't forget, practice makes all the difference. That's why I'm sending over a practice file for you to tackle this week. Get ready to dive in!
CLICK HERE TO DOWNLOAD PRACTICE FILE
Next up, check out the Data Cleansing Tutorial. It's got a handy Excel function list straight from the Microsoft webpage. Enjoy watching!
If you’re struggling with Excel for business analysis👇
—————
I Help You Master Excel for Business Analysis in Just One Course!☀️
Become a Data-Driven Pro. 🔗Click the link below to start now!
