The Financial Spreadsheets module covers the advanced skills needed to produce sophisticated reports, perform complex mathematical and statistical calculations, and improve productivity using a spreadsheet application.
Spreadsheets are an important tool for managing and analysing financial data. But taking advantage of the more advanced features that spreadsheet tools offer needs deeper, enhanced skills. This module will help professionals use the complex capabilities of spreadsheet tools to understand data and make informed decisions.
This module is suitable for people who are already proficient in common spreadsheet activities, such as those covered in the ICDL Spreadsheets module. It looks at elements of spreadsheet use most relevant to people working in finance roles and complements the skills and concepts in the ICDL Spreadsheets (Advanced) module.
Successful candidates will be proficient using the advanced features of spreadsheet tools for the analysis of financial data. After passing this module, candidates will feel confident using spreadsheets to carry out logical, statistical, financial, and mathematical operations. They will be able to:
understand functions such as those associated with logical, statistical, financial, and mathematical operations
use tables and lists to analyse, filter, sort, validate, and audit data, as well as create and use scenarios
apply advanced formatting options such as conditional formatting, customised number formatting, and chart formatting
use linking, embedding and importing features as well as comparing and merging spreadsheets
understand the productivity and security features of spreadsheet tools.
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.
ICDL Profile Certificate in Financial Spreadsheets
Payment in full through Lir Shop, or by secure Payment Link