This unit introduces learners to the more advanced features and functions of spreadsheets. Learners will also be introduced to how spreadsheets can be used to support organisational activities such as credit control, sales forecasting and stock analysis.
Spreadsheets can be set up as reusable templates which produce immediate results when data is input such as payroll or invoice templates.
Utilities such as ordering, sorting and filtering will show the same data in different ways. Charts and graphs help to display information more visually. Complex calculations can be carried out using library functions or users can choose to create their own formulae.
One of the main advantages of spreadsheet software is that it can be customised with buttons and macros.