Excel is an essential tool for many businesses, but creating formulas, analysing data and producing useful reports can quickly become time-consuming.
Microsoft Copilot in Excel can make the process easier. Instead of searching online for the correct formula or manually examining rows of figures, you can describe what you need in everyday language.
How can Microsoft Copilot help with Excel?
Copilot can help you:
Create and explain formulas
Summarise information from a spreadsheet
Identify trends, patterns and unusual results
Highlight figures that meet particular conditions
Produce charts and PivotTables
Turn raw data into useful business insights
For example, you could ask:
“Create a formula that calculates the total sales for each month and highlights any month where sales were below £10,000.”
Copilot can suggest an appropriate formula and explain how it works, helping you complete the task while improving your understanding of the spreadsheet.
Turn business data into clearer insights
Copilot is also useful when you need to understand what your figures are telling you.
Rather than reviewing every row manually, try asking:
“Analyse this spreadsheet and identify the main trends, any unusual results and three areas that may require attention.”
This could help when reviewing sales performance, project costs, spending patterns, stock levels or operational data. You can also ask Copilot to present the findings as a chart, summary or PivotTable.
Before a management meeting, another useful prompt is:
“Summarise the key trends in this spreadsheet and provide three recommendations based on the data.”
This can provide a helpful starting point for discussion and make it easier to focus on the information that matters.
How to get better results
Clear instructions usually produce more useful answers. Tell Copilot which columns or figures it should examine, what you want to learn and how you would like the answer presented.
It also helps to keep your spreadsheet well organised, with clear column headings and consistently formatted information.
Most importantly, always review Copilot’s formulas, summaries and recommendations before relying on them. AI can save time, but it should support human judgement rather than replace it.
You can learn more in Microsoft’s guide to getting started with Copilot in Excel.
Make more of Microsoft 365
Many businesses already use Microsoft 365 every day but may not be taking full advantage of the productivity tools available to them.
If you would like help exploring Microsoft Copilot, improving the way your team uses Excel or reviewing your Microsoft 365 setup, contact Intuitive Computer Management.
Call 01384 913914 or email sales@intuitivecm.co.uk to speak with our team.

