Dates in Report Headers
When you format the widths of columns in a report, such as a board report, you have to be careful with dates to make sure they are...
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...