Excel 2013, 2016, 2019 - Advanced

After the training the participant shall be able to:

• use the advanced spreadsheet functionalities.

• 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, CountIf, Vlookup, If, And, Or, Match ….
• 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
• Consolidate Data

By the end of the training, the trainee will receive a certificate of participation issued by the House of Training.