For Insurance Underwriters ·
What you'll accomplish
Build and analyze loss ratio tables, identify portfolio trends, and spot concentration risks in your book of business — using natural language commands inside Excel, without writing a single formula. The same Excel spreadsheet you already use for tracking becomes a portfolio analysis tool.
What you'll need
Open an existing Excel workbook that has at least columns for: account name, line of business, annual premium, and loss amounts. This can be your renewal tracking sheet, a portfolio export from your policy system, or a manually maintained account list.
If you don't have one, Copilot can help create the template — click the Copilot icon and ask: "Create a table for tracking 20 commercial accounts with columns for account name, line of business, annual premium, 5-year incurred losses, 5-year loss ratio, and renewal status."
Click the Copilot icon (top right of ribbon). In the chat panel, type:
"Add a column that calculates the 5-year loss ratio for each account (total incurred losses ÷ total earned premium × 100). Format as a percentage. Highlight accounts where the loss ratio exceeds 75% in red."
Copilot writes the formula, applies it, and adds the conditional formatting in one step.
In the Copilot panel, ask:
"Summarize my portfolio by line of business — total premium, total losses, and average loss ratio for each line. Which line has the worst loss ratio? Which line represents the largest premium concentration?"
Copilot creates a pivot-style summary table and answers your questions directly in the chat.
Ask Copilot: "Which accounts have a loss ratio above 80%? List them sorted by loss ratio descending. Also tell me which accounts have had 3 or more claims in the data."
Use this output to prioritize your renewal review — start with the highest-loss-ratio accounts rather than working through the list alphabetically.