by admin | May 28, 2012 | Excel Path - Step by Step
Graphs in Excel In this post, I am going to show you how to create a chart in Excel. As always the download file is underneath for you to practise on. Also, the two shortcuts I mentioned were: F11 to create an instant chart on another sheet (after you have highlighted...
by admin | May 17, 2012 | Excel Path - Step by Step
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 Path - Step by Step
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 Path - Step by Step
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...
by admin | May 14, 2012 | Excel Path - Step by Step
The SumifS function is a new function that was brought in in Excel 2007. Essentially, it is an upgrade for the SumIf function in the sense that it allows you to sum numbers based on more than one criteria. I plan to do another post on this to show you how to use...
by admin | May 14, 2012 | Excel Path - Step by Step
Welcome to this post about sorting in Excel. This tutorial refers to Excel 2007/2010 and later. A couple of things about sorting before you start. The whole experience will be pretty painless if you tidy up your list to make sure you have the following:...