"I find that the harder I work, the luckier I seem to get."
-- Thomas Jefferson
Knowledge
Featured White Papers
Financial Modelling Best Practice Guidelines
Provides best practice guidelines that should be considered when building spreadsheets so as to minimise the risk of errors occurring, and improve reliability. usability, robustness and accuracy.
Essential reading for anyone involved in building financial models!
This white paper has some great ideas on how to have fun in Excel (usually at your colleague's expense!) *evil laugh*
If you'd like some ideas about how to mess with your friend's head, download this paper now!
Mulitply a range of cells by a factor - I have a range of cells that contain formulae and values. I need to multiply all the cells in the range by a factor. The factor could change. Is there is any easy solution?
The easiest way is to use a range
name. First enter the factor value in a cell and name
that cell Factor ...
You may come across some interesting
behaviour (aka a real "gotcha") when working with
Pivot Tables and VBA Macros in protected workbooks and sheets ...
Templates - I use a lot of custom formats and custom colours in my spreadsheets. I have to re-create them in my new files. Is there a way to have these custom formats automatically included in new sheets and files?
Yes,
by using templates. Excel allows you to create templates
that have specific uses ...
The & character is used to define
certain information that can be printed in Headers and
Footers ...
Stop zeroes displaying on line Charts - I have a line chart which has all the months of the year displayed. Each month is linked to a data cell. This means that future months display zero values. The line chart drops down to zero for these future months. Instead of having to change the chart range each month I want to stop the chart plotting the zero values for the future months. Is this possible?
You can use Excel's feature of not
plotting error values on charts to stop it displaying
the zero values ...
