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

Description

Objectives

After the training the participant shall be able to:

  • use the advanced spreadsheet functionalities.
Programme
  • Functions (refresh)

    • Insert Function using the wizard

    • Insert function manually, semi-automatic formula input

  • Use range names (refresh)

    • Create and use a range name

    • Edit and delete a range name, define its scope (file, spreadsheet)

  • Conditional formatting

    • Apply a predefined conditional formatting

    • Customize a conditional formatting

  • Advanced Functions

    • Use functions: SumIf, CountIf, Vlookup, If, And, Or, Match ….

    • Nested functions

  • Data Table

    • Create a data table (Insert Table)

    • Create formulas using references of a Data table

  • Managing Lists

    • Filter data: advanced filters

    • Remove duplicates

    • Use automatic totals (Subtotals)

    • Recommended Pivot Tables

    • Cross data into a table (PivotTable) or a graph (PivotChart)

  • Check data

    • Auditing tools

    • Achieve a target value (Goal seek)

    • Evaluate a formula

  • Consolidate Data

Target audience

This course is addressed to good basic users, who wish to learn Excel furthermore in fields such as accountability, finances or science.


Modalités

Support de cours

Le support de cours sera délivré en début du cours.

Certificate

By the end of the training, the trainee will receive a certificate of participation issued by the House of Training.

Lieu
Key Job S.A.
65, Avenue de la Gare
L-1611 Luxembourg
Luxembourg
Calculer l'itinéraire

Sessions et horaires

Télécharger le planning (PDF)

  • jeu. 16.06.2022

    09:00 à 16:00

    6H

    Excel 2013, 2016, 2019 - Advanced

    Key Job S.A.

  • ven. 17.06.2022

    09:15 à 16:15

    6H

    Excel 2013, 2016, 2019 - Advanced

    Key Job S.A.

Télécharger le planning (PDF)

  • jeu. 22.09.2022

    09:00 à 16:00

    6H

    Excel 2013, 2016, 2019 - Advanced

    Key Job S.A.

  • ven. 23.09.2022

    09:00 à 16:00

    6H

    Excel 2013, 2016, 2019 - Advanced

    Key Job S.A.