Setup · 1:58
Getting and finding Copilot
Turn on AutoSave.
- Copilot comes with Microsoft 365 subscriptions.
- Find it via the cell icon or the Home tab ribbon.
- Requires AutoSave — save to OneDrive or SharePoint.
| Requirement | Why |
|---|---|
| M365 subscription | Access |
| AutoSave on | Required |
| Cloud file | Enables AutoSave |
Do this in your own tools, step by step. Ticks are saved on this device.
Needed to use Copilot?
AutoSave + cloud file.
Where to click?
Cell icon or Home ribbon.
0:00 If you know how to take advantage of Copilot, your Excel skills will be so much more dangerous. In fact, your boss will probably think you're a wizard. If you stick around until the end, I'll show you a trick you can use to make Copilot even smarter. Let's dive in. First off, to get Copilot in Microsoft Excel, you need a Microsoft 365 subscription. With this subscription, you get access to all the different Microsoft 365 apps like Word, Excel, PowerPoint, Outlook, and so on.
0:59 And you also get Microsoft Copilot integrated into all of those different apps. Here I am now in Microsoft Excel, the app that runs most businesses throughout the world. Once you have Copilot, you'll notice it in a few different places. Here, when I click into a cell, you'll notice that I have this Copilot icon that appears. And when I click on that, I can engage with the Copilot. Also on the Home tab, on the ribbon over on the far right-hand side, you'll also see that there's a Copilot icon here.
1:26 And when I click on this, this also opens up the pane with Copilot. However, you'll notice one thing. Down at the bottom, it says that AutoSave is turned off. To be able to use Copilot, you need AutoSave turned on. So how do we do that? Well, let's click on this button to turn on AutoSave. But to be able to use AutoSave, you have to save your Excel spreadsheet in the cloud. So,
Get the other 8 chapters, the exam and your certificate for LinkedIn, plus all 700+ AI courses.