Excel 2016 from Scratch
House Costs Calculation B
An Excel tutorial by Peter Kalmstrom
In demo number 7 in the Excel 2016 from Scratch series Peter Kalmström, CEO
and Systems Designer of kalmstrom.com Business Solutions, showed how to calculate
the cost of buying a house when you have to borrow a certain percentage of
In the demo below, Peter continues on the same theme when he calculates other
housing costs by using formulas.
This is shown in the demo:
to copy formatting from one cell to another.
- How to move cells and their content.
- How to insert a row.
How to use the fill to enter the same kind
of values, formulas and formatting in more cells.
- How to use Shift + arrow and then Ctrl + D to enter the same kind of
values and formatting in more cells.
Peter uses Excel 2016 for his demo, but the Excel basics are the same for
earlier versions of Excel.