Excel 365 - Advanced

Basic Excel skills

After the training the participant will 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

• 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

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