7th Session - Handling, Identify and Removing Duplicates Countif Excel Function - Beginners

1) Excel Countif Function to find duplicates.
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?
2) To remove duplicate values, click Data - Data Tools - Remove Duplicates.

I am a data engineer with 14 years of experience and while making this Excel tutorial i have tried to share the industry level knowledge, tips and tricks that even i use in my office work on daily basis. Hope you learn something new and this video add some value to your skill set.

Excel Tutorial for Beginners in Hindi - Complete Microsoft Excel tutorial in Hindi for Excel users , To agar aap ko ye pata nahi hai ki, Excel me Kam Kaise Karte hai, Excel Data entry kaise karte hai, Excel me Formula kaise dete hai, Excel basic se aapko sikhana hai to ye aapke liye hai excel for beginners video me excel ke sare basic points maine explain kiye hai :
Excel Tutorial For Beginners in Hindi | Complete Microsoft Excel Tutorial
Excel tutorial for beginners in Hindi, this is complete Microsoft excel tutorial basic to advance including Excel Introduction, Excel formulas and functions, Excel tips and tricks, How to use Pivot table in excel, how to use VLOOKUP formula in excel and many formulas which is used in big companies to manage and analyze data like data analyst, data entry jobs, business analyst, etc

Видео 7th Session - Handling, Identify and Removing Duplicates Countif Excel Function - Beginners канала VikramSoftware