Published On Jun 11, 2023
Lear Data Cleaning Essentials in Excel in just 10 minutes
π Take our Excel course: https://www.careerprinciples.com/cour...
π DOWNLOAD Free Excel file for this video:
https://view.flodesk.com/pages/6482f5...
In this video you'll learn 10 data cleaning tricks on Excel. We'll go from having a raw dataset that has several errors, to a clean dataset that we can present to our managers. For this, we learn tricks such as text to columns and remove dupilcates, and several formulas such as the trim, proper, lower, iferror and more.
LEARN:
π₯Power BI for Business Analytics: https://www.careerprinciples.com/cour...
π The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
π All our courses: https://www.careerprinciples.com/courses
β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬
Chapters:
0:00β -β Autofit Rows and Columns
1:17β - Find & Replace
2:17β - Lower & Upper
3:39β - Trim & Proper
5:50 - Text to Columns
7:00 - Removing Duplicates
7:29 - Filling Empty Cells
8:28 - IFERROR
9:22 - Formatting
9:43 - Gridlines
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.