Microsoft 365 Copilot in Excel (ChatGPT)

Chat GPT Powered Microsoft Excel Copilot

Microsoft 365 Copilot in Excel (ChatGPT)

Copilot in Excel works alongside you to help analyze and explore your data. Ask Copilot questions about your data set in natural language, not just formulas. It will reveal correlations, propose what-if scenarios, and suggest new formulas based on your questions – generating models based on the questions that help you explore your data without modifying it. Identify trends, create powerful visualizations, or ask for recommendations to drive different outcomes.

Excel's Copilot is there to assist you as you delve into your data. Rather than using algorithms, you can ask Copilot questions about your data set in plain English. It generates models based on your questions to let you study your data without affecting it, revealing relationships, proposing what-if scenarios, and suggesting new formulae. See patterns, make eye-catching visualizations, or get advice to influence results in your favor. You can try out the following commands and prompts as examples:

  • Please break down the numbers by product and distribution method. The table should be inserted.
  • Make a graphic to better understand the potential effects of changing [a variable].
  • Please simulate the effect on my gross margin of changing the growth rate of [variable].