# Excel for insurance agents on Mac: renewals and commissions in Microsoft 365

> Excel for insurance agents on Mac: renewal trackers, commission checks, pivots, and Mac limits. Ask Lazur for help while you work in Excel.

URL: https://www.lazur.app/for/insurance-agents/excel
Updated: 2026-11-06

Excel for insurance agents on Mac handles the core agency jobs: renewal trackers, commission checks, and carrier statement matching. You use the same Microsoft 365 app that Windows users have, with a few Mac gaps to plan around. This guide covers setup, formulas, Mac limits, and where Lazur helps while the file is open.

## Quick answer

- Build one named table for policies. Formulas then read Policies[Premium], which stays clear for months.
- Match commission lines with XLOOKUP and TRIM. Give missing matches a visible label, not a blank.
- Mac does not have Power Pivot or the Data Model. Plan Data Model work for a Windows PC.
- Lazur points, explains, and guides one click at a time. It does not click buttons or edit your file.

For most agency work, Excel is a list keeper. A renewal tracker tells you who comes up next. A commission sheet tells you whether the carrier paid what it owed. Those two jobs are where small errors turn into lost commission, so this guide starts there.

![Insurance agent at a desk with a laptop, reviewing a renewal list in a spreadsheet](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/insurance-agents-excel/excel-for-insurance-agents-on-mac-1-fd15c4.jpg)

## What insurance agents keep in Excel on Mac

The same few files show up on most agency desks. Each file has a grain, meaning what one row represents. Pick the grain before you type anything. A policy list uses one row per policy term. A client list uses one row per person or household. Mixing the two breaks every total you build later.

- Renewal tracker: policy number, client, carrier, premium, renewal date, and status.
- Commission reconciliation: carrier statement lines matched to your policy list.
- Prospect list: name, line of business, lead source, and next follow-up date.
- Premium audit notes: what the carrier billed compared with what you quoted.
- Producer or book report: a pivot by carrier, line, or producer.

Keep one file per job. A renewal tracker and a commission check can share a workbook. Separate files are easier to send and easier to lock down. Name each file with the carrier or the month, such as Renewals or Commission March.

## Build an Excel renewal tracker on Mac that lasts a year

Start with a clean table. Click any cell inside your data, then press ⌘ T. Excel asks whether the table has headers. Keep the box checked if row 1 holds labels. A table grows as you add rows, and formulas fill down on their own.

Name the table when you create it. Naming at creation became generally available on Mac in October 2026. Look for the Table Design tab, then the Table Name box at the left. Call the table Policies, not Table1. Formulas then read as Policies[Premium], which you can still understand months later.

| Column | What goes in it | Format tip |
| --- | --- | --- |
| Policy Number | Carrier policy ID, exactly as printed | Format the column as Text before you paste IDs |
| Client | Named insured, last name first | Keep one spelling for each client |
| Carrier | Carrier name from a drop-down list | Use Data > Data Validation to limit entries |
| Premium | Annual premium as a number | Currency format, with no typed symbols |
| Renewal Date | Date the policy comes up for renewal | Enter real dates, not text such as Jan 3 |
| Status | Quoted, bound, renewing, or lost | Use the same words every time |

_A starting layout for a renewal tracker. Adjust the columns to fit your lines._

## Set up Data Validation so carrier names stay clean

Free-text carrier names split your pivots. One row says Acme Mutual and another says Acme Mutual Insurance. A pivot treats those as two carriers. Build a short list on a sheet named Lists. Then select the Carrier column and go to Data > Data Validation. Choose List and point it at the Lists sheet.

## Find renewals in the next few weeks with FILTER

Put the look-ahead window in one cell and name that cell DaysAhead. Then type this formula in an empty cell. FILTER is part of Microsoft 365 on Mac, and it spills the matching rows for you.

=FILTER(Policies, (Policies[Renewal Date]>=TODAY()) * (Policies[Renewal Date]<=TODAY()+DaysAhead), "None due")

Read it in plain words. Keep each row where the renewal date falls between today and the window you set. If nothing matches, the cell shows None due. Wrap the whole formula in SORT when you want the list in date order.

