By the end of this course, learners will be able to:

• Use fundamental features of a spreadsheet application
• Gather and edit data
• Manage rows and columns in a worksheet
• Manage worksheets in a workbook
• Create formulas and functions
• Format data and cells
• Create and format standard charts
• Select spreadsheet settings
• Preview a spreadsheet and select print options

In-demand Digital Tools

• Getting Started with A Spreadsheet Application
  • Using the application
  • Working with workbooks
  • Basic spreadsheet concepts
  • Using functionalities of the application
• Manage Data in A Spreadsheet
  • Good practices in managing data
  • Enter & edit data
  • Moving within a worksheet
  • Cell selection techniques
  • Copy, cut & paste
  • Find & replace
  • Sort & filter
• Manage Worksheets
  • Insert, delete & format rows & columns
  • Insert, delete, rename, move & copy worksheets
• Perform Calculations
  • Arithmetic formulas
  • Excel functions
  • Cell referencing
• Perform Formatting of Data
  • Format data
  • Format cells
• Create Charts
  • Create standard charts
  • Format charts
• Set Up Worksheets and Select Print Options
  • Adjust page options
  • Header & footer
  • Adjust sheet display options
  • Preview worksheet
  • Select printing options

This training is relevant to all staff (Operational, Supervisory & Managerial) tasked with collating, managing and analysing data of the organisations to determine current performance and then develop recommendations for improvement to senior management.

Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3.

• Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 4
• Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 4
• Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 4
• Learners to have minimum GCE ‘O’ level or ITE certificate education
• Learner should have at least 1 year’s working experience in any industry
• Learners must have basic computer skills, i.e. be able to operate a personal computer, use keyboard and mouse