Advanced ExcelThe Advanced (ECDL Advanced, ICDL Advanced) Spreadsheets unit is 1 of 5 that is covered within our Teach Yourself Advanced Office manuals, which are designed to help self-study learners gain globally recognised (ECDL Advanced, ICDL Advanced, ICDL Expert and ECDL Expert) qualifications. This unit covers complex tasks within a Spreadsheet (Microsoft Excel) application, including using advanced formatting options such as conditional formatting and functions associated with logical, statistical, financial and mathematical operations, working with tables and lists to analyze, filter and sort data and creating and using scenarios (unit prices from just £6.99, examinations not included). All our manuals cover Microsoft Office 2007, 2010, 2013 and 2016 versions.

Entry Requirements

Although there are no specific entry requirements for ECDL level 3 courses, it is advisable that self-study learners have some prior knowledge of the Microsoft Excel application in completing the ECDL Advanced (European Computer Driving Licence) and ICDL Advanced (International Computer Driving Licence) level 3 Excel course.


Course Contents

Questions, answers and work-files covering the ECDL Advanced Spreadsheets unit/module:


  • Underpinning Knowledge
  • Macros (custom buttons)
  • Freeze Panes
  • Filtering Data
  • Text Formatting
  • Hyperlinks
  • Sort Data Range
  • Multi-Functions
  • Scenarios
  • CONCATENATE Function
  • Document Security
  • 3D Sums
  • Comments
  • Charts
  • DCOUNT Function
  • Move/Copy Worksheets
  • UPPER Function
  • IF Function
  • Define Cell Name
  • DATE Function
  • Hide Data
  • Table Formatting
  • Show Formulas
  • VLOOKUP Function
  • HLOOKUP Function
  • ROUND Function
  • Split Windows
  • Merge Spreadsheets
  • Paste Special
  • Manipulate Pivot Table
  • PAYMENT (PMT) Function
  • Absolute Cell Referencing
  • DSUM Function
  • DMIM Function
  • DAVERAGE Function
  • COUNTA Function
  • Conditional Formatting (2013 versions onwards)
  • Advanced Filtering (2013 versions onwards)
  • Validation Criteria (2013 versions onwards)
  • Input Messages and Error Alerts (2013 versions onwards)
  • Custom Number Format (2013 versions onwards)
  • Track Changes (2013 versions onwards)
  • Accept and Reject Changes in a Worksheet (2013 versions onwards)
  • Missing Dependents (2013 versions onwards)
  • Chart Formatting (2013 versions onwards)




  • Two full practice tests
  • Marking schemes
  • Exam tips
  • Shortcut tips



There are over 2,000 ECDL, ITQ local testing centres throughout the UK and over 10,000 ICDL testing centre worldwide. The ECDL Advanced and ICDL Advanced examinations have no registration fee but examinations cost £70 per exam (prices may vary), please contact your local ECDL/ICDL testing centre for further information.


Study Period

There is no specific time limit set by the ECDL, ICDL awarding bodies to complete the ECDL Advanced and ICDL Advanced modules/units.


QCF Level

ECDL Advanced (level 3) qualifications are recognised by the "Qualifications and Credit Framework" and are equivalents to UK ‘A-Level’ standards.


Attainable Certifications

There are several recognised certifications that can be achieved or worked towards via the Advanced Spreadsheets (Excel) unit/module, these include:


  • ECDL Advanced Spreadsheets
  • ICDL Advanced Spreadsheets
  • ECDL Expert (worked towards)
  • ICDL Expert (worked towards)
  • ITQ Level 3 Certificate in IT User Skills (worked towards)