Home >Tips >Excel 2016 from Scratch Tutorials >House costs calculation D kalmstrom.com site map icon Site map  

Excel 2016 from Scratch

House Costs Calculation D

An Excel tutorial by Peter Kalmstrom

Excel 2016 icon In three earlier Tips articles in the Excel 2016 from Scratch series Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, has shown how to calculate house costs with the help of Excel formulas.

The demo below is the last one about house calculations. Peter shows:

  • How changes in input values effect the sums.

  • How to use the Quick Analysis to create a chart that shows the monthly house costs.

  • How to choose among pre-defined chart designs to change the look of the chart.

  • How the chart changes when a value in one of the included cells changes.

  • How to change the chart style.

Excel chart


Peter uses Excel 2016 for his demo, but the Excel basics are the same for earlier versions of Excel.





Learn more



---------------------------------------------------------------------------------------






Always the latest news in the kalmstrom.com blog


Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

back icon next icon