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
From the course: Microsoft Copilot for Excel
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.