Cette formation est proposée sous forme de formation présentielle et à distance. En savoir plus
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.
Conditions
Course Material
The training material will be handed out at the beginning of the course.
Certificate
By the end of the training, the trainee will receive a certificate of attendance issued by the House of Training.
Location
Key Job S.A.
Calculate the itinerary
65, Avenue de la Gare
L-1611 Luxembourg
Luxembourg
L-1611 Luxembourg
Luxembourg