Two things break this formula. Dates stored as text fail the test, so FILTER skips them. Blank renewal dates drop out too. Scan the Renewal Date column for blanks before you trust a short list.

Add conditional formatting for the same window if you like color. Go to Home > Conditional Formatting > New Rule, choose the formula rule, and reuse the same date test. Color helps while you scroll. FILTER helps when you need the list.

## Commission checks with XLOOKUP and TRIM in Excel

A carrier statement and your policy list hold the same policy numbers in different shapes. One side has a trailing space. The other stores numbers as text. XLOOKUP then returns #N/A even though the policy exists. TRIM fixes the space. Matching the data type fixes the rest.

=XLOOKUP(TRIM(A2), Policies[Policy Number], Policies[Client], "Not in tracker")

The fourth argument matters. It is the text shown when nothing matches. A blank looks clean but hides problems. The words Not in tracker tell you which lines to review first.

For the money check, add a second column. Look up the premium the same way. Multiply it by the commission rate from the carrier schedule. Subtract the amount paid. A difference of zero means the line matches. Anything else goes on your review list.

![Office desk with a computer and paperwork, where commission checks get done](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/insurance-agents-excel/excel-for-insurance-agents-on-mac-3-42ab36.jpg)

## Pivot tables on Mac, and the part Mac leaves out

Click inside the Policies table, then choose Insert > PivotTable. Drag Carrier to Rows and Premium to Values. Build one pivot for each question you hear most. Carrier totals, producer totals, and line of business totals are a good start.

Mac does not have Power Pivot or the Data Model. A February 2023 Microsoft Tech Community thread says Power Query for Mac does not support them. A community member wrote that, and no Microsoft staff reply appears. Treat it as a strong warning. If your book report needs the Data Model, build it on a Windows PC.

