Copilot in Microsoft Excel can break down spreadsheets and identify trends using AI
Microsoft's new Copilot tool can help you out with complex Excel spreadsheets.
What you need to know
- Microsoft announced Copilot today, an AI-powered tool that works across Microsoft 365 applications.
- Word, Excel, PowerPoint, Viva, and Teams will all support Copilot.
- Within Excel, Copilot can suggest formulas based on questions you ask it and create charts and visual aids.
Microsoft announced Copilot for a range of applications. Among those is Excel, which will let you ask questions with natural language rather than relying on formulas you know off hand. The AI-powered tool will also share correlations it finds in data, suggest what-if scenarios, and recommend formulas based on the questions that you ask.
Copilot will also be able to generate content, such as charts and other visual aids.
Word, PowerPoint, Outlook, Viva and Teams will all support Copilot as well. In addition to the tool working within the apps, Copilot can gather information from one document and use it to create content in another. For example, Copilot can use a Word document to create a PowerPoint presentation.
Microsoft shared some examples of what Copilot can do in Excel:
- Give a breakdown of the sales by type and channel. Insert a table.
- Project the impact of [a variable change] and generate a chart to help visualize.
- Model how a change to the growth rate for [variable] would impact my gross margin.
Copilot is in testing right now among 20 customers, including eight Fortune 500 companies. It will be available in preview for more users later this year.
Get the Windows Central Newsletter
All the latest news, reviews, and guides for Windows and Xbox diehards.
Sean Endicott is a tech journalist at Windows Central, specializing in Windows, Microsoft software, AI, and PCs. He's covered major launches, from Windows 10 and 11 to the rise of AI tools like ChatGPT. Sean's journey began with the Lumia 740, leading to strong ties with app developers. Outside writing, he coaches American football, utilizing Microsoft services to manage his team. He studied broadcast journalism at Nottingham Trent University and is active on X @SeanEndicott_ and Threads @sean_endicott_.