MS-Excel advanced (C1321)

Inter-company training

Duration

 30,00 hours(s)

10 weeks, 1 x 3 hours/week

Language(s) of service

EN

Who is organizing this training?

Le Luxembourg Lifelong Learning Centre (LLLC) est le centre de formation continue de la Chambre des salariés. Il dispose aujourd’hui d'une large gamme de formations continues qui s’adresse à un large public. Son offre de formation continue a pour but de: permettre aux professionnels d’optimiser leurs chances de promotion et d’évolution en entreprise, etc.

Who is the training for?

Anyone wishing to acquire advanced skills in spreadsheet utilization.

Prerequisites

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

Goals

  • 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.

Contents

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

Additional information

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

These courses might interest you