Excel 2019/365 - Level 2

Inter-company training

Duration

 2,00 day(s)

Language(s) of service

EN FR

Next session

 11.06.2026
Location
 Capellen

Price

900,00€

Who is organizing this training?

We enhance both individual development and efficiency by sharing the IT expertise and managerial experience of our instructors. We offer over 300 courses in French and English at our center in Capellen. These courses focus on infrastructure, development, project management, governance, and soft skills.

Who is the training for?

Users with a solid foundation in Excel who wish to go further in data analysis.

Prerequisites

Be familiar with Excel’s basic features (formulas, functions, sorting and filtering).

Goals

Deepen advanced calculation and analysis functionalities.

Contents

NEW FEATURES OF EXCEL 2019 COVERED IN THIS TRAINING

  • New functions: CONCAT, TEXTJOIN, XLOOKUP
  • Improved precision selection and enhanced semi-automatic data entry
  • New features in PivotTables
  • Introduction to Power Query
  • DIFFERENCES BETWEEN Excel WEB APP and Excel DESKTOP APP
  • Signing in to the Office 365 portal
  • Choosing the right storage drive for workbooks
  • Traditional: file server or local hard drive
  • 365: Personal OneDrive / Shared OneDrive / SharePoint-Teams
  • Version history
  • Collaboration: working together on the same workbook

REVIEW OF TIPS & TRICKS TO OPTIMIZE CALCULATION OPERATIONS

  • Mastering cell referencing principles (relative, absolute & mixed references)
  • Entering functions in text mode (including text in functions, using comparison criteria, working with named ranges, etc.)
  • Nesting functions

HANDLING FUNCTION CATEGORIES

  • Working with Statistical functions (AVERAGE, MAX, MEDIAN, etc.)
  • Working with Logical functions (COUNTIF, SUMIF, IF, AND, OR, etc.)
  • Text functions (LEFT, FIND, UPPER, CONCATENATE, etc.)
  • Date and Time functions (DATEDIF, NOW, TODAY, YEAR, MONTH, DAY, etc.)
  • Array functions: VLOOKUP + XLOOKUP
  • Performing calculations using named cell ranges

INTRODUCTION TO DATABASE CONCEPTS

  • Mastering database-specific vocabulary
  • Learning how to design a database file that enables efficient data analysis
  • Managing custom toolbars for data analysis
  • Tips to maintain data integrity
  • Using the Table tool

REVIEW OF BASIC ANALYSIS TOOLS

  • Mastering simple sorting concepts, sort keys, and hierarchical sorting
  • Mastering simple filtering concepts
  • Using outline mode to improve data readability

AUTOMATING DATABASE CONTENT

  • Data validation using lists
  • Using simple and formula-based conditional formatting
  • Creating visuals with Sparkline charts
  • Slicers
  • Automatic fill (FLASH FIELD)

ANALYZING DATA WITH PIVOTTABLES & POWER PIVOT

  • Mastering the fundamental concepts required to design PivotTables
  • Using built-in calculation functions (average, count, max, min, etc.)
  • Displaying subtotals
  • Refreshing data
  • Grouping items (manual and automatic)
  • Consolidating data from multiple tables
  • New features [365]
  • Automatic relationship detection
  • Automatic time grouping

INTRODUCTION TO POWER QUERY

  • Switching between Excel and Power Query
  • Importing data from various sources into Power Query (Excel, CSV, text)
  • Data transformation operations:
  • Managing columns and rows to keep
  • Renaming headers
  • Sorting and filtering
  • Adapting data types to analysis needs (including automatic detection)
  • Creating a header row

PRACTICAL HANDS-ON EXERCISES + TIPS & TRICKS

Points covered

  • Advanced calculation functions
  • Complex data analysis
  • PivotTables
  • Introduction to Power Pivot
  • Introduction to Power Query (data preparation and transformation)

This level strengthens analytical and automation capabilities, particularly when working with larger volumes of data.

Next session

Datum
City
Language and price
11.06.2026

12.06.2026
Capellen
EN 900,00€
11.06.2026

12.06.2026
Capellen
FR 900,00€
13.08.2026

14.08.2026
Capellen
EN 900,00€
13.08.2026

14.08.2026
Capellen
FR 900,00€
08.10.2026

09.10.2026
Capellen
EN 900,00€
08.10.2026

09.10.2026
Capellen
FR 900,00€
03.12.2026

04.12.2026
Capellen
EN 900,00€
03.12.2026

04.12.2026
Capellen
FR 900,00€

Mode of organisation

Classroom Courses

These courses might interest you

EN
Day
Software - Graphic software - Image treatment software
EN
Day
On request
Software - Office software - Computer-aided presentation software
EN
Day
On request
Software - Office software