Excel 365 Pro Plus - 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

14,00 heure(s)

Langues(s) de prestation

EN

Prochaine session

29.06.2023
Lieu
Luxembourg

Prix

490,00€

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

  • COUNTIFS, SUMIFS
  • XLOOKUP
  • IF, IFS, SWITCH
  • IFERROR/IFNA
  • Date Functions
  • Text Functions (Concat, text join)
  • Dynamic arrays

Data Table

  • Create a data table (Format as Table)
  • Create formulas using structured references in a Data table

Managing Lists

  • Remove duplicates
  • Recommended Pivot Tables
  • Cross data into a table (PivotTable) or a graph (PivotChart)
  • Create a PivotTable based on multiple source tables (Data Model)
  • Forecast sheet

Check data

  • Auditing tools
  • Achieve a target value (Goal seek)
  • Evaluate a formula
  • Data Types

Certificat, diplôme

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

Prochaine session

Date
Ville
Language & prix
29.06.2023

30.06.2023
Luxembourg
EN 490,00€
24.08.2023

25.08.2023
Luxembourg
EN 490,00€
25.09.2023

26.09.2023
Luxembourg
EN 490,00€

Ces formations pourraient vous intéresser

EN
Journée
Blended-Learning
Logiciels - Logiciel bureautique - Logiciel tableur - Logiciel Excel
FR
Journée
Blended-Learning
Logiciels - Logiciel bureautique - Logiciel tableur - Logiciel Excel
27.09.2023