Excel 2016 from Scratch
House Costs Calculation B
An Excel tutorial by Peter Kalmstrom
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 the
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.