Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


US Spreadsheet Error

Recently a simple error in a report by some economists contained a simple spreadsheet error that had the impact of claiming a negative average growth as apposed to the correct positive growth (see reports on MoneyWeb )

The error itself was very simple. In an AVERAGE calculation a number of cells were accidentally excluded. Although most reports seem to say that the formula was typed in incorrectly, we believe it is more likely that changes were made after the formula was setup.

If you watch the video clip below you will see how easy it is to accidentally insert rows into a spreadsheet that don’t get included in the formula because the insertion happens on the border of the range of cells. This is a particular problem when you insert the rows below the range because depending on your settings, the formula may or may not be updated.

Watch the video to see how to avoid this

Other ‘simple’ errors that often occur are shown in the video clips below: