What do I need before using Copilot in Excel?
For workplace use, sign in with the approved work or school account and have the administrator confirm your eligible subscription, app version and tenant settings. Microsoft's Excel FAQ lists eligible business subscriptions and distinguishes standard M365 Copilot (Basic) access from paid M365 Copilot (Premium) priority access2.
Windows, Mac and web support the edit, plan and chat modes described in Microsoft's setup guidance; mobile support differs1,2. This exercise is for one of those desktop or web environments. If the button or a mode is missing, resolve access with your administrator instead of assuming the workbook is wrong.
The product documentation now uses Microsoft Copilot while some account labels still include Microsoft 365 Copilot3. Training fees do not grant a licence or change app permissions. Confirm the capabilities needed for the task before choosing the workshop or starting a business-data pilot.
How do I prepare the fictional sample workbook?
Download the CSV linked here and open it in Excel. Save a separate workbook copy in an organisation-approved location. Keep the downloaded input unchanged. Give the sheet a clear name, convert the data to an Excel table and name the table Orders. These are preparation steps for this exercise.
The sample has order_id, category, net_nzd, due_date and paid_nzd columns. All records are fictional and amounts are practice values in NZD, not quotes or training prices4. Format the amount columns as numbers and the due_date column as dates. Check that Excel has recognised the dates rather than kept them as text.
Clear headers and one record per row make the input easier for a person to inspect. The table below shows the unchanged sample. Keep the row count and order IDs visible so you can tell whether a summary includes the expected records.
How do I run Copilot in Excel without changing the workbook first?
Open the Copilot control. Microsoft's current guide places the dynamic Copilot icon at the lower-right of Excel and describes edit, plan and chat modes1. Choose chat for the initial explanation, where the response stays in the chat rather than directly editing the workbook.
Ask it to describe the Orders columns and propose a balance_nzd formula equal to net_nzd minus paid_nzd. Require it to state which table it used and whether any input rows are missing. Tell it to keep the workbook unchanged for this question. The relevant input values are in the fictional CSV4.
Read the response before asking for more. It should describe a subtraction of paid from net. If it instead adds the amounts, treats the paid column as a percentage or uses another range, correct the request. Confirm that the answer refers to Orders rather than an unrelated sheet.
How do we inspect a formula before using it?
The expected table formula for a balance column is =[@net_nzd]-[@paid_nzd]. Add it yourself in the practice copy, or ask for a plan that proposes that specific new column. If you choose an editing action, inspect the plan and the changed cells. Microsoft documents plan mode before edits and direct workbook changes in edit mode1.
Check a paid-in-full row and a partially paid row. O1 has net and paid values of 1200.00, so its balance is zero4. O2 has net 800.00 and paid 200.00, so its balance is 600.004. Calculate both results outside Copilot before trusting the whole column.
Look down the formula column for a fixed reference accidentally copied into every row. Check blanks, text formatted as numbers and unexpected negative balances. Those cases need an explanation before a summary is accepted. The task here is a simple practice calculation; a real finance workbook can have different business rules.
How do I use Copilot in Excel and check that its answer is correct?
Ask for total net, total paid and total balance from Orders. Require the calculation and the row count. For the unchanged sample, total net is 3300.00, total paid is 1800.00 and total balance is 1500.004. Compare with Excel SUM results in the practice workbook.
Ask which unpaid balances were due before the fixed review date of 14 October 20264. Use that date explicitly so another person can reproduce the same result. The sample includes a later-due unpaid order; that row should contribute to total outstanding but not this overdue subset.
The expected overdue list is O2 with a balance of 600.00 and O5 with 300.00, for an overdue total of 900.004. O3 has an unpaid balance of 600.00 but is due later in the scenario4. O1 and O4 are fully paid, so an overdue filter needs the unpaid condition as well as the due date.
Use an Excel filter or a separate calculation to verify the list. Read the included order IDs and the excluded ones. A total can happen to match even when the wrong rows were selected. Keep the source row count and the cutoff date with the review note.
How can we check a category summary or chart?
Ask for a category summary of total balance and the order IDs behind each subtotal. Parts has a total balance of 900.00 and Service has 600.00 in the sample4. Both include all outstanding amounts, regardless of due date. If you instead want only overdue balances, say so and keep the cutoff in the request.
Check the summary with a PivotTable or SUMIF calculation you understand. If Copilot proposes a chart, read its source range, category labels and units before inserting it. Microsoft's setup guidance describes workbook charts and PivotTables as supported outputs1. A chart title should match the actual subset it shows.
An outstanding-balance chart and an overdue-balance chart answer different questions. Keep that distinction in the heading and review note. Avoid a polished chart that suggests an unpaid amount is already overdue or that omits a category without explanation.
What should I check when Copilot cannot complete the task?
If the control is missing, Microsoft directs users to check app, licence, network and privacy requirements2,3. Ask the administrator about the account and configuration you actually have. This guide does not ask staff to disable an organisational security setting to make the demo work.
If an answer is wrong, narrow the request to one column or a pair of rows. Confirm that the data is numeric and the due dates are dates. Check whether the selected range includes the whole table and whether a filter changed what you expected to count.
If the output changes a formula or layout you did not request, stop and compare with the original. Restore the practice copy or make a new one rather than patching unknown changes into a live workbook. Record the proposed action and the unexpected result so the team can improve the prompt or choose a different task.
Why is the Copilot button missing, and what do we check first?
Microsoft lists app version, licence, network and privacy settings among the requirements to investigate when the button is absent2. Record the signed-in account and the exact error before changing anything. Ask your Microsoft administrator to check the organisation’s setup; buying an add-on is not an automatic first step.
When the button appears but an exercise fails, distinguish access from workbook problems. Keep a copy of the file and try the smallest permitted sample that reproduces the issue. That gives support a useful description without sending an entire financial workbook. Do not bypass an organisation setting simply to complete a training task.
For a wrong formula, inspect the proposed references before trying another prompt. Test an ordinary row, an empty input and a reversal. Compare the output to a calculation you can explain. If the result changes under a filter or after adding a row, identify whether that is intended before reusing the formula.
| Symptom | Check | Next action |
|---|---|---|
| No Copilot button | Account, entitlement, app version and admin settings2 | Record the environment and ask the administrator |
| Unsupported file state | SharePoint checkout state and workbook format2 | Follow the documented file-state remedy on an approved copy |
| Editing unavailable | Calculation mode; editing requires Automatic2 | Confirm the workbook owner agrees before changing settings |
| Unexpected total | Range, sign, blank cells and filtered rows | Reconcile with independent arithmetic |
| Plausible but unsupported explanation | Whether the source contains evidence of the claimed cause | Replace the claim with a question for the owner |
What changes before we use a real finance workbook?
Have the organisation approve the tool, purpose and allowed information. Keep customer identities, bank details and payroll records out of training examples. A working Microsoft account and a familiar spreadsheet are not enough to decide that a client file may be processed.
Microsoft says Copilot respects the user's existing view permissions and that prompts, responses and Graph-accessed data are not used to train foundation models5. Those commitments do not replace checking folder sharing, sensitivity rules and the reviewer responsible for the output.
Define the business rule before requesting a calculation. Real debtors can involve credits, disputed invoices, part-payments and different due-date rules. Have the finance reviewer decide how those cases should be represented. The fictional exercise tests a plain subtraction and date filter; it does not decide accounting treatment.
Which course helps staff practise Excel and finance checks?
Choose Copilot for Excel and finance for workbook questions, formula inspection and reviewed reporting. Choose foundations if staff need the basic account distinction and prompting method first. Bring a cleared task and tell us which Excel app and Copilot experience each attendee can access.
Private training can run at your workplace anywhere in New Zealand or live remotely. The existing free Copilot introduction gives individual practice before a facilitated session. Software accounts and their usage terms remain separate from the training booking.
Use this sample as a shared check after training. Give another staff member the unchanged CSV and the fixed review date, then ask them to explain the balance and overdue results. A repeatable review is useful evidence that the team understands the task, even if it uses a different prompt or completes the calculation manually.