Tool guide · by Microsoft
Microsoft Copilot in Excel
AI inside the spreadsheet you already use.
Best for
- Working directly in your workbook: formulas, sorting, filtering and highlighting
- Creating PivotTables and charts from a question in plain words
- Spotting trends and outliers in a data set
- Organisations already on Microsoft 365, where IT manages data protection
Watch out for
- Works best on data formatted as an Excel table with clear headers.
- Files usually need to be saved to OneDrive or SharePoint with AutoSave on.
- Check every formula it inserts. Undo (Ctrl + Z) is your friend.
- Use it on client files only with your organisation’s approval.
Get started
- Check that your Microsoft 365 plan includes Copilot: look for the Copilot button on Excel’s Home tab.
- Save the workbook to OneDrive or SharePoint and turn on AutoSave.
- Select your data and press Ctrl + T to format it as a table with headers.
- Open Copilot and ask in plain language, for example with the prompt below.
Features worth knowing
Formula suggestions
Describe the column you want (“days overdue from the due date to today”) and Copilot proposes a formula, with an explanation, before inserting it.
Analysis
Ask for totals by category, the top 10 customers or month-on-month changes. Copilot can add PivotTables and charts.
Highlight, sort and filter
“Highlight invoices more than 90 days overdue in red” applies the conditional formatting for you.
Copilot chat
The free Copilot app on the web, Windows and phones works like other chatbots for questions and drafting.
Try this prompt
Add a column that shows the days overdue from the Due Date column to today. Then create a PivotTable showing the total Amount by Customer for invoices more than 60 days overdue.
Put it to work
Recipes that suit Microsoft Copilot in Excel
Receivables ageing report in Excel
এক্সেলে দেনাদারের এজিং রিপোর্ট
Get AI to write the Excel formulas for days overdue, ageing buckets and bucket totals, then test them on invoices where you already know the right answer.
Copilot in ExcelChatGPTClaude
Budget vs actual variance commentary
বাজেট বনাম প্রকৃত: ভ্যারিয়েন্স মন্তব্য
Turn a budget-versus-actual table into clear management commentary that flags material variances and uses only the reasons you supply, never invented ones.
ChatGPTClaudeCopilot in Excel
IFRS 16 lease liability schedule
আইএফআরএস ১৬ লিজ দায়ের সূচি
Calculate the initial lease liability and right-of-use asset, build the amortisation table and journal entries, then prove the numbers with Excel’s PV function.
ClaudeChatGPTCopilot in Excel
Other tool guides
Plans, limits, menus and feature names change often. Checked November 2026; see the official website for the latest. This site is independent and not affiliated with Microsoft.