Excel Data Cleaning Techniques for ~ Data Analyst ~ (updated 2022)

Data Cleaning is an essential step both in Data Analysis using Excel and Data Science. In this updated video (2022), we show practical use cases of - Go To (Special) feature of Excel.

We covered the following topics:
00:00 Introduction to Excel Data Cleaning
00:33 How to Detect or color the error cell in Excel
01:15 How to use Go to Function in Excel
02:46 How to find calculations inside the cell in MS Excel
03:44 How to find hard-coded values in Excel
04:51 How to find inconsistent calculation values in Excel
06:36 How to color the blank cell in Excel
07:09 How to insert a word in all blank cells in Excel
07:56 How to Fill Intermittent blank cells correctly in Excel
11:29 How to color visible cells in Excel
12:44 How to select and delete all objects in Excel
13:31 How to color the cells with notes in MS Excel

Excel Data Cleaning Techniques for ~ Data Analyst ~
#datacleaning #excelcourse #exceltutorial

Let's Connect:

[sharmilisen]

I do not have any words to express my gratitude to you for this video. This is so much required in my Financial Reporting process. While rollforwarding my Reporting file, I need to manually remove prior month's hardcoded adjustment along with notes. This one technique of F5 is very useful here. Saving this video separately. Thank you so much 🙂.

[canirmalchoudhary]

Very useful and relatable,
Blanks,
Alt semi colon I use at lot

[alexrosen]

Excellent tutorial and great practical examples. Thanks

[sunilpanicker]

Nice explanation, easy to understand. Thank you very much.

[RAKESHYADAV-htqp]

Great video...do continue with this...i would like to watch on forecast tab videos

[z.]

Very useful techniques and uses cases. Please continue on this feature with more use cases.

[vikasbaheti]

Precise explaination. I admire your way of teaching

[azeezahmed]

So nice and amazing! Precise and in depth, more of all nicely explained. Thank you for sharing this.

[jenilshah]

Amazing Video.
Awaiting for remaining functions of Go To Special in another video.

[nagendraprathap]

Very useful information sir, thanks 🙏

[raknoyaha]

You are the best!!!! I always learn something new or new way to do the old things. Keep up the good work. 🙂 A big thank you.

[rishabhberiwal]

Very very enriching. Thank you so much Rishabh Sir. Do keep posting more of such content. Thank you so much🙏.

[myklopez]

Great...why not add downloadable excel sheet so we can get along while watching your videos...thanks

[sreyamukherjee]

I have a question on excel. Which formula to use if I'm asked to calculate P. Tax which is 12% of basic + da subject to maximum amount of rs. 15000.Can anyone help me with it??? I really need a solution.