Elements and Performance Criteria
- Prepare to develop spreadsheet
- Organise personal work environment in accordance with ergonomic requirements
- Analyse task and determine specifications for spreadsheets
- Identify organisational and task requirements of data entry, storage, output, reporting and presentation requirements
- Apply work organisation strategies and energy and resource conservation techniques to plan work activities
- Develop a linked spreadsheet solution
- Utilise spreadsheet design software functions and formulae to meet identified requirements
- Link spreadsheets in accordance with software procedures
- Format cells and use data attributes assigned with relative and/or absolute cell references, in accordance with task specifications
- Test formulae to confirm output meets task requirements
- Automate and standardise spreadsheet operation
- Evaluate tasks to identify those where automation would increase efficiency
- Create, use and edit macros to fulfil requirements of task and automate spreadsheet operation
- Develop, edit and use templates to ensure consistency of design and layout for forms and reports, in accordance with organisational requirements
- Use spreadsheets
- Enter, check and amend data in accordance with organisational and task requirements
- Import and export data between compatible spreadsheets and adjust host documents, in accordance with software and system procedures
- Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
- Preview, adjust and print spreadsheet in accordance with organisational and task requirements
- Name and store spreadsheet in accordance with organisational requirements and exit application without data loss or damage
- Represent numerical data in graphic form