Excel 2013, 2016, 2019 - Advanced

Unternehmensübergreifende Weiterbildung

An wen richtet sich die Weiterbildung?

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 Stunde(n)

Sprache(n) der Dienstleistung

EN

Nächster Termin

10.02.2025
Ort
Luxembourg

Preis

500,00€

Voraussetzungen

Basic Excel skills.

Ziele

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

Zertifikat, Diplom

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

Nächster Termin

Datum
Stadt
Sprache und Preis
10.02.2025

11.02.2025
Luxembourg
EN 500,00€

Diese Weiterbildungen könnten Sie interessieren

EN
Tag
Logiciel - Bürosoftware - Computergestützte Präsentationssoftware - Software PowerPoint
18.12.2024
EN
Tag
Blended-Learning
Logiciel - Bürosoftware - Tabellenkalkulationssoftware - Software Excel
05.12.2024
FR
Tag
Blended-Learning
Logiciel - Bürosoftware - Textverarbeitungssoftware - Software Word
19.12.2024