Microsoft 365 Copilot for Small Businesses in Berlin: What It Actually Does and What It Costs

Microsoft 365 Copilot is the AI layer built into Microsoft 365 applications. It uses large language models combined with your organisation’s data in Microsoft Graph — emails, calendar, meetings, documents, chats — to generate text, summarise content, and assist with tasks inside the tools your team already uses. For Berlin SMBs that have been watching AI productivity tools from a distance, the licensing changes in 2024 and 2025 removed the enterprise-only requirement, making Copilot accessible without a minimum seat commitment.

What Copilot Actually Does App by App

Copilot in Teams is the most immediately useful capability for most SMBs. It can summarise a meeting in real time or from a transcript, list action items with owners, and answer questions like “what did we decide about the contract?” based on the meeting content. For teams that spend significant time in meetings, this alone often justifies the licence cost.

Copilot in Outlook summarises long email threads, drafts replies based on previous conversation context, and helps with tone and length adjustments. It is particularly useful for managers who receive high email volume and need to process it efficiently.

Copilot in Word can draft documents from prompts, rewrite sections for clarity or tone, and summarise uploaded documents. It is not a replacement for subject-matter expertise but materially reduces the time from blank page to first draft.

Copilot in Excel analyses data, suggests formulas, creates charts, and identifies trends. It requires structured table data to function well and is most useful for users who work with data regularly but are not Excel power users.

Copilot in PowerPoint generates slide decks from document descriptions or existing Word documents. Slide quality varies significantly based on the prompt and the template, but it produces a workable starting point faster than building from scratch.

Microsoft Copilot Chat (the web and Teams interface) provides a general-purpose AI assistant grounded in web data (when web search is enabled) or your organisation’s SharePoint and OneDrive content (when in Work mode). This is the entry point for users who want to query internal documents without the per-app premium features.

Licensing: What You Need

Microsoft 365 Copilot requires a base Microsoft 365 licence plus the Copilot add-on. The eligible base licences for SMBs are Microsoft 365 Business Basic, Business Standard, and Business Premium. The Copilot add-on is approximately $30 USD per user per month.

Note the distinction: Microsoft Copilot Chat (the general-purpose AI assistant, formerly Bing Chat Enterprise) is included at no additional cost in all M365 Business licences. The $30/month Copilot licence unlocks the in-app integration within Word, Excel, PowerPoint, Outlook, and Teams. If your team mainly wants AI-assisted search and document summarisation rather than deep app integration, Copilot Chat at no extra cost covers a significant portion of the use cases.

Prerequisites Before You Roll Out

Copilot draws on Microsoft Graph to ground its responses in your organisation’s content. Before enabling Copilot, review what content is accessible to which users in Microsoft Graph. Files that are broadly shared internally — or that have overly permissive SharePoint sharing settings — will be surfaceable to any Copilot user in your organisation, regardless of whether those users would normally navigate to those files.

The mandatory prerequisite checklist:

1. Audit SharePoint sharing settings. Overly permissive sharing (“Anyone with the link”) means those files are potentially reachable via Copilot by users who should not have access to them. Tighten sharing to “People in your organisation” or specific groups before enabling Copilot. The SharePoint admin center provides a per-site sharing report.
2. Review OneDrive sharing. Users’ OneDrive files shared company-wide are also in scope. Audit using the SharePoint admin center Data Access Governance reports.
3. Enable audit logging in Microsoft Purview. Copilot interactions are logged in the Microsoft 365 audit log if audit logging is enabled. You want this for compliance and for reviewing what content Copilot is accessing on behalf of users.
4. Configure sensitivity labels if handling personal data. Documents labelled as confidential or containing personal data should not be summarised and sent elsewhere. Sensitivity labels with protection settings prevent Copilot from including that content in responses to users who lack access.

What Copilot Cannot Do

Setting expectations correctly before rollout prevents disappointment. Copilot does not have access to data outside Microsoft 365 unless it is explicitly connected via Copilot extensibility or Microsoft Power Platform connectors. It cannot query your CRM, accounting system, or line-of-business applications unless those are integrated. It does not have real-time data unless web search is enabled. And it makes factual errors — summaries and drafts require human review before they are used externally.

The current generation of Copilot is a productivity multiplier for knowledge workers who already understand the subject matter they are working on. It is not a substitute for that understanding, and treating it as one is the fastest path to sending incorrect information to clients.

Rollout Approach for Berlin SMBs

A staged rollout reduces risk and builds the internal case for broader adoption. Start with a pilot group of 5 to 10 users who are heavy M365 users, have time to experiment, and are willing to provide feedback. Run the pilot for four weeks, gather specific use-case feedback (which features saved the most time, which produced unreliable output), then expand to the broader organisation with concrete guidance on where Copilot adds value and where to apply human review.

Training is not optional. Users who receive a Copilot licence without guidance typically use it superficially or abandon it after early poor experiences. Microsoft’s Copilot adoption hub provides scenario-based training materials that can be distributed as part of rollout.

What IT Experts Berlin Configures

Our Copilot readiness engagement covers SharePoint sharing audit and remediation, Purview audit logging configuration, sensitivity label review, Copilot licence assignment, and pilot group definition. We also provide rollout communication templates and a post-pilot review framework. Contact us to start with a readiness assessment before purchasing Copilot licences.