Copilot in Excel and Other AI for Excel

Copilot in Excel can write formulas, build editable tables and charts and explain changes in your commission data. If your brokerage already uses Microsoft 365, start in Excel with a workbook with invented data. Check the results against known inputs before trying it on a real statement.

How to Get Copilot in Excel

Open a workbook in Excel, sign in with your eligible Microsoft account and look for the Copilot button near the lower-right corner of the sheet. The button can also sit beside the ribbon if it has been moved.

Microsoft’s Australian individual plans include Copilot in Excel on Microsoft 365 Personal, Family, Premium and Pro. On a shared Family, Premium or Pro subscription, the AI features are for the subscription owner. Personal plans bundle Copilot into the subscription, with different AI allowances by plan.

At work, eligible Microsoft 365 or Office 365 subscriptions can include standard access in Excel, subject to your organisation’s settings. Microsoft 365 Copilot Business is available as an add-on to an eligible base plan or bundled with Business Standard or Business Premium. Enterprise customers can buy the commercial Copilot add-on for eligible licences.

Paid business access is priced per user. Budget for the number of people who need it, the underlying plan and the billing commitment. Microsoft’s Australian business pricing lists the bundles and excludes GST from advertised prices.

If the Copilot button is missing, check the signed-in account first. Update Excel and refresh your licence. On Windows, use File > Account > Update License. On Mac, open About Microsoft Excel, select More Info and choose Refresh License. Restart Excel.

If you use a work account, ask your admin to check access and connected experiences. On a Windows work device, the Current Channel and Monthly Enterprise Channel support Copilot. If your device uses the Semi-Annual Enterprise Channel, try Excel for the web while your admin checks the desktop setup.

What Copilot Can Do in Excel

Use the Copilot pane to ask about your workbook or let Copilot edit it directly. Chat mode keeps the answer in the pane. Use editing mode when you want Copilot to put a formula or chart in the sheet. Excel needs automatic calculation for Copilot editing.

Here are some prompts to try with invented data from two commission statements.

  • Formula. “Add a formula that subtracts Expected trail from Paid trail on each row.” A row with $90 paid and $110 expected must show -$20.
  • Table. “Turn the rows on the Received sheet into an Excel Table with headers so I can filter by lender.” Check that the header row and all received loans are included.
  • Chart. “Make a column chart of Paid trail by statement period for L101.” Check that each column uses the sum for that period and that the vertical axis shows dollars.
  • Summary. “Summarise the change in Paid trail between the two periods for L101. Use only these rows.” If the values are $110 and $90, the summary must show a $20 drop. The figures alone give no reason for the change.

Microsoft retired the preview COPILOT() worksheet function. A workbook might still display a saved result from =COPILOT("Summarise these payment notes",C2:C4). The formula returns #NAME? when recalculated. For the same task, ask the Copilot pane to summarise the invented payment notes in C2:C4. Use ordinary Excel formulas such as SUM and COUNTIF for values that must recalculate.

Some features need cloud storage. Save a workbook to OneDrive or SharePoint Online to use cloud version history, which lets you restore a previous version after an unwanted edit. Copilot can also import from other shared workbooks stored in OneDrive or SharePoint. Current Copilot editing can run with AutoSave on or off, so work in a copy when experimenting with changes.

Use Copilot on a Commission Spreadsheet

Use Copilot to flag expected loan references that are absent from this month’s statement. Start with two sheets in one workbook. Format both loan-reference columns as text before entering data so a reference with leading zeros keeps them.

  1. Name the sheets Expected and Received. Put Loan reference in A1 on both sheets. In Expected A2:A4, enter L101, L102 and L103. In Received A2:A3, enter L101 and L103.
  2. Open Copilot in editing mode. Ask it to add a column named Statement check on Expected and fill it down. Specify that each formula must look for the Expected loan reference anywhere in Received A2:A3. Ask for “Present” for a match and “Missing” otherwise.
  3. Select the first result and inspect the formula bar. A formula in B2 that does the job is =IF(COUNTIF(Received!$A$2:$A$3,A2)=0,"Missing","Present"). The dollar signs hold the Received range in place as you fill down. The Expected reference must change from A2 to A3 and then A4.
  4. Check the three results against the source rows. L101 and L103 must show Present. L102 must show Missing. Replace L103 with L102 on Received and check that the flags for those two loans swap.

