From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis
Unlock the full course today
Join today to access over 24,900 courses taught by industry experts.
Getting started with data functions and insights in Copilot
From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis
Getting started with data functions and insights in Copilot
- [Instructor] Now that you've had some practice with data tables in Copilot, and have seen what can be achieved, it's time to go a step further. In this video, I'll revisit the core data functions within Copilot and introduce some additional AI-powered features that can significantly enhance your work in financial planning and analysis. To start, let's review the core data functions that Copilot offers. If you recall from an earlier video, we can use Copilot for several foundational tasks in data management. First, we have create. Need to add new columns or formulas? Well, again, you can use Copilot to quickly do this by selecting a suggested prompt or by describing the specific column, or formula that you want to add. Understand, Copilot can analyze data, offering insights in various forms, such as charts, graphs, pivot tables, and simple summaries. You can simply choose a suggested prompt or describe the insights that you're looking for. Apply color and formatting, but it really…
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.
Contents
-
-
-
-
-
(Locked)
Getting started with data functions and insights in Copilot5m 14s
-
(Locked)
Using Copilot in Excel to add and manage formula columns8m 32s
-
(Locked)
Using Copilot in Excel to highlight, filter, and sort data8m 53s
-
(Locked)
Challenge: Intelligence and interpretation of data1m 52s
-
(Locked)
Solution: Intelligence and interpretation of data5m 51s
-
(Locked)
-
-
-
-
-