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. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


Excel Version Control and Naming Conventions

Excel Version Control and Naming Conventions especially in financial models

A big problem with financial models is that sometimes a number of versions are created and it is not always clear which is the latest version. Excel version control can be a real problem.

A simple solution is to make sure you have appropriate naming conventions. In our opinion you should always start with a date but in a particular format to help with the sorting in folders. We tend to start the file name with the date in the format yyyymmdd so for example 20130815 Example File v1.xls .

If you use this method, when you sort in the folder it will sort the files in date order. If you put the date at the end or use words you get August coming before June and the like.

We generally then give it a useful name, a version number and if really hectic we add a time as well.