From the course: Excel Quick Tips

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Write basic formulas with Copilot in Excel

Write basic formulas with Copilot in Excel - Microsoft Excel Tutorial

From the course: Excel Quick Tips

Start my 1-month free trial Buy for my team

Write basic formulas with Copilot in Excel

“

- [Instructor] Copilot in Excel can help you write very basic formulas. In this example, let's say we want to sum up the Toy Sales right here. We will go into the Home ribbon, and to the right, we will click on the Copilot button. It's going to pop this pane to the right. And we're just going to ask this very basic question to Copilot. We're going to say, "Sum up Toy Sales." We're going to click Send. Amazing, Copilot came up with this formula right here, it's showing me the whole table. And if I go here on Insert row, you can see in cell C11 that my total is showing up. If I click on this button, it is going to add the formula for me in the cell C11. The next operation I want to do with Copilot is to actually do the average of the services revenue. I'm going to make sure I click on my dataset and ask the following to Copilot. "Can you add the average of the services, please?" Always be polite with Copilot. You never know who's watching. (instructor laughing) Copilot came up with this…

Contents