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.
Successful candidates will be able to use a spreadsheet application to create and work with spreadsheets. After passing the certification test for 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
Module overview
Category
Skill 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
Module Resources
This module includes the following resources:
Access to an online eLearning platform
eLearning content
An eBook
Two diagnostic assessments
One online certification test (that may be retaken once, if necessary)
