Master Data Cleaning in Excel with These 8 Expert Tricks π§Ή
Discover 8 powerful Excel data cleaning techniques to become a pro user. Perfect for business and finance professionals looking to streamline their workflows. Enroll in our Excel for Business & Finance Course: https://www.careerprinciples.com/courses/exce

Kenji Explains
137.5K views β’ Oct 16, 2022

About this video
Learn to clean any data using these 8 data cleaning tricks.
π Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
π DOWNLOAD Free Excel file for this video:
https://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: https://www.careerprinciples.com/courses/finance-valuation-course
π Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
π¦ The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program
π All our courses: https://www.careerprinciples.com/all-courses
β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬
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.
π Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
π DOWNLOAD Free Excel file for this video:
https://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: https://www.careerprinciples.com/courses/finance-valuation-course
π Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
π¦ The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program
π All our courses: https://www.careerprinciples.com/all-courses
β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬
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.
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
137.5K
Likes
4.1K
Duration
11:52
Published
Oct 16, 2022
User Reviews
4.7
(27) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.