Advanced ECDL: Spreadsheets

The following is the syllabus for Module AM4, Spreadsheets, Advanced Level, which provides the basis for the practice test in this module. The Syllabus for Module AM4 is over and above the Skills Sets and underpining knowledge contained within the ECDL 4, Spreadsheets. The advanced level designation for Module AM4 anticipates that the candidate had already mastered the Skill Sets and acquired knowledge outlines in Module 4 of the ECDL Syllabus.

To Be Added

Apply an autoformat/table style to a cell range.
Apply conditional formatting based on cell content.
Create and apply custom number formats.
Copy, move worksheets between spreadsheets.
Split a window. Move, remove split bars.
Hide, show rows, columns, worksheets.

Use date and time functions: today, now, day, month, year.
Use mathematical functions: rounddown, roundup, sumif.
Use statistical functions: countif, countblank, rank.
Use text functions: left, right, mid, trim, concatenate.
Use financial functions: fv, pv, pmt.
Use lookup functions: vlookup, hlookup.
Use database functions: dsum, dmin, dmax, dcount, daverage.
Create a two-level nested function.
Use a 3-D reference within a sum function.
Use mixed references in formulas.

Create a combined column and line chart.
Add a secondary axis to a chart.
Change the chart type for a defined data series.
Add, delete a data series in a chart.
Re-position chart title, legend, data labels.
Change scale of value axis: minimum, maximum number to display, major interval.
Change display units on value axis without changing data source: hundreds, thousands, millions.
Format columns, bars, plot area, chart area to display an image.

Create, modify a pivot table/datapilot.
Modify the data source and refresh the pivot table/datapilot.
Filter, sort data in a pivot table/datapilot.
Automatically, manually group data in a pivot table/datapilot and rename groups.
Use one-input, two-input data tables/multiple operations tables.
Sort data by multiple columns at the same time.
Create a customized list and perform a custom sort.
Automatically filter a list in place.
Apply advanced filter options to a list.
Use automatic sub-totalling features.
Expand, collapse outline detail levels.
Create named scenarios.
Show, edit, delete scenarios.
Create a scenario summary report.

Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time.
Enter input message and error alert.
Trace precedent, dependent cells. Identify cells with missing dependents.
Show all formulas in a worksheet, rather than the resulting values.
Insert, edit, delete, show, hide comments/notes.

Name cell ranges, delete names for cell ranges.
Use named cell ranges in a function.
Use paste special options: add, subtract, multiply, divide.
Use paste special options: values /numbers, transpose.
Create a spreadsheet based on an existing template.
Modify a template.
Insert, edit, remove a hyperlink.
Link data within a spreadsheet, between spreadsheets, between applications.
Update, break a link.
Import delimited data from a text file.
Record a simple macro like: change page setup, apply a custom number format, apply autoformats to a cell range, insert fields in worksheet header, footer.
Run a macro.
Assign a macro to a custom button on a toolbar.

Turn on, off track changes. Track changes in a worksheet using a specified display view.
Accept, reject changes in a worksheet.
Compare and merge spreadsheets.
Add, remove password protection for a spreadsheet: to open, to modify.
Protect, unprotect cells, worksheet with a password.
Hide, unhide formulas.