Excel 2013, 2016, 2019 - Advanced

Betribsiwwergräifend Formatioun

U wie riicht sech d'Formatioun?

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

Dauer

12,00 Stonn(en)

Sprooch(e) vun der Déngschtleeschtung

EN

Nächst Sessioun

09.12.2024
Plaz
Luxembourg

Präis

500,00€

Virkenntnisser

Basic Excel skills.

Ziler

After the training the participant shall be able to:

  • use the advanced spreadsheet functionalities.

Inhalt

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, Diplom

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

Nächst Sessioun

Datum
Stad
Sprooch & Präis
09.12.2024

10.12.2024
Luxembourg
EN 500,00€
11.12.2024

12.12.2024
Luxembourg
EN 500,00€

Dës Formatioune kéinten Iech interesséieren

EN
Dag
Blended-Learning
Logiciel - Logiciel Content Management Entreprise - Spreadsheet-Logiciel - Logiciel Excel
EN
Dag
Blended-Learning
Logiciel - Logiciel Content Management Entreprise - Logiciel Textveraarbechtung - Logiciel WORD