need in your Excel workbook which includes code sheet, note sheet, spreadsheets 1 2 3
4 and many more so that you can clean your data in different columns.
You can always use the Find and Replace feature and replace that single word in the
entire workbook. It is also critical to remove the trailing and the spaces which can create
havoc on your analysis, and for that Excel has a few formulae which includes trim, clean
and substitute.
There is not any waiting time and you can remove all the non-printing characters from
the entire workbook in just a minute, even if the workbook is small or big. You can also
remove duplicates, find and replace, standardize the case of your text data such as
LOWER UPPER and PROPER.
Code, Calculate and Convert your Data:
These are the very critical 3C's, which will help you to get your data set analysis ready. It
is very likely that when you collected your data, you might have entered them as codes
like [small, medium, large] or [1,2,3]. Hence, you should know what these codes mean
and it is very necessary to make notes of the same. You should enter the code in a code
worksheet and make sure that you explain the same in the notes worksheet.
Further, some data is collected and some is not. There is also a possibility that
sometimes the data which has been collected has to be rounded, and sometimes it has
to be kept in categories. For example, weight may be measured in kilograms or grams
and rounded to the nearest decimal places. This can be done by ROUND, ROUNDUP
and ROUNDDOWN. All of this basically depends on what you want to do with your data,
how do you want to analyze it, so that you can perform calculations.