Loading...

Spreadsheets

The Spreadsheets module covers the main concepts and skills needed to use spreadsheets, such as tasks associated with developing, formatting, modifying, and using a spreadsheet.

Organising and analysing data using a spreadsheet application produces useful insights for all types of organisation. In addition to using standard formulas and functions, this module covers visualisation of data through creating and formatting graphs or charts.

The analysis of numerical data is an important activity in a wide range of job roles. Accountants, project managers, sales executives, engineers – and many more – rely on spreadsheets to carry out crucial calculations.

Develop the key skills needed to organise and analyse data using spreadsheet software

Module overview

CategorySkill set
Using the application
  • Working with spreadsheets
  • Enhancing productivity
Cells
  • Insert, select
  • Edit, sort
  • Copy, move, delete
Managing worksheets
  • Rows and columns
  • Worksheets
Formulas and functions
  • Arithmetic functions
  • Functions
Formatting
  • Numbers/dates
  • Contents
  • Alignment, border effects
Charts
  • Create
  • Edit
Prepare outputs
  • Setup
  • Check and print

Main learning outcomes

Successful candidates will be able to use a spreadsheet application to create and work with spreadsheets. After passing this module, candidates will feel confident entering, moving, editing, and deleting data, as well as performing common spreadsheet tasks. They will be able to:

  • understand the key concepts of spreadsheets
  • use available help resources and shortcuts to enhance productivity
  • recognise good practice in inserting, editing, and deleting data
  • apply a range of mathematical and logical formulas and functions
  • know how to communicate information using charts and graphs
click here for more information / resources