Activities that repeat again and again should be covered through Macro or VBA.
Always use headings in the first row. Bold them or make them different in some way than your data. The data should start from the second row.
Avoid the use of entire blank Rows or Columns. In fact, avoid any blank cells within the table or list whenever possible. Excel will often see a blank Row or Column as the end of your data.
If month names are to be used as headings type a true date (25/12/2002) and custom format as "mmm" or "mmmm". This can make life much easier later on in Excels functions.
If two tables or lists are NOT related keep them on separate sheets. This way if you Filter down one table or list you are not accidentally hiding the rows of another. If the data is related, keep it within the same table or list.
Once your Excel worksheet is stuck and you can either look for smart solution or doing it sisyphically – go and find a smarter method though it takes more time and energy out of you.
Once for a while, surf the web and see what is new in other Excel sites.
C o n t r o l s – your Excel spreadsheet should have checking cells that alert for mistakes.
File with CIRCULAR is badly wrong.
Files that ask to update cells once you open it – Wrong
File with 15 worksheets with option for more… - Wrong
Table – always, first line is title and starting the second line come the data. No empty lines inside the table.