On a real file, a mismatch can also come from imported spaces or a reference that lost a leading zero. Check the two source values first. Make sure the formula covers the full statement, including the last row.

Treat a missing reference as a loan to check against the aggregator’s records. A present reference confirms that a row exists, even if the trail amount is short. Use the trail commission reconciliation method to check whether the amounts are right.

Turn Off or Remove Copilot in Excel

With a personal Microsoft account on Windows, open File > Options > Copilot, clear Enable Copilot and select OK. On Mac, open Excel > Preferences, choose Copilot under Authoring and Proofing Tools and clear the same setting. Restart Excel and check that Copilot is disabled.

Repeat on each device where you want it off. The setting is specific to that app and device. Removing the icon from the ribbon only hides that entry point.

Work accounts are managed by your organisation. An admin can remove an assigned paid add-on in the Microsoft 365 admin centre under Users > Active users, then Licences and apps for the user. Standard access can still be available through the base plan.

Microsoft 365 admins can’t turn off Copilot in Excel on its own. Access follows the organisation’s Copilot Chat settings. Use Integrated apps to manage availability of the Copilot app for users or groups.

Unpinning the app by itself leaves web access available. Follow Microsoft’s Copilot Chat access instructions and check the result with a work account in the affected group.

Compare Copilot With Other AI for Excel

Start with Copilot if you want to build tables and formulas in the Excel workbook your brokerage already uses. The other options suit different jobs and can put the same commission data under different privacy terms.

Tool Where it runs and what it reads Formula work Data controls
Copilot in Excel Built into eligible Excel apps. Works on the open workbook and can bring in other files where the plan and permissions allow. Writes Excel formulas across sheets. Check references when filling down. Work access follows Microsoft 365 permissions. Admins control Copilot Chat access.
Claude for Excel Add-in for supported desktop and web versions of Excel. Works across tabs in the open workbook. Explains formula chains with cell references you can inspect. The standard Claude sign-in sends workbook content used in the conversation to Anthropic. The add-in has its own retention behaviour.
ChatGPT for Excel Excel add-in reads relevant workbook context. For a standalone formula question, the regular chat can work from sample headers and invented rows. Can suggest, explain or edit formulas. Name the relevant sheets and ranges in your prompt. The add-in sends relevant workbook context to OpenAI. Workspace admins can manage add-in and app access on supported plans.
Gemini in Google Sheets Side panel in Sheets on eligible plans. Convert an Excel file to native Google Sheets to use its Gemini features. Writes Sheets formulas. Recheck the workbook’s formulas after converting, especially when it returns to Excel. Google says private Workspace content is excluded from training its foundation models. Review the spreadsheet’s Drive sharing settings.

Choose Claude for Excel when you need to follow a commission total through several sheets and want the cells cited. For a one-off formula, ChatGPT can work from a small fictitious sample without a workbook upload. Gemini is a fit when the team already keeps its working records in Google Sheets.

Judge formula quality by whether the result survives a check with known inputs. For a loan matching formula, include an absent loan, a present loan and a loan reference with a leading zero. If the workbook is going back to Excel, check those results there too.

Check Permissions Before Using Copilot

When your work plan lets Copilot search company files, it can draw on files you already have permission to open, including files on broadly shared sites. A commission workbook that everyone at the brokerage can open today can therefore surface in their Copilot answers. Features that pull in other files still depend on the account’s access and your organisation’s settings.

Before opening a client workbook, check who can open the statement folder in SharePoint or OneDrive. Remove links that reach beyond the staff who reconcile commissions and review access inherited from the parent folder. Use the Copilot safety guide to check which other permissions to tighten before you use it on real files.

Track My Trail

Trail analysis, simplified

Less time checking your trail, more time growing your book.

See how it works

7 days free · No credit card

Track My Trail Team

Read more

We develop software to simplify trail book management for mortgage brokers. Our tools provide fast and practical insights to help brokers get the most out of their trail books.

Track My Trail
See how it works

7 days free · No credit card