ecdl spreadsheets


Boo

ECDL® Certification

Spreadsheets

How to use a spreadsheet to record, layout, analyse, graph and report on data using a spreadsheet application.

icon

Make numbers work for you by learning how to use spreadsheets to record and analyse data.

CLISTE Resources icon

Format numbers and text, and use functions to create mathematical and logical formulas.

CLISTE Resources icon

Manage multiple workbooks, and save time with built-in templates and auto-complete features.

CLISTE Subjects icon

Illustrate data patterns and gain insights with stylish, high-impact charts and graphs.

What you will learn

Discover how to develop, modify and use a spreadsheet for typical data management and analysis tasks. Learn how to use formulas and functions for performing calculations, and create graphs and charts based on spreadsheet data.

01

Work with spreadsheets and save them in different file formats

02

Choose built-in options such as the Help function within the application to enhance productivity

03

Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data

04

Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets

05

Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas

06

Format numbers and text content in a spreadsheet

07

Choose, create and format charts to communicate information meaningfully

08

Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets


SUBSCRIBE TO OUR NEWSLETTER

Why not keep up to date with all our latest news and events?

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our privacy policy page.