Tutorvo

RACI Checks: Exactly One A, at Least One R, Missing Owners and Overloaded Roles

Lesson 2 of 815 minLab

This lesson is part of the course

In this lesson

You check a ten-task RACI matrix with COUNTIF: one A per task, at least one R, a status flag with IFS and the R + A workload of each role against a fictional team limit.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Stakeholder Register: Power & Interest Scores, Quadrants with IFS and a Grid ChartLab15 minFree
  2. RACI Checks: Exactly One A, at Least One R, Missing Owners and Overloaded RolesLab15 min Locked
  3. Elicitation Plan: Interviews, Workshops & Surveys, BA Hours, Group Coverage and a WORKDAY CalendarLab16 min Locked
  4. Requirement Quality: Vague Words with FIND & IFERROR, Missing Acceptance Criteria and a Quality ScoreLab16 min Locked
  5. MoSCoW against Capacity: Must Share vs a Fictional 60 % Rule, Running Totals and the Cut LineLab15 min Locked
  6. Traceability to Objectives: Orphan Requirements, a Trace Matrix, Objective Coverage and Wasted EffortLab15 min Locked
  7. As-Is vs To-Be: Hand-Offs, Cost per Order with Rework, Yearly Savings and the Biggest GapLab17 min Locked
  8. Capstone – Business Case & Change Requests: Net Cash Flow, NPV, Schedule Shift with WORKDAY and Approve/DeferLab18 min Locked