Séminaire S-IT0002 - Excel - core and essential features

Cible

Anyone who wants to master the general and essential features of Excel or to pass the ICDL certification.

Objectives

Obtain a global vision of the possibilities of handling the Excel spreadsheet in a professional environment. Participants will also be prepared to participate without difficulty in advanced and specialized courses about the Excel spreadsheet.

Contenu

  • Working with sheets :
      • open, create and save workbooks ;
      • select, insert and delete cells ;
      • data types, series and custom lists ;
      • find and replace contents, copy and move cells ;
      • one level data sort ;
      • customize options ;
      • default file locations.
  • Basic formulas and functions :
      • calculating with cells ;
      • use basic functions in calculations ;
      • error message significations ;
      • types of references ;
      • basic content check with the help of the logical IF-function.
  • Formatting sheets:
      • the autoformat tool ;
      • number and date formats ;
      • font and alignment settings ;
      • the format painter ;
      • merge cells ;
      • borders and special effects.
  • Creating charts :
      • 3 basic chart types ;
      • add, remove and handle chart elements.
  • Page layout and printing :
      • basic page setup ;
      • automatic fields in headers and footers ;
      • print area selection.
  • Managing workbooks :
      • insert, delete, rename, copy and move sheets ;
      • insert objects and use comments.
  • Sessions

    07.03.2022
    LU
    Cours en présentiel
    Luxembourg
    220 €
    25.03.2022
    VE - SA - JE
    Cours en présentiel
    Luxembourg
    220 €
    07.06.2022
    MA
    Cours en présentiel
    Luxembourg
    220 €
    04.10.2022
    MA
    Cours en présentiel
    Luxembourg
    220 €
    25.10.2022
    MA
    Cours en présentiel
    Luxembourg
    220 €