Branch Performance — Excel Course

Compare branches across target, collection and achievement %. Learn it step by step with guided practice on Excelquro.

Understand

Branch performance compares actual collection with target while keeping branch size in view. Ranking alone is not enough; the analyst should identify both strong performers and meaningful gaps.

Worked example

Compare actual collection with target to make branches comparable even when target sizes differ.

=Collection/Target

Follow along

1. Aggregate target and collection by branch.
2. Calculate achievement %.
3. Sort or rank branches.
4. Inspect branches below the agreed threshold.
5. Add a management note explaining the largest gaps.

Interactive practice runs in your browser.