After creating the relationship, Excel will identify those tables as a Data Model Table, not a Worksheet Table in the dropdowns. To see what Excel did, click Manage Data Model in the Data Tools group.

Let’s examine how to create a “three-statement projection model” for a company by estimating its cash flow, cash and debt balances over the years. Here’s a structured approach broken down ...