Copy and paste. In Windows, there are very few functions that everyone will use, but the ability to copy data in one place, and put it in another is considered to be one of the most basic IT skills. Even the keyboard shortcuts (Ctrl+C, Ctrl+V) are known by office workers all across the world.

There are lots of reasons that people use Microsoft Excel. However, these reasons fall into three basic categories; storing data, analysing data and displaying data. Often a single spreadsheet will be used for all three, and it is the display of data that forms the basis for this article.