Cours du soir C1321 - MS-Excel advanced

Public cible

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.

Sessions

Il n'y a pas de cours de prévu dans les prochains jours.

Ce cours est lié à des profils