One very useful thing you can do with a data table in Microsoft Excel is to sort it alphabetically or numerically, while maintaining the relationship between rows or columns. Doing this will make it easier for you to filter and interpret the data presented.
If you want homogeneity in your Excel data, it can be useful to put the possible values for a field in a closed list, so that the user selects from this list instead of being able to enter any value directly into the cell. An easy way to do this is by creating a drop-down list of valid values for a cell.
When working with a lot of data, blank spaces tend to appear, and sometimes information can be lost. Being able to identify where information has been lost, in order to fill in these blank spaces with the correct information, is essential. You will also want to delete any unnecessary blank spaces.