Tabellab

Excel for Insurance Agents & Brokers: Premiums, Commissions, Renewals & Book of Business

20 hands-on labs for agents, brokers and account managers of a small independent agency: policy register cleanup, premium by line, new vs renewal commission, renewal calendar, retention, quote-to-bind, average premium, cross-sell, producer splits, book growth, loss ratio, a book dashboard, renewal rate changes, quote comparison, payment plans, mid-term pro-rata changes, coverage reviews, claims follow-up, client touchpoints and a renewal-season dashboard.

20 lessons 20 labs Certificate

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

About this course

This course gives insurance agents, brokers and account managers 20 interactive Excel labs built on the policy register of a fictional independent agency. You clean names and line codes, total premium by line with SUMIF and SUMIFS, look up new and renewal commission rates, build a renewal calendar, measure retention, quote-to-bind and cross-sell, split commission with producers, roll the book forward and check loss ratios. Then you compare expiring and renewal premiums, pick the cheapest quote that meets a client’s needs with MINIFS, price payment plans and mid-term changes pro rata, review home coverage against rebuild estimates, age open claims with COUNTIFS, track client contacts with MAXIFS and finish with a renewal-season dashboard and chart. Every cell is checked instantly.

Lessons

  1. Policy Register Cleanup: Clean Names, Line Codes and CountsLabFree
  2. Premium by Line of Business with SUMIF and SUMIFSLab Locked
  3. New vs Renewal Commission from a Rate TableLab Locked
  4. Renewal Calendar: Days to Renewal and Call FlagsLab Locked
  5. Retention Rate: Renewed vs Lost PoliciesLab Locked
  6. Quote-to-Bind Conversion per ProducerLab Locked
  7. Average Premium per Policy and per ClientLab Locked
  8. Cross-Sell Ratio: Policies per Client and Mono-Line ClientsLab Locked
  9. Commission Split with Producers: New and Renewal RatesLab Locked
  10. Monthly Book-of-Business Growth (Chart)Lab Locked
  11. Simple Loss Ratio per Client with a HighlightLab Locked
  12. Mid-Course Dashboard: Book by Line with a ChartLab Locked
  13. Renewal Rate Changes: Expiring vs Renewal Premium, % Change and a Re-Market ListLab Locked
  14. Quote Comparison: Five Carriers, the Client's Minimum Needs and the Cheapest Qualifying QuoteLab Locked
  15. Payment Plans: Instalment Amounts, Fees per Instalment and the Extra Cost of Paying MonthlyLab Locked
  16. Mid-Term Changes: Days Remaining, Pro-Rata Premium and Cancellation RefundsLab Locked
  17. Coverage Review: Insured Amount vs Rebuild Estimate, Gaps in Dollars and an Underinsured FlagLab Locked
  18. Claims Follow-Up: Days Open, Aging Buckets for Open Claims and the Average Time to CloseLab Locked
  19. Client Touchpoints: Contacts per Client, Last Contact with MAXIFS and the Reach-Out ListLab Locked
  20. Final Project: The Renewal Season Dashboard – Premium per Month, Expected Commission, Premium at Risk and a ChartLab 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