For Individuals
For Teams
  • FP&A Program: 11 courses to earn the FP&A Excel Modeling Specialization certificate
  • Self-Paced & 100% Online
  • Get the full FP&A Excel Modeling Specialization, Community, & more with a CFI membership
  • Get this program and CFI's full training catalog for your organization
  • Manage learning, create custom paths & measure progress
  • For teams of 2 or more learners

FP&A Excel Modeling Specialization Overview

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.

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.

What's in the FP&A Excel Modeling Specialization?

11 courses

11 courses and 305 lessons

300+

interactive exercises

Receive a Certificate

To verify your skills

500,000+ 5-star ratings

Best-in-class training, as rated by you

How the Program Works

Step 1.

11 Required Courses

FP&A Modeling Pt.1 - Design
4.9 (12 Ratings)
38min
38min
FP&A Modeling Pt.2 - Formatting & Revenue
5 (14 Ratings)
1h 25min
1h 25min
FP&A Modeling Pt.3 - Headcount Analysis
5 (4 Ratings)
1h 6min
1h 6min
FP&A Modeling Pt.4 - Contractor Analysis
4.8 (4 Ratings)
27min
27min
FP&A Modeling Pt.5 - Debt and Capex Analysis
4.8 (4 Ratings)
47min
47min
FP&A Modeling Pt.6 - Financial Statement Aggregation
5 (4 Ratings)
1h 9min
1h 9min
FP&A Modeling Pt.7 - Dashboard Visualizations
4.8 (4 Ratings)
43min
43min
FP&A Modeling Pt.8 - 3-Statements
5 (2 Ratings)
1h 58min
1h 58min
FP&A Variance Pt.1 - Build & Configuration
4.5 (2 Ratings)
1h 13min
1h 13min
FP&A Variance Pt.2 - Roll Forward & Analysis
5 (2 Ratings)
59min
59min
FP&A Variance Pt.3 - Protection & Presentation
5 (3 Ratings)
1h 27min
1h 27min
Hide All Courses

Skills & Learning Objectives in Financial Planning & Analysis (FP&A)

1
30%
Financial Modeling
2
20%
Financial Analysis
3
30%
Excel
4
10%
Data Visualization
5
10%
Accounting
1
2
3
4
5
  1. 1.
    30%
    Financial Modeling
  2. 2.
    20%
    Financial Analysis
  3. 3.
    30%
    Excel
  4. 4.
    10%
    Data Visualization
  5. 5.
    10%
    Accounting

Financial Modeling

  • Apply modeling best practices tailored to the unique needs of FP&A.
  • Build models using the core Excel formulas and functions that FP&A teams rely on.
  • Learn a detailed procedure for filing monthly models, setting a new budget forecast, and rolling the models forward for each new fiscal year.

Financial Analysis

  • Analyze monthly financial data using FP&A model templates.
  • Review historical results for seasonality and update forecasts at appropriate intervals.
  • Perform quantitative and qualitative analysis to extract insights and deliver clear commentary to key stakeholders.

Excel

  • Construct best-in-class FP&A models using high-quality Excel templates.
  • Model more efficiently with time-saving Excel keyboard shortcuts.
  • Apply advanced Excel formulas and functions to increase model accuracy and flexibility.

Data Visualization

  • Create compelling visuals that communicate financial insights to key stakeholders.
  • Learn how to select the right visual format for different types of financial data.
  • Combine visuals and storytelling into an interactive dashboard, allowing users to explore trends and issues.

Accounting

  • Apply accounting principles to separate accrued and cash items for cash flow calculation.
  • Complete and balance a three-statement financial model with a solid accounting foundation.

What Our Students Say

Over 75% of CFI learners report improved productivity or competency within weeks.

I’ve transitioned from audit to FP&A. Not only did I transition to a new role, but it allowed me to pick up the new role fast and gain several spot bonuses.

Travis Bruns

Everything was explained clearly and carefully by the instructor which made things easy to understand.

