C1321 - MS-Excel advanced
Target Audience
Anyone wishing to acquire advanced skills in spreadsheet utilization.
Objectives
- 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.
Prerequisites
Successful completion of the module « MS-Excel essentials » (C1320) or proof of equivalent certified knowledge.
Notes
Participants are entitled to take the ICDL « Spreadsheet advanced » test free of charge.
