by admin | Jun 26, 2012 | Excel Path - Step by Step
If you need to quickly copy formatting from one cell to another, the Format Painter tool in Excel is a gift. You can use it to copy formatting once or multiple times. This video shows you how. For example, if you have formatted a spreadsheet on Monday but can’t...
by admin | Jun 19, 2012 | Excel Path - Step by Step
In this tutorial we are going to look at how to hide rows and columns in Excel. This technique is very useful if you only want to look at part of your list or if you only want to print some of your spreadsheet ( you can hide the rows or columns you want to omit) You...
by admin | Jun 7, 2012 | Excel Path - Step by Step
In this Vlookup tutorial we are going to look at how to use the Vlookup function. Essentially what this does is allow you to match up information from two lists and pull in matching information. An example would be if we have a list of part numbers and we want to pull...
by admin | Jun 5, 2012 | Excel Path - Step by Step
Conditional formatting Conditional formatting in Excel 2007 (and later) allows us to colour cells on a spreadsheet depending on whether or not they meet certain conditions. While it existed to some degree in Excel 2003, it has been seriously beefed up in Excel 2007...
by admin | May 31, 2012 | Excel Path - Step by Step
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 Path - Step by Step
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...
