Nouveau
  • Icon 17.10.2019
  • Icon 14 h
  • icon Cours du jour
  • Icon English
  • Icon IF003CJ
àpd. 450,00 EUR (+3% TVA)

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

jeu. 17.10.2019 à 08h30

icon 4H

Excel 2013/2016 - Fondamentals

  • icon Chambre de Commerce Luxembourg

jeu. 17.10.2019 à 13h30

icon 4H

Excel 2013/2016 - Fondamentals

  • icon Chambre de Commerce Luxembourg

ven. 18.10.2019 à 08h30

icon 4H

Excel 2013/2016 - Fondamentals

  • icon Chambre de Commerce Luxembourg

ven. 18.10.2019 à 13h30

icon 2H

Excel 2013/2016 - Fondamentals

  • icon Chambre de Commerce Luxembourg

Vous souhaitez rester à jour sur notre offre de formation ?

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