Greetings, today we continue a series of posts this week that shows how you can get help from copilot with the chat helper.

In yesterday’s post we showed how copilot could help explain a formula for you, but what if you are trying to write a formula? You can ask Copilot in Excel how to do something to get started. For example:

How can I add up the numbers in column B?

Copilot in Excel analyzes the question and even without data in your worksheet it can prove instructions on which function to use for the task:

Copilot in Excel can help solve problems using formulas.

That was helpful for a simple case, let’s try something harder:

I’m trying to compare two datasets with some duplicates. I want to extract data from Address list 2 which is not present in Address list 1. The list sizes are not the same, how can I do that?

Copilot in Excel analyzes the prompt and returns a suggestion to use the MATCH function, wrapped within the ISERROR and IF functions.

Copilot in Excel can help handle more complicated formulas including nested formulas.

Over the coming weeks we will be sharing more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Greetings, today we continue a series of posts this week that shows how you can get help from copilot with the chat helper.
In yesterday’s post we showed how copilot could help explain a formula for you, but what if you are trying to write a formula? You can ask Copilot in Excel how to do something to get started. For example:
How can I add up the numbers in column B?
 
Copilot in Excel analyzes the question and even without data in your worksheet it can prove instructions on which function to use for the task:
 
Copilot in Excel can help solve problems using formulas.
 
That was helpful for a simple case, let’s try something harder:
 
I’m trying to compare two datasets with some duplicates. I want to extract data from Address list 2 which is not present in Address list 1. The list sizes are not the same, how can I do that?
Copilot in Excel analyzes the prompt and returns a suggestion to use the MATCH function, wrapped within the ISERROR and IF functions.
Copilot in Excel can help handle more complicated formulas including nested formulas.
 
Over the coming weeks we will be sharing more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​