Microsoft 365’s Copilot at a glance

Microsoft 365’s Copilot brings generative AI in context to your work files. Where chat GPT/other AI may tell you the steps to highlight cells above 50 in your Excel table or rewrite a Word paragraph in bullet points, Copilot will actually do that to your document. In certain cases, useful features that Copilot cannot accomplish are shown too.

There are many products which Microsoft is placing under the umbrella brand of Copilot.

• Copilot for Microsoft 365 is available for $30 per employee per month for businesses. This article is focused on this.
• Copilot Pro is available for individuals at $20 per user per month. The majority of this article shows features available here.
• Several other iterations such as Copilot exist. Copilot for Windows, PowerApps, Git Hub, Edge, or Bing (formerly Bing chat).

This article focuses on the first two.

The main alternative tools featured include chat GPT (free or £16 per month for GPT4) and graphic design tool turned productivity suite Canva (free or Canva Pro at £100 per year), Adobe Express (free or £10 per month), Google Apps, Bing Copilot and others are also shown too.

From personal experience, whilst certain Copilot experiences (such as Teams and Outlook) are truly something new, several other features marketed as Copilot have been available natively within the app for a few years (such as Excel’s ask a question about your Data or create PowerPoint presentation from a prompt).

Copilot in PowerPoint (Available in Copilot for Microsoft 365 and Copilot Pro unless otherwise stated)

This video shows the key alternatives for Copilot for PowerPoint and image enhancing, and the text is below:

1. Animate a slide: Animations can be tedious, but Copilot can set different animation styles for different objects easily. Canva pro’s magic animate goes further by generating several options which combine animations in an elegant way.
2. Text to presentation/slide: PowerPoint can natively create a presentation from a prompt by clicking New > QuickStarter, Canva can create one or more slides from a prompt too. Here are samples from PowerPoint native, Canva, chat GPT and Copilot. Note that Copilot Pro doesn’t have this feature for now.

3. Doc to/from deck: Although Copilot generates stronger results, Word Online can be converted into a presentation by clicking File > Export > Export to PowerPoint, Canva Pro can convert a presentation to an email, a summary or more (via magic switch) or vice versa.
4. Summarise a presentation: Ask Copilot, GPT 4 or Canva Pro, this is GPT 4’s summary whilst this appears when you use magic switch in Canva.

5. Generate speaker notes: Ask Copilot or upload a file to GPT 4 and generate speaker notes
6. Organise into sections & add agenda: Click in between slides in PowerPoint where your agenda should be > Insert > Zoom > Summary Zoom, then tick which slides should be section headers, ideally format all section header slides to be similar like in the screenshot shown:

Image generation & enhancement tools (Unavailable in Copilot)

One of the most useful use cases of AI in apps that I have personally seen comes with AI image manipulation, in particular Canva’s six AI enhancement tools.

7. Magic edit: Type a prompt to replaces certain aspects of an image in Canva free. Generative Fill is Adobe Express’s name for the free feature.
8. Magic expand: Generates additional parts of an image in Canva pro (also in Adobe)

9. Magic grab text: Edit text contained within an image, Canva pro does its best to replicate the font, size, colour and angle of the text

10. Magic eraser: Select aspects of a picture you would like removed with Canva Pro, Adobe Express Premium or Microsoft Designer for free
11. Magic grab: Grab and move certain elements in the foreground of an image

12. Background remover: Keep the foreground and remove the rest. Easiest through remove.bg which doesn’t require sign in. Adobe Express Free can also remove the background, Microsoft Designer can remove or blur the background, whilst Canva pro can remove photo and video backgrounds.

13. Create an AI image: Microsoft 365 Copilot cannot yet do this, but can be done via Bing Copilot, Canva (which can generate videos too), Microsoft Designer, Google Slides as well as more sophisticated paid specialist services such as DALL-E, Midjourney, Adobe Express free and more.
14. Text prompt to text effects: Type out text effects and Adobe Express will create the editable graphics for free, but enhancements are in the Premium version.

The Abode suite of products has done wonders with incorporating other AI into its applications for image enhancement and otherwise, but many are pricey. One free tool is Adobe Podcast which can extract voice from background noise.

Copilot in Excel Copilot in PowerPoint (Available in Copilot for Microsoft 365 and Copilot Pro)

At the time of writing, Excel’s Copilot is in preview version only so features may change before wide release. Copilot requires data to be set up using the rarely known “Format as Table” feature for a file saved on SharePoint or OneDrive. This video shows Copilot and alternatives.

15. Add a formula column to a Table based on a prompt: Even a seasoned veteran gets confused with where to put , or “ or () in nested IF formulas or otherwise. Copilot can generate Excel formulas in a Table, but Chat GPT or Bing Copilot can generate formulas for any cells (which need to be pasted & cell references edited).
16. Highlight cells with “David” in red: Using Home > Conditional formatting > Highlight cell rules > Text that contains has allowed this functionality for decades, but Microsoft 365 Copilot converts this from a prompt. At the time of writing, Copilot doesn’t do many actions, makes many mistakes and isn’t able to write a formula for a custom rule (such as highlight the row if column B is above 50), but Chat GPT and Bing Copilot can generate these formulas to paste into the “New rule” dialog.

