How to Write Excel Formulas with Microsoft Copilot

Get Started with Copilot in Excel - Let me walk you through data setup and Copilot-assisted formulas.

In this video, I demonstrate how to use Copilot in Excel, specifically focusing on setting up data and using formulas. I show how to save data as a table and the necessity to have your data in Microsoft OneDrive or SharePoint for Copilot to function. Then we look at how Copilot can generate formula suggestions and how to add these to your table.

Copilot can interpret your questions to create new formulas and columns.

Chapters:
00:00 Introduction
00:28 Setting Up Your Data for Copilot
01:46 Using Formulas in Copilot
03:17 Creating Custom Columns with Copilot
04:17 Conclusion

Check out my Excel and Microsoft courses:

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#copilot #excel #chrismenard

[SafAspirant]

You’re the man, Chris. Thanks. Continue keeping these succinct.

[nnjczfl]

I have Microsoft 365. How do you get Copilot to appear in Excel?

[Rgc]

Does it work on text columns? For example count how many times each name occurs?

[usmaniqbal]

Perfect Chris, but also share data file for better practice..

[Moorthi-]

In Excel, if we move one heading below one heading in ABC row, the size of two headings changes. If you move the ABC row, the size of the heading at the top should remain the same. The heading below should be resized and changed. Tell me how to do this.