From the course: Microsoft Copilot for Excel

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Main limitations of Copilot

Main limitations of Copilot

- [Narrator] Now that we've talked about Copilot's basic features, let's discuss its main limitations since it's important to be aware of them as we work through the demos in this course. Number one, which I've mentioned already, Copilot's actions and capabilities are limited to predefined tools. So these features use existing Excel tools and functionality under the hood, which means that Copilot can't do anything that isn't already possible within Excel. And not just that, there's also some things it can't do, even though they are possible in Excel. It doesn't have access to Power Query or Power Pivot, for instance, which are part of Excel's more advanced business intelligence features. Number two, Copilot can only analyze up to 2 million cells of data. And when I say analyze, I'm talking about the final features that I introduced in the previous lesson in which Copilot looks for insights, either with traditional Excel methods or with Python. It can still create formulas and edit the…

Contents