Nouveau
  • Icon 04.05.2021
  • Icon 14 h
  • icon Cours du jour
  • icon Formation présentielle
  • Icon English
  • Icon IF003CJ
450,00 EUR

*

(+3% TVA)

   Cette formation est proposée sous forme de formation présentielle. En savoir plus

Objectives


After the training the participant shall be able to:

  • create tables and manage the tables’ calculations, formatting and page layout

  • use Excel efficiently 

  • put into practice learned tips and tricks

Programme


  • Introduction

    • Understanding the Excel environment (purpose, specific vocabulary…)

    • Manipulating cells and worksheets (selecting techniques, renaming, moving and deleting sheets…)

    • Entering data (text, numeric, using the fill handle, the custom lists...)

  • Calculate

    • Creating formulas

    • Using functions (autosum, average, square root, round…)

    • Using the absolute, relative and mixed references

  • Formatting

    • Formatting tables (fonts, borders, alignments, number format, cell width and height, add or delete rows and columns, autoformat)

  • Charts

    • Creating and modifying

  • Page setup and printing

    • Orientation, adjust, header and footer, print area…

  • Databases

    • Sorting and using autofilters

  • Tips and tricks

  • Exercises

Target audience


Anyone who wishes to learn how to create and manage electronic tables.

Certificate


At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.

Course material


The training material will be handed out at the beginning of the course.

Lieu

Télécharger le planning PDF

mar. 04.05.2021 à 08h30

icon 3H30

Excel 2013/2016 - Fundamentals

  • icon Chambre de Commerce Luxembourg

mar. 04.05.2021 à 13h30

icon 3H30

Excel 2013/2016 - Fundamentals

  • icon Chambre de Commerce Luxembourg

mer. 05.05.2021 à 08h30

icon 3H30

Excel 2013/2016 - Fundamentals

  • icon Chambre de Commerce Luxembourg

mer. 05.05.2021 à 13h30

icon 3H30

Excel 2013/2016 - Fundamentals

  • icon Chambre de Commerce Luxembourg

Vous souhaitez rester à jour sur notre offre de formation ?

Vous avez une question ?
Nous avons des réponses !