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.

Follow kalmstrom.com on LinkedIn, Facebook or Twitter!

back icon next icon

Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved