Microsoft Copilot for Beginners: AI Inside Word and Excel

Microsoft Copilot for beginners comes in two flavors: a free AI chatbot accessible through your browser, and an integrated AI assistant built into Word, Excel, PowerPoint, and Outlook. The free chatbot competes with ChatGPT and Gemini. The integrated version is the real draw if your workplace runs on Microsoft 365. Here is what each version does and how.

The Two Versions of Copilot

Copilot (Free): Available at copilot.microsoft.com or through Bing. Sign in with a Microsoft account (Outlook, Hotmail, or create one for free). No payment needed. This gives you an AI chatbot similar to ChatGPT, powered by OpenAI's models, with image generation (DALL-E) included.

Copilot for Microsoft 365 (Paid): Built into Word, Excel, PowerPoint, Outlook, and Teams. This version works inside your documents, with your data. It requires a Microsoft 365 Business or Enterprise subscription plus the Copilot add-on (USD 30/user/month on top of the base subscription).

For most Kenyan beginners, the free version is the starting point. The paid integration version matters for organizations already on Microsoft 365.

Using Free Copilot: Practical Tasks

Writing and Research

Open copilot.microsoft.com and start with everyday tasks:

• "Write a formal letter requesting a meeting with the county education director in Mombasa to discuss a school partnership program"
• "Explain the key differences between a sole proprietorship and a limited company in Kenya. Use simple language."
• "Create a weekly report template for a sales team tracking KES revenue, units sold, and client meetings"

Copilot draws on OpenAI's models and has access to web search, so it can reference current information. The responses include citations when it pulls from web sources, which helps with verification.

Image Generation

Type a description and Copilot generates images using DALL-E. This is included free, which differentiates it from ChatGPT's free tier (where image generation has limits).

Try: "A professional illustration of a small business team in a modern Nairobi office, discussing a project around a table, warm lighting, clean style"

The images work for presentations, social media, and internal documents. Quality is comparable to other AI image generators.

Data Analysis

You can paste data directly into Copilot and ask for analysis:

• Paste a table of monthly sales figures and ask "Which month had the highest growth rate?"
• Share a list of expenses and ask "Categorize these into fixed and variable costs"
• Provide survey responses and ask "Summarize the main themes in these responses"

For quick analysis without opening Excel, this is surprisingly useful.

Copilot Inside Word

For organizations with the Microsoft 365 Copilot add-on, AI appears directly inside Word.

Drafting Documents

Click the Copilot icon in a new Word document and describe what you need. Copilot generates a draft that you can then edit normally. It pulls context from your other Microsoft 365 files if you reference them.

Practical examples:

• "Draft a service agreement between [our company] and [client name] for a 6-month consulting engagement"
• "Write a training manual outline for new customer service representatives"
• "Create a project status update based on the latest data from [specific Excel file]"

The ability to reference other files in your organization is significant. Instead of describing data, you can point Copilot to the actual spreadsheet or document.

Editing and Rewriting

Select text in an existing document and ask Copilot to:

• "Make this section more concise"
• "Rewrite this for a non-technical audience"
• "Convert these paragraphs into bullet points"
• "Add a summary paragraph at the beginning"

This works like Claude or ChatGPT's editing features, but directly inside your document without copy-pasting.

Copilot Inside Excel

Excel Copilot helps with formulas, analysis, and visualization.

Formula Generation

Instead of memorizing formula syntax, describe what you need:

• "Calculate the average of column C where column A equals 'Nairobi'"
• "Create a running total in column D based on column B"
• "Count the number of rows where the status is 'Overdue' and the amount exceeds a reasonable cost"

Copilot writes the formula and inserts it into the selected cell. It also explains what the formula does, which helps you learn Excel formulas over time.

Data Analysis

Select a range of data and ask Copilot to:

• "What are the trends in this data?"
• "Create a chart showing monthly sales by region"
• "Highlight any outliers in this dataset"
• "Add a pivot table summarizing sales by product category"

For Kenyan businesses tracking financial data, inventory, or client records in Excel, this turns complex analysis into a conversation.

Copilot Inside Outlook

Email assistance in Outlook includes:

• Draft replies: Copilot suggests full replies based on the email thread
• Summarize threads: Long email chains get condensed into key points and action items
• Tone adjustment: Shift drafts between formal, casual, or direct

For professionals handling dozens of daily emails, Copilot in Outlook works similarly to Gemini in Gmail. The choice between them depends on which email platform your organization uses.

Copilot vs Other AI Tools

Copilot Free vs ChatGPT Free: Both use OpenAI's models. Copilot includes free image generation and web search by default. ChatGPT has a larger community and more third-party integrations. For basic AI chat, they are comparable.

Copilot for 365 vs Gemini for Workspace: This is the real competition. If your organization uses Microsoft 365, Copilot integrates with your existing tools. If you use Google Workspace, Gemini does the same. Switching ecosystems for AI features alone rarely makes sense.

Cost comparison: Copilot for 365 at USD 30/user/month is more expensive than Google's AI Premium at USD 19.99/month. For organizations already paying for Microsoft 365, the Copilot add-on is an incremental cost. For new users choosing between ecosystems, this price difference matters.

Practical Considerations for Kenyan Users

Free Copilot is the best starting point. The chatbot at copilot.microsoft.com is genuinely useful and costs nothing. Use it alongside (or instead of) ChatGPT depending on which interface you prefer.

Microsoft 365 Copilot depends on your organization. If your company already uses Microsoft 365 Business or Enterprise, the Copilot add-on extends tools you already know. If you are an individual or small business on Google Workspace, switching to Microsoft 365 just for Copilot does not make financial sense.

Data usage is reasonable. Text-based Copilot conversations use minimal mobile data. Image generation and document-embedded AI use more but remain practical on standard connections.

Our AI and Automation for Beginners course covers AI assistants across platforms, helping you choose and use the right tools for your situation.

For comparisons with other AI assistants, see our ChatGPT vs Claude vs Gemini guide. For the broader picture, visit the No-Code Automation Guide. You can also check AI tools that work well in Kenya for pricing and access information.

FAQ

Can I use Copilot for free without a Microsoft 365 subscription?

Yes. The free Copilot at copilot.microsoft.com works with a basic Microsoft account (Outlook, Hotmail, or a newly created one). You get AI chat, image generation, and web search at no cost. The in-app integration with Word, Excel, and Outlook requires the paid Microsoft 365 Copilot add-on.

Is Microsoft Copilot available in Kenya?

Yes. Both the free Copilot chatbot and Copilot for Microsoft 365 are accessible from Kenya. The free version requires only a Microsoft account. The paid version requires an eligible Microsoft 365 subscription and the Copilot add-on, payable with Visa or Mastercard.

How does Copilot handle data privacy?

For the free chatbot, Microsoft states that your conversations may be used to improve services (similar to other free AI tools). For Copilot for Microsoft 365, Microsoft applies enterprise-grade data protection: your organizational data stays within your Microsoft 365 tenant and is not used to train models. This distinction matters for businesses handling sensitive information.

Can Copilot replace Excel skills?

No. Copilot helps you work faster in Excel, but understanding what you are asking for still requires basic spreadsheet literacy. If you do not know what a pivot table is, you will not know when to ask Copilot to create one. Think of Copilot as a speed multiplier for existing knowledge, not a replacement for it.