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.


Spreadsheet Risk Awareness And Control

Spreadsheet Risk Awareness And Control

Continuing on a previous theme around spreadsheet risk awareness and control, Huffington Post is reporting on another issue relating to spreadsheets. In this case it is less to do with errors in a spreadsheet and more with the confidential data stored on spreadsheets.

It seems that an Excel spreadsheet exists within the affected organisation which details employees who have family members that are in some way related to ‘projects of interests’ and presumably would receive special attention.

Other similar examples related to spreadsheets sent out with pivot tables of summarised information. What the sender did not realise is that by simply double clicking the grand total of the pivot table, you can extract all the detailed (and sensitive) information.