Copilot in Excel: Setup and Uses for Accountants 2026

Find out which licence turns on Copilot in Excel, how to use it on a client workbook and how to check its formulas before the figures reach a client file.

Published
Updated

Copilot in Excel opens a pane that can explain formulas, answer questions and edit a workbook. Use a fictional file to check your setup.

What Copilot in Excel Can Do

Ask Copilot to explain an existing formula or suggest one from a description. It can answer questions about the open workbook, summarise an Excel table and chart the values.

Where available, ask the @clean-data skill to flag duplicate values, extra spaces or numbers stored as text. Review its suggested fixes and choose which to apply.

The Excel agent can carry out several changes in one request. For example, it can group expenses by account, put the summary on a new sheet and build a chart from it.

Choose Plan to review and confirm the proposed steps before Copilot starts. In Allow editing mode, it can change cells as it works. Choose Chat only for an explanation in the pane with the workbook untouched.

Microsoft also asks you to confirm which sources to use when Copilot searches across your work files. A new chat starts with a fresh set of approvals. See Microsoft’s guide to using Copilot in Excel.

Licences, Free Access and Enabling Copilot

Microsoft’s free consumer Copilot is a separate chat. Copilot inside Excel needs an eligible Microsoft 365 or Copilot subscription. Eligible business and enterprise subscriptions can include standard Excel access without a Copilot add-on.

Microsoft labels standard business access M365 Copilot (Basic). A commercial Copilot add-on gives priority access, labelled M365 Copilot (Premium). Microsoft 365 Personal or Family with an AI credits plan and Microsoft 365 Premium are also eligible.

Microsoft bills the Business add-on per user. It also bundles Copilot with some Microsoft 365 business subscriptions. For current Australian costs, see Microsoft’s Copilot business pricing.

  1. Sign in to Excel with the eligible account. For an assigned work licence, use the account shown against your name in the Microsoft 365 admin centre.
  2. Create an editable .xlsx practice workbook. Save it in your practice’s approved OneDrive or SharePoint location. Set Formulas > Calculation Options to Automatic if you want Copilot to edit cells.
  3. Select the Copilot button at the bottom right of the worksheet on Windows, Mac or the web. If you moved it to the ribbon, open it there.
  4. Choose Chat only. Put 18 and 24 in B2 and B3. Ask for the sum of B2:B3. Check that Copilot returns 42 in the pane and leaves both cells unchanged.

If your practice assigned a licence and the button is missing, check that you’re signed in with your work account. Refresh your licence and restart Excel on the desktop. On the web, reload and confirm the signed-in account.

  • On Windows, check File > Account > Product Information. Copilot needs Current Channel or Monthly Enterprise Channel. Ask your admin to switch from Semi-Annual Enterprise Channel or try Excel on the web.
  • On Windows or Mac, update Office. Ask your admin whether the practice allows connected experiences that analyse content.
  • If the pane opens but cannot edit a certain workbook, check its format and storage. Try a modern .xlsx copy in OneDrive or SharePoint. Check in a SharePoint file that is checked out, then reopen it.

For each platform’s licence refresh steps and web browser settings, follow Microsoft’s missing Copilot button guide.

The COPILOT Function and Formula Help

Microsoft retired the preview worksheet function =COPILOT. It accepted a prompt and cell references and returned an AI response in a cell. Old cells can still show cached results, but they return #NAME? when they recalculate.

The Copilot pane can write an ordinary Excel formula. The formula then runs as Excel calculation. With fictional invoice amounts of $900 in B2 and $250 paid in C2, ask the pane for the balance due in D2.

A formula for that request is =B2-C2. The expected balance is $650. Change C2 to $900 on your copy and check that the formula returns zero.

In the old preview, a classification call looked like =COPILOT("Classify as Rent or Utilities", A2). If A2 contains “Office rent”, the expected label is Rent. The old call now returns #NAME? on recalculation.

