SPREADSHEETS

This module allows candidates to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.

LEARNING OUTCOMES

  • Work with spreadsheets and save them in different file formats.

  • Choose built-in options, such as the Help function, within the application to enhance productivity.

  • Enter data into cells; use good practice in creating lists.

  • Select, sort and copy, move and delete data.

  • Edit rows and columns in a worksheet.

  • Copy, move, delete, and appropriately rename worksheets.

  • Create mathematical and logical formulas using standard spreadsheet functions; use good practice in formula creation; recognise error values in formulas

  • Format numbers and text content in a spreadsheet.

  • Choose, create, and format charts to communicate information meaningfully.

  • Adjust spreadsheet page settings.

  • Check and correct spreadsheet content before finally printing spreadsheets.

BENEFITS

  • Covers the key skills needed to use spreadsheets.

  • Can be applied to a range of spreadsheets software from vendor packages to ‘freeware’.

  • Certifies best practice in effective spreadsheets software use.

  • Developed with input from computer users, subject matter experts, and practising computer professionals
    from all over the world. This process ensures the relevance and range of module content.

SYLLABUS

© 2020 MMU CNERGY. ALL RIGHTS RESERVED.