Events

Excel 365 Pro Plus advanced

440 €

at 1.1 KM
Keyjob Follow

Training
Business
Career
Internet
Information
Data
Digital
IT

mon. 13 Jul.

tue. 14 Jul.

thu. 16 Jul.

fri. 17 Jul.

mon. 3 Aug.

tue. 4 Aug.

mon. 7 Sep.

tue. 8 Sep.

mon. 14 Sep.

tue. 15 Sep.

tue. 29 Sep.

wed. 30 Sep.

Goals
Being able to use the advanced spreadsheet functionalities.

Prerequisite
Basic Excel skills.

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