A very useful but less-well known feature of Excel is the Data Table. In the video I explain how to set one up using the PMT function as an example. This is part 1. Part 2 looks at the conditional formatting used to generate the affordability heatmap.
#exceldata_table #excel_modelling #mortgage