17. Identify trends and analyse from a prompt: Copilot seems to be merely a refreshed UI of the 5-year-old “Analyze data” feature on Excel’s home tab or Explore on Google Sheets’ Tools tab. Copilot will over time take advantage of large language models for more advanced analysis than Analyze data, but at the time of writing Analyze data seems to be more powerful (as it works on non-Tables).
18. Create charts from a prompt: Once again, Excel’s “Analyze data” and Sheets’ “Explore” features allows you to ask a question about your data such as “create a bar chart of sales by city” or “what are total sales for August.” GPT 4’s Advanced data analysis can go a little further cleaning up poorly presented data first (if clean up steps are simple) whilst Excel’s Copilot can generate a written summary.

19. Filter, sort & format commands via prompt: Copilot can bold text and do a few more commands as well as simple filtering and sorting.

Copilot in Word Copilot in PowerPoint (Available in Copilot for Microsoft 365 and Copilot Pro)

20. Generate doc from prompt: Copilot, Canva pro, Google Docs all have this built in. Copilot can also generate from existing cloud documents or even from emails/Teams chats, whilst GPT4 can reference documents uploaded with the prompt.

21. Rewrite or reformat text: Select text and get options on right click with Copilot or the pop up on Google Docs and Cava Pro. All apps can rewrite (with a specified tone if asked), but Copilot can visualise in a table, whilst Google Docs and Canva can elaborate, summarise or bulletise the selected text.

22. Summarise a document & ask questions: Copilot and Canva can summarise in a similar way to the presentation covered earlier. Copilot, similarly to GPT4 for an uploaded document allow you to ask specific questions such as “which target audience is this aimed at” or “what are the action points listed”.
23. Reword according to your brand voice: Unavailable in Copilot, Canva pro allows you to train your brand voice under Brand Hub e.g. “playful cosmetics aimed at females aged 15-20 in central Europe.”
24. Translate entire docs, presentations or designs: Canva’s Magic Switch can use AI to translate into virtually any language and resizes aspects to make the text not overlap certain key aspects of a design etc. Unavailable in Copilot for now.

Copilot in Outlook (Available in Copilot for Microsoft 365 and Copilot Pro)

Out of all the apps, Outlook’s features are the ones which are the hardest to replicate without Copilot. Note that not all of these are available right now but are officially coming soon. Copilot is available on Outlook Online and Mobile, but license holders must be using the new Outlook experience to access Copilot on Outlook Desktop.

25. Triage your inbox: Click Next… to go through your most important unread emails
26. Draft emails: Copilot can draft based on a prompt; you can also specify a tone.
27. Coaching with Copilot: Turn this on to train it with your writing style and get tips on how to change a tone or clarity.
28. Summarise this email thread: click at the top of an email.

Aspects available in Copilot for Microsoft 365 but not Copilot Pro

Copilot in Teams

Copilot is Teams is very useful for those attending many meetings

29. Generate summary meeting notes & ask questions: Copilot can generate brief notes and allows you to ask questions such as “what tasks do I need to do” or “when is the proposal deadline”, or “who spoke the most in the meeting” or “what were the pros and cons discussed to launch next week in a table”. If you hover over the reference there is a useful pop up with the wording used in the meeting. Non-Copilot users can replicate this by uploading the meeting transcript to GPT4, although results are less slick. This incredibly useful feature works well but in both cases, you must turn on meeting transcription.Draft emails: Copilot can draft based on a prompt; you can also specify a tone.

30. Follow a meeting: If you’re unable to attend a meeting, Copilot can join and give you the meeting notes, tasks etc.
31. Summarise what’s happened so far in a meeting: Copilot can catch you up if you join a meeting late, not available with Chat GPT.

Other meeting apps such as Zoom and Google Meet have also introduced Copilot like functionality to their meetings as well as live translations. Translations (plus meeting templates and other aspects summarised in my blog post here) are included in the Teams Premium add on license but not the standard Copilot license.

Copilot in other Microsoft 365 apps

32. Microsoft 365 chat allows you to ask questions based on all of the data you have access to, documents, emails, Teams chats. Available on a browser or via Teams, you could ask things like “summarise what happened with client ABC in Q4” or “tell me the status on all my proposals in March” or “What’s the latest from Jacob”.
33. Draft and summarise in Loop and OneNote: These two features work in the same way as they do in Word, they should fully roll out soon.
34. Create and ask in Planner: Create lists or ask questions such as “who has the most tasks,” this also should be available soon.

Comparing functionality in a table

This table below contains the aforementioned aspects plus others which are officially coming soon for Copilot but don’t seem to be available at the time of writing.

In summary, I personally don’t feel as though Copilot for Microsoft 365 is game changing in its current state, it's most useful non-replicable features are triaging an Outlook inbox and sifting through your data with Microsoft 365 chat, various other aspects look great in demos but have few use cases. The majority of Copilot’s actions can be imitated via other apps such as summarising meeting notes, drafting documents from a prompt. I will continue to use Canva’s image alteration tools more than Copilot for the meantime. Over time, Copilot will undoubtably become more useful though, especially once its functionality is extended, it is offered to more users and the Large Language Model which underpin it is given more and more data.