After the training the participant shall be able to:
- use the advanced spreadsheet functionalities.
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)
Apply a predefined conditional formatting
Customize a conditional formatting
Use functions: SumIf, CountIf, Vlookup, If, And, Or, Match ….
Create a data table (Insert Table)
Create formulas using references of a Data table
Filter data: advanced filters
Use automatic totals (Subtotals)
Recommended Pivot Tables
Cross data into a table (PivotTable) or a graph (PivotChart)
Achieve a target value (Goal seek)
Evaluate a formula
This course is addressed to good basic users, who wish to learn Excel furthermore in fields such as accountability, finances or science.
The training material will be handed out at the beginning of the course.
By the end of the training, the trainee will receive a certificate of participation issued by the House of Training.