Management Spreadsheets
Description

The Management Spreadsheets module covers the advanced skills needed to use the versatile features of spreadsheets to produce reports, provide statistical or mathematical analysis, and manage data more effectively and productively.


The benefits of data-based decision-making are widely recognised. All types of organisation need workers who are able to use spreadsheets effectively – not just for storing tabular data, but for the sophisticated way that spreadsheets can be used to validate, interpret, and present information.


As data becomes easier to source and share, inputting, extracting, and displaying data (either internally or externally) is now a common task for workers in all types of role and every sector.

What will I learn?
What will I learn?

Successful candidates will be able to use enhanced spreadsheet capabilities to produce better reports with deeper data analysis. After passing this module, candidates will feel confident managing complex data with spreadsheets and collaborating with others. They will be able to:

  • understand advanced formatting options, including conditional formatting and customised formatting

  • recognise which functions to use in formulas, and troubleshoot errors

  • identify the correct chart to display a specific data set, and create or edit such a chart

  • know how to analyse, validate, audit, and protect data

  • understand time-saving features such as linking data, paste special, filters, and macros

Online E-Learning

Entry requirements
  • Leaving Certificate or equivalent, fluency in the English language and intermediate computer literacy level are required.

  • You will be required to complete and pass a basic IT Literacy entry quiz at the start of the course, if you do not pass the quiz you will not be able to continue with the programme.

  • All students should have access to a PC or laptop running a supported version of Windows (e.g Windows 10)Apple/Android devices are not supported and cannot be used for this course.

  • A broadband connection is essential to stream video content.

  • You require a web browser to view content and access web platforms. You will receive an Office 365 licence to use for the duration of the course.

Certification and Assessment

ICDL Profile Certificate in Management Spreadsheets

When can I start?
Duration
Course Fee
Module Brochure

Payment Options

Payment in full through Lir Shop, or by secure Payment Link

I'm a paragraph. Click here to add your own text and edit me. It's easy.