Tool Feature: Microsoft Copilot in Excel — Loss Ratio and Portfolio Analysis

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 in the lower-right corner of the Excel window. Microsoft moved this button off the Home ribbon in 2026, so it now sits in the corner. Press F6 to reach it from the keyboard (the simpler Alt + C on Windows and Cmd + Ctrl + I on Mac shortcuts are rolling out), or right-click the corner button and choose Move to ribbon if you prefer the old placement. 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.