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

Excel 2016 from Scratch

House Costs Calculation C

An Excel tutorial by Peter Kalmstrom

Excel 2016 iconIn two 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.

In the demo below, Peter continues with the house calculations, and he shows:

  • How to calculate monthly and yearly interest costs with a formula that mulitplies the values of two cells.

  • How to create formulas that calculate sums in four different ways.

  • How Excel tries to understand what you are doing and assist you with that.

  • How to make cell content bold and larger.

Peter also repeats some useful Excel features shown in earlier demos in the Excel 2016 series:
  • How to move cells and their content.

  • How to insert a row.

  • How to copy formatting from one cell to another.

  • Excel fillHow to use the fill to enter the same kind of values and formatting in more cells.

  • How to use Ctrl + z to undo changes.


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





Do you want to try calculating sums? In next article there is a downloadable Excel file to work with, and Peter gives the solution in a demo.





Always the latest news in the kalmstrom.com blog


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

back icon next icon