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

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Reconciling data with Copilot in Excel for FP&A

Reconciling data with Copilot in Excel for FP&A

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

Start my 1-month free trial Buy for my team

Reconciling data with Copilot in Excel for FP&A

“

- [Instructor] So, now, let's think about what we're looking at. If I go over to my sales from October and I take a look at this column that says OrderNum Exists in Nov, let's think about what this means. If we have an invoice that was found in October and found in November, it means that this invoice is still outstanding. However, if I go over here and I say Not Found, what this is going to suggest is that these were invoices that existed in October, but when I look over here in November, they are not found. That means that these invoices were either collected or they were written off. Let's go over to November and let's examine what each of these means. If we have something that was found in November and it was found in October, these mean that these invoices were existing one month prior. However, if I go over to Not Found, what this means is that these are new invoices that were issued in November. They did not exist in October. Arguably, these are the new invoices for the month…

Contents