Financial Spreadsheets

Print Page

This module sets out advanced skills that can be used in finance and accountancy to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.

  • Apply advanced formatting options such as conditional formatting or customised number formatting and handle worksheets
  • Use functions such as those associated with logical, statistical, financial and mathematical operations.
  • Create charts and apply advanced chart formatting
  • Work with tables and lists to analyse, filter and sort data. Create and use scenarios
  • Validate and audit spreadsheet data.
  • Enhance productivity by working with named cell ranges
  • Use linking, embedding and importing features to integrate data
  • Compare and merge spreadsheets. Apply spreadsheet security features
  • Acquire advanced skills relating to the analysis of financial data
  • Create and display tabular and charted outputs, and integrate and link data to create powerful and relevant financial information
  • Developed with input from subject matter experts and practitioners

The Syllabus sets out the specific knowledge and skills that make up this module, as informed by input from subject matter experts from a wide range of computer societies and organisations.

Category

Skillest

Formatting
  • Cells
  • Worksheets
Formulas and Functions
  • Using Formulas and Functions
Charts
  • Creating Charts
  • Formatting Charts
Analysis
  • Using Tables
  • Sorting and Filtering
  • Scenarios
Validating and Auditing
  • Validating
  • Auditing
Enhancing Productivity
  • Naming Cells
  • Paste Special
  • Linking, Embedding and Importing
Collaborative Editing
  • Reviewing and Security

ECDL Foundation provides sample tests to enable potential candidates and employers to understand ECDL/ICDL Financial Spreadsheets in more depth and prepare for testing.

Download the Financial Spreadsheets Sample Test (.zip)

Please note: Answers are provided for the multiple choice questions of the sample papers, please refer to Specto approved courseware for information on practical tasks.