In collaboration with:
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
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
L-1611 Luxembourg
Luxembourg