In collaboration with:
Description
Objectives
After the training the participant shall 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
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
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 participation issued by the House of Training.
Location
L-1611 Luxembourg
Luxembourg