Nouveau
  • Icon 25.11.2021
  • Icon 12 h
  • icon Formation présentielle
  • icon Formation à distance
  • icon Cours du jour
  • Icon English
  • Icon IF032CJ
440,00 EUR

*

(+3% TVA)

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

In collaboration with


Key Job

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.

Certificate


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

Lieu

Télécharger le planning PDF

jeu. 25.11.2021 à 09h00

icon 3H

Excel 2013, 2016, 2019 - Advanced

  • icon Key Job S.A.

jeu. 25.11.2021 à 13h15

icon 3H

Excel 2013, 2016, 2019 - Advanced

  • icon Key Job S.A.

ven. 26.11.2021 à 09h00

icon 3H

Excel 2013, 2016, 2019 - Advanced

  • icon Key Job S.A.

ven. 26.11.2021 à 13h15

icon 3H

Excel 2013, 2016, 2019 - Advanced

  • icon Key Job S.A.

Vous souhaitez rester à jour sur notre offre de formation ?

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