For the full menu walkthrough, read [how to make a pivot table in Excel on Mac](https://www.lazur.app/how-to/make-a-pivot-table-in-excel). It covers field layout and the fixes people need most often.

## Excel for Mac versions, limits, and 2026 changes

Check your version before you chase a missing feature. Open Excel > About Excel from the menu bar. Microsoft lists macOS 12 or later, and app version 16.83 or later, as the minimum for Microsoft 365 apps on Mac. The newest Mac build in its release notes is 16.114.3, dated October 27, 2026. That update is quality fixes only.

| Check | What to look for | Where to look |
| --- | --- | --- |
| macOS version | macOS 12 or later for current Office apps | Apple menu > About This Mac |
| Excel version | 16.83 or later, with 16.114.3 the newest build listed | Excel > About Excel |
| Table naming | Names set at creation, generally available on Mac since October 2026 | Table Design > Table Name |
| Power Pivot and Data Model | Not available on Mac, per a community thread | Build that work on Windows |
| Worksheet size | 1,048,576 rows by 16,384 columns | Microsoft's specifications page |

_Mac checks for an insurance workbook, as of November 2026._

Excel 16.113, dated September 16, 2026, added Copilot change history, chat history, and chart and PivotTable skills for Mac. Those are Microsoft's features. Lazur is a separate app. Do not expect one to replace the other.

- **1,048,576** rows per Excel worksheet, with up to 16,384 columns. A policy export rarely comes close. ([source](https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3))
- **94%** of operational spreadsheets examined contain at least one error, per DataHub Pro's summary of Raymond Panko's research ([source](https://www.datahubpro.co.uk/what-percentage-of-spreadsheets-have-errors))
- **46%** of independent agencies report using AI, up from 15% in 2024. This counts AI use in general, not Excel. ([source](https://www.independentagent.com/news/big-i-and-future-one-release-2026-agency-universe-study/))

## Spreadsheet mistakes that cost insurance agents time

Spreadsheet errors are common. DataHub Pro summarizes Raymond Panko's audit research and says about 94% of operational spreadsheets contain at least one error. That is a secondary source. Use it as a reason to check, not as a rate for your agency.

- Leading zeros vanish. A policy number that starts with zero loses it when Excel reads the entry as a number. Format the column as Text before you paste IDs.
- Merged cells break sort and filter. Use Format > Cells, then Alignment, and choose Center Across Selection instead.
- Dates typed as text sort in the wrong order. Select the column and fix the entries before you filter.
- Totals typed by hand go stale. Use a formula that reads the table, so new rows count.
- Two versions of one file drift apart. Keep one master copy and save dated copies for sending.

Each of these is quick to fix once you see it. The hard part is catching it before the carrier does.

## Step by step: a month-end commission check

1. Export the carrier statement to a new workbook. Never type over the carrier file.
2. Turn the statement into a table with ⌘ T, then name it Statement in the Table Design tab.
3. Add a Client column with =XLOOKUP(TRIM(A2), Policies[Policy Number], Policies[Client], "Not in tracker"). The table fills it down.
4. Add a Premium column with the same lookup, returning Policies[Premium].
5. Add a Paid Diff column that compares the amount paid with the premium times the commission rate on your schedule.
6. Filter Paid Diff for anything that is not zero. Use the filter arrow in the header.
7. Filter Client for Not in tracker. Those policies may be new, cancelled, or mistyped.
8. Copy the exceptions to a sheet named Review. Send that list to the carrier or the producer who owns the file.
9. Fix the tracker, check the Client column again, and save a dated copy.
10. Insert a PivotTable from the Statement table with Insert > PivotTable for the monthly summary by carrier.

Ask Lazur at step three to explain the formula you pasted. Hold ⌥ ⌘ and ask in plain words. Lazur reads what is on screen and answers out loud.

## Where Lazur helps in Excel, and where it does not

Hold ⌥ ⌘ to ask about anything on screen. Lazur sees your screen only while you hold the shortcut. Ask where something is, and it draws a circle and a label around it. Ask how to do something, and it guides you one click at a time, waiting for each click.

Lazur does not click buttons, edit files, or run Excel for you. It is not an add-in for Excel. You make every change. Lazur tells you what to change and why.

## Dictate file notes without typing them twice

Hold fn to dictate clean, formatted text at the cursor in any app. Use it for file notes, call summaries, and carrier follow-ups. Keep numbers out of dictation. Type policy numbers and premiums yourself, then check them. Dictation can mishear an ID.

Snippets help with phrases you repeat, such as a standard note about a missing signature. A personal dictionary helps with carrier names that speech tools often get wrong. Clipboard slots keep a policy number handy while you look up the next one.

## Privacy for client data in Excel on Mac

Your sheet holds client names and premiums. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models.

Screenshots still leave your Mac when you ask a question. Check your agency's rules first. When you can, hide personal columns or ask about the formula instead of the data. A formula explains itself without the client names.

## A quick checklist before you trust the sheet

- The row count matches the carrier statement, minus the header row.
- The statement total ties to the carrier's own summary total.
- No #N/A or Not in tracker lines remain unreviewed.
- A few policies match by hand against the carrier's portal.
- A dated copy is saved before the file goes anywhere else.

If a check fails, go back to the step that feeds it. Fixing the output alone hides the cause.

## Next steps for insurance agents on a Mac

Make a copy of your live renewal tracker and try the FILTER formula on the copy first. See [Excel on Mac with Lazur](https://www.lazur.app/apps/excel) for wider Excel help. Email follow-ups usually live in Outlook, so [Outlook for insurance agents on Mac](https://www.lazur.app/for/insurance-agents/outlook) is the next read.

When you want Lazur on your Mac, [download it](https://www.lazur.app/download). The [pricing page](https://www.lazur.app/pricing) lists the trial and the plans. Dictation is included on every plan.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Lazur, where is the Renewal Date column?”: Lazur draws a circle and a label around the Renewal Date header. You sort or filter from there, and Lazur stays out of the file. (Points at it)
- “Lazur, where is the Renewal Date column in this sheet?”: Lazur draws a circle and a label around the header, so you can sort or filter it fast.
- “Why does this lookup show Not in tracker for this policy?”: Lazur reads the formula on screen and explains the likely cause, such as a stray space in the policy number.
- “Walk me through a pivot table of premium by carrier.”: Lazur guides you one click at a time, waiting for each click, starting at Insert > PivotTable.
- “Draft a note to the carrier about a premium that does not match.”: Lazur drafts a short, plain email you can edit before you send it.
- “Dictate my file note for this renewal.”: Hold fn and the note lands at the cursor, with clean formatting. Check any numbers you dictated.
- “Research whether this carrier writes small restaurant liability accounts.”: Lazur runs the research in its own Chrome tabs and returns a summary and a report.
- “Remind me Friday to send the renewal list.”: Lazur adds the item to Apple Reminders for Friday.
- “Set a timer for my carrier callback.”: Lazur starts the timer by voice, so you can keep your hands on the file.

## FAQ

### Does Excel for Mac have what insurance agents need?

Most of the core work runs fine on Mac. That includes tables, FILTER, XLOOKUP, and pivot tables. The main gap is Power Pivot and the Data Model, which a community thread says Mac lacks. Check Excel > About Excel first.

### What macOS version do I need for Microsoft 365 Excel?

Microsoft's update page lists macOS 12 (Monterey) or later as the minimum for Microsoft 365 apps on Mac. It also lists app version 16.83 or later. Check both before you troubleshoot a missing feature.

### Why does XLOOKUP return #N/A on my commission sheet?

The usual cause is a stray space or a number stored as text. Wrap the lookup value in TRIM and check the format of both columns. Add a fourth argument such as Not in tracker, so missing matches show clearly.

### Can Lazur fill in my renewal tracker for me?

No. Lazur guides, points, explains, answers out loud, and drafts text. It does not click buttons or edit your file. You type or paste the values yourself, and Lazur can help you choose the formula.

### Is client data safe if I use Lazur while I work in Excel?

Lazur looks at the screen only while you hold the shortcut. Audio and screenshots go to AI providers to answer and are not stored. Content is never used to train AI models. Still, check your agency's rules and hide personal columns when you can.

### Why did my dates sort in the wrong order?

The dates are probably stored as text. Excel sorts text alphabetically, so a date entry can land in the wrong place. Select the column, look for the Number Stored as Text warning, and convert the entries to real dates.

### Can Mac Excel handle a large policy export?

Excel's worksheet grid holds 1,048,576 rows by 16,384 columns. A policy export rarely comes close to that size. Slow files usually come from heavy formulas, many links, or very large pivots rather than the grid limit.

### Is Copilot in Excel the same as Lazur?

No. Copilot in Excel is a Microsoft feature. Excel 16.113 added Copilot change history, chat history, and chart and PivotTable skills on Mac. Lazur is a separate Mac app that points, explains, and guides you.

### Does Lazur work with Excel on Windows?

Lazur runs on macOS, on Apple silicon and Intel Macs. Windows is planned, not available. If you use Excel on a Windows PC, this guide still helps with the formulas, but Lazur will not run there.

## Sources

1. [Update Microsoft 365 or Office on your macOS or iOS device](https://support.microsoft.com/en-us/office/lifecycle/officeinstall/update-m365-office-macos-ios), Microsoft Support, checked 2026-11-06
2. [Release notes for Office for Mac](https://learn.microsoft.com/en-us/officeupdates/release-notes-office-for-mac), Microsoft Learn, checked 2026-11-06
3. [What's New in Excel (October 2026)](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-october-2026/4549758), Microsoft Tech Community, checked 2026-11-06
4. [Refresh Power Query loaded to Data Model in Excel Online OR in Mac](https://techcommunity.microsoft.com/discussions/excelgeneral/refresh-power-query-loaded-to-data-model-in-excel-online-or-in-mac/3749712), Microsoft Tech Community, checked 2026-11-06
5. [Excel specifications and limits](https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3), Microsoft Support, checked 2026-11-06
6. [What % of Spreadsheets Have Errors? (DataHub Pro)](https://www.datahubpro.co.uk/what-percentage-of-spreadsheets-have-errors), DataHub Pro, checked 2026-11-06
7. [Big 'I' and Future One Release 2026 Agency Universe Study](https://www.independentagent.com/news/big-i-and-future-one-release-2026-agency-universe-study/), Independent Agent (Big I), checked 2026-11-06