Tabellab

Customer Complaints by the Numbers: Intake Rates, Reason Codes, Reply & Resolution Times, Ageing, Escalations, Goodwill Costs, Root Causes, Repeat Complaints & a Complaints Dashboard

Work through 20 hands-on labs at a fictional home and garden retailer – measure complaint intake per 1,000 orders, sort categories and reasons, check first replies and working days to resolve, age the open cases, track escalations, outcomes and goodwill, rank root causes, catch repeat complaints, size team capacity and the cost of poor service, set fix priorities and build a complaints dashboard – with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

In 20 hands-on spreadsheet labs you analyse the customer complaints of a fictional home and garden retailer. You turn weekly intake into rates per 1,000 orders, sort complaints by category and reason, check first replies against channel targets and count resolution times in working days with median and p90. You age the open cases on a fixed date, measure escalation rates, outcomes and goodwill per complaint, rank root causes with a cumulative share and catch repeat complaints with COUNTIFS. Then you plan team capacity, add up the cost of poor service, set fix priorities with payback months, compare before and after a process fix and build a complaints dashboard with a status rule.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. Complaints at a Glance: Which Category Is Slowest?LabFree
  2. Complaint Intake: Weekly Channels and Rate per 1,000 OrdersLab Locked
  3. Categorising Complaints: Categories, Reasons & SharesLab Locked
  4. First Reply: Acknowledgement Time vs the TargetLab Locked
  5. Resolution Time in Working Days: Median and p90Lab Locked
  6. Ageing of Open Complaints: Buckets on an As-of DateLab Locked
  7. Stage Times: Receive, Assign, Investigate, RespondLab Locked
  8. Escalations: Level Shares and Rate by CategoryLab Locked
  9. Outcomes: Upheld, Partly Upheld or Not UpheldLab Locked
  10. Goodwill: Refunds, Vouchers, Replacements & Cost per ComplaintLab Locked
  11. Root Causes: Cause Codes, Cumulative Share & a Ranked ChartLab Locked
  12. Repeat Complaints and Reopened CasesLab Locked
  13. Team Workload: In vs Out and the Backlog TrendLab Locked
  14. Capacity: Handling Minutes to Hours Needed vs AvailableLab Locked
  15. Satisfaction After Resolution: Scores and Response RateLab Locked
  16. Cost of Poor Service: Handling, Goodwill & Lost OrdersLab Locked
  17. Fix Priorities: Frequency × Cost and Expected SavingLab Locked
  18. Before and After a Process Fix: Complaints per 1,000 OrdersLab Locked
  19. Monthly Trend: Rate per 1,000 Orders, Within Target & DaysLab Locked
  20. Final Project: The Complaints DashboardLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy