Excel 2013, 2016, 2019 - Advanced

Formation inter-entreprise

À qui s'adresse la formation?

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

Durée

12,00 heure(s)

Langues(s) de prestation

EN

Prochaine session

23.05.2024
Lieu
Luxembourg

Prix

500,00€

Prérequis

Basic Excel skills.

Objectifs

After the training the participant shall be able to:

  • use the advanced spreadsheet functionalities.

Contenu

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 (SOMME.SI), CountIf (NB.SI), Vlookup (RECHERCHEV), If (SI), And (ET), Or (OU), Match (EQUIV) ….
  • 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

Certificat, diplôme

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

Prochaine session

Date
Ville
Language & prix
23.05.2024

24.05.2024
Luxembourg
EN 500,00€

Ces formations pourraient vous intéresser

FR
Journée
Blended-Learning
Logiciels - Logiciel bureautique - Logiciel PREAO - Logiciel Power Point
14.06.2024
FR
Journée
Classe virtuelle
Logiciels - Logiciel bureautique - Logiciel traitement texte - Logiciel WORD
28.06.2024