IMPORTANT: Having clean data must be your priority if you intend to carry out a lot of analysis or you intend to automate your reports. Spend the time required to educate those in charge of your data to always follow the 7 rules when preparing, storing and retrieving data.
Each column must have a descriptive heading typed out in the first row.
You must have content in at least one cell of each row. Never have a completely empty row.
Just as above. You should never have a completely empty column
Note: If you have headings for each column then this means you do not have any empty columns.
DO NOT type comments at the end of your data or insert a total row at the bottom, or type something directly above your headings. All these examples are obstructions that break the rule.
Note: Dates are arguably the most important field in your data, they must be entered vertically (each record/each row, must have a date). If this rule is broken, you will be unable to automatically create reports by month, quarter and year or take advantage of date intelligence calculations in Power Pivot.
e.g. You cannot have a column containing department names as well as dealer names.
Each of these data types must have their own columns.
Totals and subtotals are for your report sheet, they have absolutely no place in your data sheet.