by admin | Jul 18, 2012 | Excel | General, Excel | Intermediate Lessons, Excel | Useful tricks
As a link to my other tutorial on printing , I am going to show you how to do the following in this tutorial: Set a print area Clear a print area Hide columns/rows if you only want to print specific parts of the spreadsheet, that may not be side by side… As...
by admin | Jul 8, 2012 | Excel | General, Excel | Intermediate Lessons
In this post we are going to look at how to combine Excel files. We are also going to look at how to view multiple files on the screen at the same time and how to save these together as a workspace so that we can open all of them together again. Please enable...
by admin | Jun 26, 2012 | Excel Functions | Useful, Excel | General, Excel | Intermediate Lessons
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 | Intermediate Lessons
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 Functions | Useful, Excel | Intermediate Lessons
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...
