Target vs Achievement — Excel Course

Build KPI logic and management-friendly visuals. Learn it step by step with guided practice on Excelquro.

Understand

Target-versus-achievement analysis turns two raw numbers into a management decision by calculating variance, achievement percentage and status.

Worked example

Variance makes under- and over-performance explicit.

=B2-C2

Follow along

1. Place target and actual in separate fields.
2. Calculate variance as actual minus target.
3. Calculate achievement %.
4. Define status thresholds.
5. Explain the largest positive and negative gaps.

Interactive practice runs in your browser.