Data Cleaning in Excel

This video shows how to clean data in Excel so as to ensure data integrity. In the Excel sheet, we have a name column which some name records are not properly written. For instance, some first names start with small letters and the objective is to make these first names to be in capital letters all through and second names to be in proper case letters like IBRAHEEM Babatunde. Watch the video and see how we blended many functions to solve the problem.
Do not forget to subscribe to the channel and also like the contents if you find them useful.
Data can talk, if you understand its language.

Видео Data Cleaning in Excel канала Datatech Analytics