En collaboration avec:
Description
Objectives
After the training the participant will 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
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
Target audience
This course is addressed to good basic users, who wish to learn Excel furthermore in fields such as accountability, finances or science.
Prerequisites
Basic Excel skills
Conditions
Support de cours
-
Des supports de cours seront disponibles après les modules respectifs
-
Die Kursunterlagen werden nach den jeweiligen Modulen zur Verfügung gestellt
-
Course materials will be made available after the respective modules
Certificate
At the end of the training, the participants will receive a certificate of attendance delivered by the House of Training.
Location
L-1611 Luxembourg
Luxembourg
Sessions et horaires
Vous souhaitez rester à jour sur notre offre de formation ?
Inscrivez-vous à la newsletter