Boo

ECDL® Certification
Advanced
Spreadsheets

How to work with advanced spreadsheet features, from complex functions to collaboration.

iconBecome more confident, efficient and effective in using a spreadsheet application.

CLISTE Resources iconBe able to use advanced functions for logical, statistical, financial and mathematical operations.

CLISTE Subjects iconApply customised number formatting, and create charts with sophisticated chart formatting features.

CLISTE Yearly Plan iconUnderstand various validation, auditing, collaboration and security features to protect data and spreadsheets.

What you will learn


Master the more advanced features of spreadsheet applications – such as logical, statistical, financial and mathematical functions, input validation and spreadsheet auditing, and collaboration, tracking and security options.

01

Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets.

02

Use functions such as those associated with logical, statistical, financial and mathematical operations.

03

Create charts and apply advanced chart formatting features.

04

Work with tables and lists to analyse, filter and sort data.

05

Create and use scenarios.

06

Validate and audit spreadsheet data.

07

Work with named cell ranges, macros and templates.

08

Use linking, embedding and importing features to integrate data.

09

Collaborate on and review spreadsheets.

10

Apply spreadsheet security features.


Who we work with.
What we offer.

Online programme delivery, learner administration, training content development, online testing and certification, telephone and online support, membership, event and project management, and digital marketing and brand promotion – these are among the services provided by ICS Skills. Here are a few of the clients we serve:

ECDL Ireland Ltd. trading as ICS Skills. Registered in Dublin, Ireland No. 265078. ICS Skills is a Registered Charity in Ireland No. CHY 12259