Spreadsheet

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.
Successful learners will be able to combine the skills learned to produce a spreadsheet solution
that is tailor-made for the specific needs of the user.

To speed up the use of spreadsheets, shortcuts are often employed 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.