-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Efficiency Best Practices for Microsoft 365
By :

Data can be text, numbers, dates, and so on. Just entering or importing the data into Excel (or any other spreadsheet) is not enough. The data must be CLEAN. Unfortunately, hitherto, there has not been any simple definition of what clean means. Here is a simple 11-item checklist.
If your data passes each item, then it is clean. Here is the checklist:
It is important to understand this concept. Watch this video to see examples of each item. The video shows each rule with sample data and explains why it is important to follow the rule. It shows the wrong format first. It explains why it is wrong and then shows the correct format.
You should compare these examples with your own data and learn how to apply these rules.
Look at your data – each column as well as overall. Check which items are not right and then clean them up or repair...
Change the font size
Change margin width
Change background colour