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
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 and schedules
Would you like to stay up to date on our training offer?
Subscribe to our newsletter