Skip to content

We would like to inform you that both our Computer Pride Nairobi and Mombasa offices will be closed completely from Wednesday, 19th July 2023 to Thursday, 27th July 2023. We will resume our regular operations on Friday, 28th July 2023.

This closure is in observance of the special Ashara Mubaraka prayers. In case of any urgent inquiries or assistance, please feel free to contact us at info@computer-pride.co.ke.

Search...

Financial Spreadsheets

Courses Overview

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.

  • Formatting
  • Formulas and functions
  • Charts
  • Analysis
  • Validating and auditing
  • Enhancing productivity
  • Collaborative editing

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.

Develop the advanced spreadsheet skills needed for finance and accountancy tasks.

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.