Friday, April 7, 2023

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


No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...