skinny.

Latest / ModeLoop: Financial Modelling in Excel

Excel Data Validation for Financial Models: Drop-Down Menus & Input Controls (P2E11)

Excel data validation is the cheapest insurance in any financial model: it controls what goes into your input cells before a bad entry breaks something. This episode shows how to build drop-down menus, scenario switches and input rules that keep a model clean when someone else opens it.

In this episode:

Drop-down menus for a Base / Upside / Downside scenario switch

Keeping lists on a dedicated Lists sheet with named ranges

Input messages, error alerts and custom validation rules

Dependent drop-downs with INDIRECT and rejecting duplicates with COUNTIF

Circle Invalid Data: auditing an inherited…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.