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.
Challenge: Completing the FP&A business case
From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis
Challenge: Completing the FP&A business case
(bright electronic music) - [Instructor] In this next and final challenge, I'm going to ask you to utilize the FP & A process roadmap for the company's next year of performance. In other words, you're going to leverage this process roadmap design that we created throughout this chapter. You're going to use the process documentation, and you're going to apply it for the 2018 calendar year. You'll find the 2018 CRM sales data in the course files. Ideally, because we've been able to build this process for 2017 and we documented all of the various steps all along, you'll be able to do it for 2018, and then once we feel confident with these two years, this process will then become a template for the FP & A process into the years to come. Good luck with this challenge, and in the next video I'll walk you through my suggested solutions.
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)
Creating an FP&A project roadmap and process3m 21s
-
(Locked)
Developing the full FP&A project and process roadmap3m 13s
-
(Locked)
Using Copilot in Excel to analyze the business9m 48s
-
(Locked)
Challenge: Completing the FP&A business case57s
-
(Locked)
Solution: Completing the FP&A business case8m 39s
-
(Locked)
-
-