Microsoft 365 Copilot: Prices, Licenses and Practice Fit

What is Microsoft 365 Copilot, and is it included in Office 365?

Microsoft 365 Copilot provides AI assistance, including documented workbook editing in Excel, but it is not included in every Microsoft 365 subscription. Microsoft says a missing Excel Copilot icon can mean your subscription does not include it or your organization has disabled it.

Microsoft’s enterprise data protection page now uses the name Microsoft Copilot (and Copilot Chat). Official pricing pages still use Microsoft 365 Copilot plan names, so check the exact subscription rather than relying on the Copilot label.

For individuals, Microsoft 365 Family restricts AI features to the subscription owner. Microsoft 365 Premium includes advanced Copilot chat. A limited free version also exists, subject to available capacity and limits; that does not establish which in-app capabilities your subscription includes.

Our Copilot plans and professional-fit guide provides another starting point for evaluating the product.

Price and license: which Copilot plan should you budget for?

Budget for the exact plan and billing commitment, not just the advertised monthly equivalent. These are official US prices in USD, excluding tax; local prices, taxes and rules differ in the UK, Australia and India and must be checked locally.

Prices and plans checked 2026-10-19 on Microsoft’s official pricing pages.

The Business add-on’s $25.20 monthly subscription auto-renews. Its $18 promotional rate requires an annual commitment and applies only in the first year. The enterprise add-on’s $31.50 monthly payment also requires an annual commitment: it is not a month-to-month option.

Is Copilot worth it for a practice of 1, 5 or 20 seats?

Copilot is a reasonable candidate when the documented workflow fits, but seat count alone does not justify buying it. Compare the add-on with a “with Copilot” plan and confirm eligibility, data terms and review responsibilities before committing.

For 1 seat, Microsoft 365 Premium costs $19.99 per month or $199.99 per year for advanced Copilot chat. For organizational use, compare the Business add-on with Business Standard with Copilot: 1 × $23.50 = $23.50 per month billed annually, or 1 × $28.20 = $28.20 monthly. Prefer the option that fits your existing subscription and approved terms; consumer pricing alone is not a confidentiality assessment.

For 5 seats, Business Standard with Copilot is 5 × $23.50 = $117.50 per month billed annually, or 5 × $28.20 = $141 monthly. The Business add-on is 5 × $18 = $90 per month billed annually in the promotional year, or 5 × $21 = $105 at the annual-billing list price; monthly subscriptions total 5 × $25.20 = $126. If considering the add-on, confirm the underlying subscription requirements and budget for any separate base-plan cost.

For 20 seats, Business Standard with Copilot is 20 × $23.50 = $470 per month billed annually, or 20 × $28.20 = $564 monthly. The Business add-on totals 20 × $18 = $360 per month billed annually in the promotional year, or 20 × $21 = $420 at list; monthly subscriptions total 20 × $25.20 = $504. Business Premium with Copilot is 20 × $32 = $640 per month billed annually, or 20 × $38.40 = $768 monthly.

A 20-seat practice is within the Business add-on’s 300-user cap. Before an annual commitment, evaluate a representative workflow using synthetic or approved nonconfidential files, including the time needed to check the output.

What separates enterprise data protection from consumer use?

Microsoft documents organizational contractual protections under its Data Protection Addendum (DPA) and Product Terms, with Microsoft acting as data processor. We have not verified each plan’s own data/privacy terms for this page, including consumer terms; read those terms and your professional confidentiality rules before submitting client, patient or employee data.

The enterprise data protection page, checked 2026-10-20, states that organizational prompts and responses receive the same contractual protections as Exchange email and SharePoint files. It describes encryption at rest and in transit, respect for organizational permissions, sensitivity labels, retention policies and audit, and no use of prompts, responses or Microsoft Graph data to train foundation models. These are vendor statements, not an independent audit.

Web search queries go to Bing under separate data-handling practices, with Microsoft acting as an independent controller. Treat web search as a separate data-handling question when approving a workflow.

