Comparing Lists
Sometimes it is necessary to compare information that is contained in two lists to see if there is duplication in the two lists. To...
Excessive Rows (and/or Columns)
Have you ever opened a spreadsheet and noticed that there seems to be thousands of rows (and/or columns - we will only discuss rows in...
Printing - Multiple Pages from a single worksheet
Often when we are creating an Excel based report, we need to print various sections. If all the information is contained within one...
Formulas not calculating
One problem that we are asked about on a fairly regular basis is to do with formulas not calculating in a spreadsheet. We will not go in...
DOUBLE CLICKING TO A FORMULA
Double Clicking in a cell to take you directly to the source of data of the formula is possibly one of the most useful tricks available...
PASTE VISIBLE CELLS ONLY
Copying cells and pasting them in to visible cells can be a problem. This is a problem when you drag the cell contents down as well as...
UPPER, LOWER & PROPER
UPPER, LOWER and PROPER are three functions that are very useful and help you save time and help ensure consistency. These three...
Many (thousands of) Rows
We often analyse files containing many hundreds or thousands of rows, with multiple columns of data. With this amount of data it can be...
Cell NAMES (Names part 1)
We use NAMES to define cells all the time. It's so much easier to understand formula. As part of any good design we set one tab to be a...
Spreadsheet v Database
A question that we are being asked more and more is “When should I use a database rather than a spreadsheet?” Excel and Access are, in...