Excel 365 Pro Plus - Advanced

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