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 the sum.
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:
- How 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.