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

OIC - Moving a File using FTP connection now throws IO operation failed error

Error usecase: Moving a File using FTP connection now throws IO operation failed error. The integration has been working for weeks, with a f...