Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Corporate Finance Institute

FP&A Excel Modeling Specialization

via Corporate Finance Institute Specialization

Overview

What Do Analysts at Goldman Sachs and Amazon Have in Common?
They master their craft with the full CFI curriculum. Now 45% off with code AFF45FI, through Nov 1.
Get 45% Off

Building effective, scalable Excel models is one of the most in-demand technical skills in FP&A. CFI’s FP&A Excel Modeling Specialization equips you with world-class modeling skills to support planning, forecasting, and performance analysis with confidence. This specialization is designed for FP&A professionals, including analysts and managers, who want to build, format, and analyze world-class Excel models using proven FP&A methodologies.

Through a guided learning path, you will construct a flexible FP&A model in Excel from the ground up by applying best practices for model design, structure, scalability, and formatting to make models easy to maintain. This specialization also covers advanced modeling topics, including revenue and headcount drivers, debt and capex planning, and financial statement aggregation for dynamic Excel dashboards. In addition, you will use your model for variance analysis to track performance, identify trends, and deliver meaningful insights.

You’ll emerge from this specialization with the hands-on skills and tools to confidently build world-class FP&A models and deliver the meaningful insights that finance leaders rely on.

Syllabus

  • FP&A Modeling Pt.1 - Design
  • FP&A Modeling Pt.2 - Formatting & Revenue
  • FP&A Modeling Pt.3 - Headcount Analysis
  • FP&A Modeling Pt.4 - Contractor Analysis
  • FP&A Modeling Pt.5 - Debt and Capex Analysis
  • FP&A Modeling Pt.6 - Financial Statement Aggregation
  • FP&A Modeling Pt.7 - Dashboard Visualizations
  • FP&A Modeling Pt.8 - 3-Statements
  • FP&A Variance Pt.1 - Build & Configuration
  • FP&A Variance Pt.2 - Roll Forward & Analysis
  • FP&A Variance Pt.3 - Protection & Presentation

Taught by

Duncan McKeen, Scott Powell, Jeff Schmidt, Tim Vipond, Sebastian Taylor, Joseph Yeates, and Carl Seidman

Reviews

4.9 rating at Corporate Finance Institute based on 114 ratings

Start your review of FP&A Excel Modeling Specialization

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.