Learn to clean any data using these 8 data cleaning tricks.
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video:
view.flodesk.com/pages/634964ce22362ce13d822f55
Learn to clean any set of data using these 8 steps:
1. Text to Columns to separate text
2. Remove Duplicates with unique formula and replace feature
3. Proper to remove inconsistent capital letters
4. Remove spacing with trim formula
5. Flash fill to automatically separate city and country
6. Changing numbers to percentages
7. Text to values for further calculations
8. Removing blank cells from a database
For these steps, we try make it realistic by creating a scenario where we're working at Amazon as analysts and need to send this to our manager.
LEARN:
📈 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
📚 All our courses: careerprinciples.com/courses
SOCIALS:
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑💻 LinkedIn - linkedin.com/company/careerprinciples/
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Separating Text
1:55 - Removing Duplicates
3:49 - Letter cases
4:38 - Spacing fixes
6:18 - Splitting text with Flash Fill
7:02 - Difficulties with percentage formats
8:20 - Text to Number
10:04 - Removing Blank Cells
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
- Data Cleaning in Excel | 8 Tricks to Make You a Pro User ( Download)
- Master Data Cleaning Essentials on Excel in Just 10 Minutes ( Download)
- Data Cleaning in Excel - 10 Tricks (Beginner to PRO) ( Download)
- How to Clean Data in Excel in 10 Minutes (Free File) ( Download)
- Cleaning Data in Excel | Excel Tutorials for Beginners ( Download)
- Data Cleaning in Excel: 8 Pro Tips for Office Productivity | Excel Cleaning Hacks ( Download)
- Data cleaning in Excel - 10 tricks *PROs* use all the time ( Download)
- Data Cleaning in Excel 🔥 #shorts ( Download)
- Excel Formatting Cleanup: The Fast And Easy Way To Clean Your Data ( Download)
- 20 Excel Shortcuts to Save You HOURS of Work ( Download)
- 3 Quick tips to get better in Excel formulas ( Download)
- Top 10 Data Cleaning practices in Excel (With Latest Tricks) ( Download)
- how to clean mess up data and separate in columns #shorts #excel #exceltips #exceltutorial #formula ( Download)
- Messy Data in Excel Clean it up 🧹 like this #shorts ( Download)
- Clean Messy Data - Part 3 | TextSplit Function | Excel Tips and tricks | #shorts ( Download)