To do that job today, put “Office rent” in A2 and “Electricity bill” in A3. Ask Copilot in the pane to classify A2:A3 into Rent or Utilities in B2:B3. Check for Rent and Utilities, in that order.

Microsoft’s COPILOT function reference explains the behaviour of existing workbooks.

Client Workbooks and What Copilot Can Read

Copilot can read the open workbook. With a commercial Microsoft Copilot subscription, the Work source can find documents the signed-in user already has permission to view. Those can include documents in shared OneDrive or SharePoint folders.

Before staff use it, check who can open each client folder. Review sharing links and inherited group access. Ask someone with a normal staff account to check access to a folder outside their assigned client work.

The practice’s commercial Microsoft agreement governs work prompts and responses. Microsoft says it excludes those prompts, responses and Microsoft Graph data from foundation model training. Using a consumer chat puts client data under that service’s own terms.

Registered tax practitioners need client permission before disclosing client information to a third party, unless a legal duty requires it. Apply the same confidentiality rule to your use of AI. See the Tax Practitioners Board’s guidance.

Reduce the client information that reaches any model. For instance, Tax Genie removes every tax file number from submitted client forms before its AI review. Apply the same principle to any workbook copy you prepare for Excel.

Accounting Tasks and Prompts for Copilot in Excel

Prepare a separate table for each set of fictional figures. Select the range, choose Insert > Table and confirm that it has headers. Use one header row and keep merged cells outside the table.

Name each table on the Table Design tab. Several analysis features need a table or a similarly structured range. Include the table or range in each prompt so you can trace the result.

TaskPromptManual Check
Reconcile a bank exportMatch BankRows to LedgerRows on reference and amount. List unmatched and duplicate references in chat.Check one known match against both exports and confirm a duplicate appears for review.
Explain a varianceUse Periods!A2:C30 to show the five largest changes by absolute value. Cite the rows and report current less prior period.Recompute a negative variance and check its sign.
Build a PivotTable by accountBuild a PivotTable from JournalRows on a new sheet. Put Account in Rows and sum Amount in Values.Compare its grand total with the sum of the source amounts.
Write a lookup across sheetsIn Invoices!D2, use the invoice’s client code in C2 to return its name from Clients!A2:B20. Use an exact match and show Missing when the code is absent.Test a known code and one that does not exist in Clients.
Draft a commentary lineUse Report!B4:D4 to draft a sentence on the change in office expenses. Name the supporting cells and use only the figures in the range.Trace the figures to the report and remove any cause that the worksheet does not show.

Review Copilot’s Output Before You Rely on It

Read each formula that Copilot writes. Check the ranges and signs against the source workbook. Test at least one row with a known answer and one that would expose a missed match or an incomplete range.

Compare the reported totals with the source. If Copilot edited the workbook, check its changes on a copy before carrying them into the file your team uses.

Microsoft advises you to review and verify its generated results before relying on them. The practitioner signing the work is responsible for the totals and the conclusions that go to the client.

Turn Copilot Off in a Client Workbook

For a personal Microsoft account, clear Enable Copilot in the desktop app. On Windows, go to File > Options > Copilot. On Mac, open Excel > Preferences and select Copilot under Authoring and Proofing Tools.

Restart Excel. The setting applies to Excel on that device. Microsoft’s personal-account instructions cover supported versions. The desktop switch is unavailable for work accounts and in Excel on the web.

To pause Copilot in desktop Excel during a client-folder review, use Office Cloud Policy for the affected users. Set “Allow the use of connected experiences in Office that analyze content” to Disabled. This also affects apps such as Word.

Microsoft manages work access to Copilot in Excel as part of Copilot Chat. Integrated Apps can block broader Copilot Chat access for selected groups, including in Teams, Outlook and web chat. See Microsoft’s access controls.

After applying the policy, open the workbook as an affected staff user and check desktop Excel. Check Excel on the web separately.

One client form. One finished return.

Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.

See how Tax Genie works

Made for Australian accounting firms

Tax GenieSee how Tax Genie works