Excel 365 Pro Plus - Advanced

Inter-company training

Who is the training for?

This course is addressed to good basic users, who wish to learn Excel furthermore in fields such as accountability, finances or science.

Duration

14,00 hours(s)

Language(s) of service

EN

Next session

29.06.2023
Location
Luxembourg

Price

490,00€

Goals

After the training the participant shall be able to:

  • use the advanced spreadsheet functionalities

Contents

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

Certificate, diploma

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

Next session

Datum
City
Language and price
29.06.2023

30.06.2023
Luxembourg
EN 490,00€
24.08.2023

25.08.2023
Luxembourg
EN 490,00€
25.09.2023

26.09.2023
Luxembourg
EN 490,00€

These courses might interest you