by admin | May 31, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons
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: Click where you want the answer to go Type in = (that tells Excel you are entering a formula) Click on the cell you want to...
by admin | May 29, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons
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. One number per cell...
by admin | May 17, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons
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...
by admin | May 17, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons
Fixing a column in Excel Sometimes we need to be able to use the contents of a column over and over again in our formulas. In order to do this easily we need to fix the column. In other posts, I have shown you how to fix a cell and also how to fix a row Excel Products...
by admin | May 17, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons
How to fix/lock a reference to a row in Excel In another post I have shown you how to create a reference to a locked/fixed cell. However at times we need to be able to fix a reference to a row. For example if you need to calculate a set of daily numbers against a...