Cellwise Start free

Guided project · 6 steps Cellwise Plus

Call center agent scorecard in Excel

Turn a week of agent stats into AHT, FCR and CSAT per agent, a target check and team figures weighted the right way.

You will use: ROUND, IF, AND, SUM

Starting data

RowABCDEFGHIJKL
1AgentCallsHandle time (s)Resolved first contactSurveysRated 4 or 5AHT (s)FCRCSATCheckAHT target (s)
2Ana212614801713833FCR target
3Ben188648601393124Team AHT (s)
4Chen236587641624433Team CSAT
5Dev9530875761715Agents on target
6Eli201578881583530
7Fay174551581412922

Build it step by step

  1. Step 1

    Average handle time is handle seconds divided by calls. Write it in G2, rounded to whole seconds, and fill to G7.

    G2Formula included with Cellwise PlusFormula in the app
  2. Step 2

    First contact resolution is calls resolved on the first contact divided by calls. Write it in H2 and fill to H7.

    H2Formula included with Cellwise PlusFormula in the app
  3. Step 3

    CSAT is the share of surveys rated 4 or 5. Write it in I2 and fill to I7.

    I2Formula included with Cellwise PlusFormula in the app
  4. Step 4

    In J2, show "On target" when AHT is at or below M1 AND FCR is at or above M2, otherwise "Coach". Fill to J7.

    J2Formula included with Cellwise PlusFormula in the app
  5. Step 5

    What is the team AHT? Divide total handle time by total calls, rounded to whole seconds, in M3.

    M3Formula included with Cellwise PlusFormula in the app
  6. Step 6

    Team CSAT the same way: total rated 4 or 5 divided by total surveys, in M4. Then count the agents on target in M5 with COUNTIF.

    M4Formula included with Cellwise PlusFormula in the app

Guides for the formulas in this project