ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)

During the course, you will get to how to use advanced functions such as


complex formula writing, inserting and editing functions, defining names,


tracing formulas, and diagnosing errors.

Course Objectives

At the end of this course, you should be able to:

  • Use advanced formatting, formulae and charts features to enhance a spreadsheet

  • Analyse, validate and audit data in a spreadsheet

  • Use advanced spreadsheet functions to enhance productivity

  • Manage collaborative editing to a spreadsheetnage collabrative editing to a spreadsheet