0

Subtraction in Excel

In this post we are going to learn how to subtract numbers from each other in Excel. Again, the key steps to remember are:

  1. Click where you want the answer to go
  2. Type in = (that tells Excel you are entering a formula)
  3. Click on the cell you want to subtract from
  4. Enter – (minus)
  5. Click on the cell you want to subtract
  6. Press Enter

The video below shows how it’s done and as always there is the file underneath for you to practise on.

 

Here is the file for you to practise on and by the end of this you should know how to subtract in Excel 

Continue Reading

0

Multiply in Excel

In this tutorial we are going to look at how to multiply in Excel. There are a couple of basic guidelines you should follow when you are using formulas in Excel. As always there is a practice file at the end that you can try out.

  1. One number per cell
  2. Click where you want the answer to go
  3. Begin with = (this tells Excel you are entering a formula)
  4. Click on cells you want to use.
  5. Press Enter when you are finished
  6. Copy it down…

 

View video below to see how it’s done

 

You can download the file here to practise on. 

 

 

 

Continue Reading

2

Fixing a cell in Excel – Absolute Cell Reference

Sometimes we want to use the same cell over and over in Excel. The way we do that is by creating an absolute cell reference. You may have come across it already when you have seen dollar signs ($) in formulas. In the video below I show you how to fix a cell. If you need to fix a row, you can read about it in this post and if you need to fix a column you can read about it in this post. As always there is a link to a file you can practise on below. Comments/suggestions always most welcome…

 

You can click on this link to download an Excel file to practise on – fixed_cell_only_exercise

Continue Reading