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.

Analyzing financials, trends, and variances with Copilot

Analyzing financials, trends, and variances with Copilot

From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis

Start my 1-month free trial Buy for my team

Analyzing financials, trends, and variances with Copilot

“

- [Instructor] Is it possible to use Copilot or AI in general, to analyze financial trends and variances? Yes, it is. Remember, generative AI responses come from analysis and detection of patterns within data, matched with analysis and detection of patterns within language. In this video, I'll illustrate which common AI powered FP&A tools can do the job well and which ones have their limitations. Let's first look at AI powered FP&A within Copilot, and then we'll take a look at ChatGPT. Remember, Copilot is best used for executing tasks and then conducting a subsequent analysis. Let's again assume that your director of FP&A at Red30 Tech. We're curious how marketing spend in social media is changing from month to month and how the company is doing in its plan to actual performance. First, I'm going to prompt Copilot to calculate the month over month growth rates for each social media platform using the table social media forecast 2017. Now, when I put my cursor on the table and I go up…

Contents