Ravi Sir's Cards › Excel
Software Project Management System in Excel (card 2 of 2)
Revision card 2 for Software Project Management System in Excel: Risk score: =B5*C5 gives 16; Risk rating: =IF(D5>=15,"High",IF(D5>=8,"Medium","Low")) gives High; Tasks per owner: =COUNTIF(Tasks!$D$5:$D$60,A5) gives 3. Includes an example data table.
Read card text
What this card says
2 for Software Project Management System in Excel: Risk score: =B5*C5 gives 16
Risk rating: =IF(D5>=15,"High",IF(D5>=8,"Medium","Low")) gives High
Tasks per owner: =COUNTIF(Tasks!$D$5:$D$60,A5) gives 3. Includes an
Example
data table
Learn this in the lesson: Software Project Management System in Excel: Task Tracker, Sprint Burndown, Risk Register and Project Dashboard