Image Header

null

Copilot for Microsoft 365: New features and updates for July

We start this month with how Copilot in Excel can add formula columns to your tables. We explore how to jump start drafting or revising content in Word and how the Catch-up feature keeps you up to date with the information coming at you. Finally, in response to your requests, we show that you can process PDF files in PowerPoint and create content from multiple reference files.

As Microsoft Customer Zero, we’d love your help in refining this newsletter. Please share your feedback in the Copilot for Microsoft 365 survey to make sure the info is helpful for external customers.   

Announcement

Popular prompts

Set up conditional formatting 

“Bold the top 10 values in /[Annual sales]” 

Try in Excel

Remember important dates

“List the key dates mentioned in this meeting in a table” 

Try in Teams

Improve your Microsoft Copilot skills

null

Keep your team on track 

null

Catch up on meetings

Try this with Microsoft 365 Copilot

Smartly add formula columns in Excel to better analyze and interpret business data 

""

Got data, but you're not sure what to do with it? Let Copilot help. You can ask Copilot in Excel to add a formula column based on a selected table in your spreadsheet. For example, if your table lists population and area of specified locations, just ask Copilot, "Calculate population density." Just like that, Copilot will analyze your data and provide a new formula column showing population density. 

Try in Excel

Quickly ingest information from meetings or documents to reduce information overload 

null

Catch-up is a new feature in Copilot that helps you stay on top of important updates and act on them. Go to the Catch up tab on the Copilot home page and you'll see a set of cards, each with an update about a key meeting or document. You can use Catch-up in Microsoft Copilot and Copilot in Teams. 

Try in Copilot

Easily draft and refine content based on your organizational documents 

""

It’s often quicker to write new content if you can leverage existing content. With Copilot in Microsoft Word, you can create a draft based on text you've selected in your doc.  You can ask Copilot to do any of the following with the selected text, list, or table:  

  • Revise or paraphrase existing content

  • Explain your selected content in more detail

  • Enhance your content with statistics and additional information

Whatever you select, Copilot provides a rich and interactive experience that makes it easier to create effective content. 

Try in Word

Improvements based on your feedback

Easily use information in customers’ PDF files to create a presentation  

""

Copilot in PowerPoint can now query the contents of your PDF files, whether you reference PDF files directly or when Copilot searches them.  

Ask Copilot, "Create a presentation using /[PDF]." 

Try in PowerPoint

Generate summaries based on multiple emails, presentations, and Teams chats 

null

Working on a project with a variety of supporting documents in PowerPoint, Word, and more? Get more information in less time by referencing multiple files and let Copilot take it from there. 

Ask Copilot, "Summarize my emails, chats, and presentations from last week." Or, "Create a to-do list from my 3 Teams meetings on July 3." 

Try in Copilot

Helpful resources

You can keep learning on aka.ms/TryCopilot and aka.ms/EraOfAI, where you'll find videos, how-tos, tips, and can discover how to communicate effectively with Copilot using prompts.

Transform your workflows with expert guidance about how to use Copilot for specific scenarios in the Microsoft Copilot Scenario Library

If you want to see what you missed in past months, check out the updates history.

Take the power of AI on the go! Download the Microsoft Copilot mobile app and sign in with your work account today. 

Notes

Footer

This email is generated from an unmonitored alias. Please do not reply.

Privacy Statement

Microsoft Corporation, One Microsoft Way, Redmond, WA 98052 USA

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.