Cybersecurity Risk Quantification in Excel
Put dollars on cyber risk: SLE, ARO and ALE, control cost-benefit, risk matrix and register, PERT loss ranges, vulnerability SLAs, phishing and incident metrics, on live auto-graded spreadsheets.
IT teams are increasingly asked to explain risk, cost, reliability and delivery dates in numbers that management understands. These IT courses teach the calculations behind those conversations, in a spreadsheet that checks every formula, so you can build your own risk register, cloud cost report, service dashboard or release forecast instead of relying on a tool you cannot explain.
Cybersecurity Risk Quantification puts dollar figures on risk with asset value, exposure factor, SLE, ARO and ALE, then covers control cost-benefit, risk matrices and registers, PERT loss ranges, vulnerability SLAs, phishing metrics and MTTD and MTTR. Cloud Cost Management (FinOps) breaks down the cloud bill, calculates unit costs, finds the commitment break-even, rightsizes instances, tiers storage, allocates shared costs and flags anomalies. IT Service & Reliability Metrics covers availability and the nines, MTBF and MTTR, SLA compliance, error budgets, capacity planning and service desk staffing. Software Project Estimation & Agile Metrics forecasts releases from velocity and sprint capacity, tracks burndown, cycle time and throughput, and ranks the backlog by WSJF. The courses suit IT managers, security analysts, SREs, FinOps practitioners, scrum masters and students preparing for certifications.
Put dollars on cyber risk: SLE, ARO and ALE, control cost-benefit, risk matrix and register, PERT loss ranges, vulnerability SLAs, phishing and incident metrics, on live auto-graded spreadsheets.
Break down the cloud bill, track unit costs, find the commitment break-even, rightsize, tier storage, allocate shared costs, forecast to month end and catch cost spikes, on live auto-graded spreadsheets.
Availability and the nines, MTBF/MTTR, SLA compliance, backlog and FCR, error budgets, capacity planning, change success and service desk staffing: 8 labs on one IT team's data.
Forecast like a data-driven agile team: velocity ranges, sprint capacity, release dates, burndown charts, cycle time, Little's law, WSJF, confidence buffers and cost per story point in 8 hands-on labs.
The annual loss expectancy formula, ALE = SLE × ARO with SLE = asset value × exposure factor, and how to value a safeguard. Worked example in Excel.
MTBF, MTTR and availability: MTBF ÷ (MTBF + MTTR), MTTA, the four meanings of MTTR and the downtime each number of nines allows. Excel example.
The quantitative risk formulas (SLE = asset value × exposure factor, ALE = SLE × ARO) and the safeguard cost-benefit test appear in both exams. The course teaches them on worked cases, but it is not a full exam preparation course.
No. The labs use a realistic monthly bill and usage data in a browser spreadsheet. The methods apply to AWS, Azure and Google Cloud exports.
MTBF is the average time a system runs between failures, and MTTR is the average time it takes to restore it. Availability can be estimated as MTBF ÷ (MTBF + MTTR).
Free lessons work without an account. Sign up to save your progress.