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
learn more about the Advanced Excel - • Excel Tips & Tricks
Let's Connect:
👉 Follow us on Instagram / yodalearning
👉 Follow our boards at / pins

[@sharmilisen2926]

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 🙂.

[@tanakornpromthep9025]

Thank you for sharing

[@sidharthkashyap6241]

Amazing video sir!

[@z.719]

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

[@RAKESHYADAV-ht2qp]

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

[@azeezahmed7070]

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

[@vikasbaheti6789]

Precise explaination. I admire your way of teaching

[@sunilpanicker3510]

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

[@abduljabbar8124]

thank you sir

[@raknoyaha1]

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.

[@alexrosen8762]

Excellent tutorial and great practical examples. Thanks

[@jenilshah68]

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

[@canirmalchoudhary8173]

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

[@rkpugalia8305]

Good feedbacks नमस्ते

[@rahuhub]

Very Very Useful techniques

[@myklopez9843]

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

[@rishabhberiwal2970]

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

[@nagendraprathap9697]

Very useful information sir, thanks 🙏

[@SanviPatil2019]

Jabardast

[@sreyamukherjee6146]

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.