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
FP&A Modeling Pt.3 – Headcount Analysis Overview
CFI’s “FP&A Modeling Pt.3 – Headcount Analysis” course will help you filter through any past challenges you may have had to learn best-in-class approaches to forecasting headcount and employee costs in FP&A models. This course will also include using corkscrews and advanced techniques for both custom formatting and conditional formatting.
Who Should Take This Course?
This course is perfect for FP&A professionals at a beginner, intermediate, or even advanced level. This course is a part of a series of FP&A courses.FP&A Modeling Pt.3 - Headcount Analysis Learning Objectives
- Understand how corkscrews work and why they are considered a best practice for certain schedules in FP&A models
- Apply advanced custom formatting techniques to understand how to control the format for entries that are positive, negative, zero, and text
- Explore advanced conditional formatting approaches used to install limits and alert model users when inappropriate entries have been put into a model
- Use more advanced conditional formatting techniques to highlight changes to figures that are input across a single row in an FP&A model
