Master Data Cleaning Essentials on Excel in Just 10 Minutes

Video Description

Lear Data Cleaning Essentials in Excel in just 10 minutes 👉 Take our Excel course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/6482f5f2547f639e72ba553c 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/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-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