Spreadsheet Modelling

Spreadsheets can be used in many different situations, such as finance and engineering and the unit content
includes a wide range of spreadsheet features, formulae and functions. In addition, spreadsheet users need
to be able to choose from a variety of different ways of presenting and analysing spreadsheet data, including
producing graphs and filtering and sorting lists of data. Learners will be able to combine the skills developed to
produce a spreadsheet model that is tailor made for the specific needs of the user.

To speed up the use of spreadsheets, shortcuts are often used to enter data or duplicate particular
combinations of keystrokes. Learners will be able to create such shortcuts and recognise their potential in
improving efficiency.

In the IT industry, documentation is necessary for every application and system so that they can be maintained
and adapted over time. It is important that creators of spreadsheets are able to check and if necessary sort
out problems with their solutions to ensure that everything works as it should and that it is fit for the intended
purpose.

On completion of this unit a learner should:

Know what spreadsheets are and how they can be used

Be able to develop spreadsheet models

Be able to test and document spreadsheet models.