Project Management

Scenario: Project Task Tracker

• Set Up Your Project Task Table:

  • Open Excel and create the following headers in Row 1:

    • A1: "Task Name" | B1: "Assigned To" | C1: "Start Date" | D1: "End Date" | E1: "Status" | F1: "Days Remaining"

  • Format the headers:

    • Select A1:F1, click Bold, increase the font size to 12, and apply a light fill color (e.g., light gray).

• Input Sample Task Data:

  • Starting in Row 2, enter the following sample project tasks:

• Calculate "Days Remaining":

  • In cell F2, calculate the remaining days until the task's due date using this formula:

    =D2-TODAY()

  • Press Enter.

  • Copy the formula down to cells F3:F5 by dragging the fill handle.

  • This will calculate the number of days left until the task’s End Date.

• Format the Date Columns:

  • Highlight cells C2:D5.

  • Go to Home → Number Group → Short Date to ensure dates are formatted clearly.

• Apply Conditional Formatting for Status:

  • Highlight the Status column (E2:E5) to make the project easier to read:

    • Go to Home → Conditional Formatting → Highlight Cell Rules → Text That Contains.

    • Apply the following rules:

      • "In Progress" → Light blue fill.

      • "Not Started" → Light yellow fill.

      • "Completed" → Light green fill.

• AutoFit Columns for Clarity:

  • Double-click the column separators between A, B, C, D, E, and F to adjust the column widths.