MS-Excel advanced (C1321)

Successful completion of the module « MS-Excel essentials » (C1320) or proof of equivalent certified knowledge.

• Manipulate the spreadsheet in an effective way.
• Manage the various types of links.
• Learn formula auditing and error checking.
• Work with nested function implementations and array definitions.
• Use and integrate lookup functions.
• Know the database management features of a spreadsheet.
• Use analysis and summarization tools.
• Manage scenarios.

Le contenu est identique aux objectifs d'apprentissage pour cette formation.

Participants are entitled to take the ICDL « Spreadsheet advanced » test free of charge.