Model availability also needs review: the model documentation says the tenant must enable the Anthropic subprocessor for Claude Fable 5.1. GPT 5.5 (Frontier) is hosted in Azure AI Foundry. Neither fact establishes that a particular workflow meets your professional obligations.

Our guide to AI for lawyers helps frame confidentiality and verification questions.

How should you use Copilot in Excel for professional work?

Start with Excel’s plan mode so you can review proposed changes before editing. Open Copilot using the lower-right icon; edit mode is the default and changes the workbook directly, while chat answers without changing it.

Microsoft says Copilot creates a step-by-step plan after a prompt, lets you watch changes live and provides a Stop button. Its documented tools include worksheet editing, cross-sheet formulas and data generation, charts, PivotTables, shapes, insights, sorting, filtering and conditional formatting. It can search the web with citations, import data from OneDrive, SharePoint or local workbooks, and run custom skills. Output remains editable using Excel’s own tools.

Platform support checked 2026-10-20: Windows, Mac and web support edit, chat and plan. iPad supports chat and plan, with edit rolling out; iPhone supports chat, with edit rolling out; Android supports chat.

Use a synthetic workbook for this reconciliation prompt. Row-by-row comparison assumes the bank and ledger entries are already aligned, so ask Copilot to check that assumption.

Use plan mode. Do not edit until I approve.
In "[SHEET NAME]", column A contains dates, B descriptions,
C bank amounts and D ledger amounts.
Check whether the rows appear aligned for comparison.
Propose a formula in column E flagging differences above [TOLERANCE].
Propose a PivotTable summarizing flagged amounts by month.
List assumptions, missing data and checks needed before approval.
Do not invent transactions or resolve unexplained differences.

For generic correspondence drafting, use placeholders rather than confidential details. This prompt does not establish Outlook-specific functionality or limits.

Draft a brief reply to [CLIENT NAME] about [TOPIC].
Use a plain tone and make no promises about outcomes.
State that the engagement letter dated [DATE] governs scope.
Ask for confirmation of [SPECIFIC ITEM] by [DEADLINE].
Use only supplied facts and figures; flag anything missing.

Use our prompt library for accountants for further task templates, or consult AI for sales managers when planning a pipeline-data workflow.

The COPILOT worksheet function was retired starting September 14, 2026. It was a preview restricted to the Frontier and Microsoft 365 Insider programs. Existing calculated results remain cached, but recalculation returns #NAME?. Microsoft recommends the Copilot pane instead, for example asking it to summarize feedback in A2:A20 or classify sentiment in B2:B100 into a new column. Review templates that depend on the retired function.

Model information checked 2026-10-19 on Microsoft’s model documentation and roadmap:

• Auto is the default Copilot Cowork router, selecting from organization-enabled models.
• GPT 6 Astra and Claude Fable 5.1 are flagship options, released 2026-09-04 and 2026-09-01 respectively.
• Claude Opus 5 is a high-tier option released 2026-07-24; Claude Sonnet 5 is the everyday option.
• GPT 5.6 Sol is high-tier, released 2026-07-09; GPT 5.6 Terra and GPT 5.5 (Frontier) are balanced options.
• Claude Opus 5.5, high-tier, and GPT-6 Sol, balanced, were announced on 2026-09-22; rollout status was not confirmed.

GPT-5, GPT-5.2, Claude Opus 4.8 and Claude Opus 4.7 are older names still visible on vendor pages, not the current lineup. These vendor labels are not quality scores.

Limits: what a licensed professional must check

This is not legal, medical or tax advice. A licensed professional in your jurisdiction must check applicable confidentiality duties, engagement terms and whether the proposed data handling is permitted. Review formulas, PivotTables, figures and drafts before client use.

In the US, HIPAA Privacy Rule 45 CFR 164.502(e) requires a covered entity to obtain satisfactory assurance through a business associate agreement before disclosing protected health information to a business associate. An AI vendor receiving PHI is a business associate. Organizational protection statements alone do not establish that this requirement has been met.

FAQ