MS Excel - Formatting tips and tricks for better project management

5 Tips:

1. Starting with a clean sheet.
2. Formatting the title row
1. Dark cell with light text color and bold
2. Light cell with dark text color and bold
3. Avoid using RAG colors for your title
3. Table borders
1. Alternatively, use white no fill color, it gives default grid lines
4. Text alignment
1. Center for short and standarized data like status, date, completion %
2. Left for mor characters like task name, description and comments.
5. Extra space for title and total row