Joss Atkinson

The skills are actual real-world skills (unlike most financial qualifications) that have already helped me land a new role.

Mark Wheeler

I would absolutely recommend CFI’s training for anyone who’s looking to rapidly increase their ability to add value through a certification program.

Anthony Santillanes

Taught by Industry Experts

Duncan McKeen

Duncan McKeen

Duncan is the Executive Vice President, Financial Modeling at CFI. Since 2014, Duncan has been focused on designing courses and teaching financial modeling to employees working in accounting, valuation, investment banking, equity research, and private equity.

Careers in Financial Analysis & Strategy

Over 85% of executives, supervisors, and HR professionals agree that certified individuals bring value, gain credibility, and are seen as top performers.
* Source

  • Financial Analyst

    Financial Analyst

    Financial Analysts play a key role in delivering insights and strategic recommendations to support high-level decision making. They also partner with departments such as sales, marketing, and operations to drive effective financial planning and guide business decisions.
  • Project Evaluator

    Project Evaluator

    Collaborate with project managers and senior leadership to assess potential initiatives and develop comprehensive project budgets. Project Evaluators also work closely with teams across marketing, engineering, and operations, while partnering with fellow financial analysts and FP&A professionals for peer reviews and cross-functional collaboration.
  • FP&A Manager

    FP&A Manager

    Lead the FP&A team while fostering cross-departmental collaboration to ensure integrated and strategic financial planning. FP&A Managers are responsible for developing and overseeing the annual budget and forecasts, analyzing financial reports to assess company performance, and delivering actionable recommendations to senior leadership.

Our Learners Work At:

Frequently Asked Questions

If you haven’t found your answer from our FAQ, please send us a message.

Will these courses help me advance my career?
Reviews from learners who have taken CFI courses include numerous stories about how people have been able to advance their careers. There is a proven track record of CFI graduates marking successful transitions into the careers of their dreams and this is based largely on the resources that we make available to our learners upon enrolment. Our training is designed to be fully practical and simulates the experience of being trained as a professional financial analyst. Additionally, we offer a wealth of information through our free career resources. The unique blend of all these elements is what sets us apart from other eLearning platforms when it comes to giving you all the tools you need to create a successful career in finance.
What are the admission requirements for the courses?
This specialization bundle is recommended for learners and professionals with knowledge or experience in environmental, social and governance analysis. To take the courses and complete the exercises, learners will only need access to a PC and/or Mac, Microsoft Suite (2016 or newer), and a stable internet connection.
How much time do I have to complete the courses?
Take as much time as you need. You will have access to all courses and all future upgrades in your subscription. You can review the video lessons as many times as you like and complete the courses at a pace that is most convenient for you. All of the required courses, resources, and assessments to obtain the certifications will be provided, for as long as your subscription is active.
How are the exams conducted?
Learners are required to complete an online assessment (MCQ's, Fill-in-the-Blanks, and Excel Questions) at the end of each course. You can take the exams at your own schedule and will need to earn at least 80% to pass the course and earn your certificate of course completion. Please note that course exams can be repeated as many times as you need.
Can I download and edit the course material and templates?
Yes! You can download the resources included in your courses. All of the files needed in a course are available for download. Please note that while our study materials can be downloaded, the lecture videos are only available online due to copyright infringement issues.
How do I earn my certificates?
You need to complete all the video lessons, quizzes, and final assessments in each course to earn your course certificates. The certificate will then be available on your learner dashboard and also emailed to you as soon as you have completed all of the requirements.
What currency are your courses priced in?
All of our online courses and programs are priced in USD.
What payment methods do you accept?
As this is a recurring payment, we accept all major credit and debit cards including Visa, MasterCard, and American Express.
Are there any additional fees or costs?
None! The program tuition includes everything and there are no additional fees required to earn your digital certification.
More Questions?
Please email us and we'll be happy to answer any of your questions!

If you haven’t found your answer from our FAQ, please send us a message.

0 search results for ‘