Mandatory Certificate Tracker: Expiry Dates, Days Left & RAG Status
This lesson is part of the course
In this lesson
You calculate when each mandatory certificate expires with EDATE, how many days are left on the report date and a red/amber/green status with IFS, then colour the expired ones.
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
- The Skills Matrix: Required vs Actual Levels, Gap Counts & a Heat Map Locked
- Mandatory Certificate Tracker: Expiry Dates, Days Left & RAG Status Locked
- Completion Rates by Team & an Automatic Overdue List Locked
- Training Hours & Cost per FTE, per Completion and Budget vs Actual Locked
- Did They Learn? Pre-/Post-Test Gains, Pass Rates & Normalised Gain Locked
- Evaluating Training on Four Levels: Weighted Index & Response-Weighted Averages Locked
- Training ROI: Full Cost, Monetised Benefits, ROI % and Payback Locked
- Capstone: Allocate the Training Budget by Gap Closed per 1,000 Locked