Advanced Excel: the essential features to be efficient

Inter and intra-company training

Who is the training for?

All audiences.

Level reached

Advanced

Duration

2,00 day(s)

2 days of 6 hours with a break of 1 hour. Timetable to be defined with the students.

Language(s) of service

EN FR

Next session

Prerequisites

No excel base required.
Requires a computer with Microsoft Excel 2016 or Excel 365.

Goals

Have an advanced level in Excel:

  • Master complex formulas
  • Know how to use tables
  • Know Pivot Tables and PivotCharts
  • Work effectively on Excel

Contents

  • Formulas: Sum, Nb, Count, If, Match, Index, SumProduct, combined functions, relative and absolute references
  • Introduction to matrix functions
  • Tables: creation, layout, range names, integration into functions
  • PivotTables
  • Pivot Charts
  • Segments

Points covered

  • Use time-saving tools
  • Build simple and elaborate calculation formulas
  • Use a list of data
  • Set up pivot tables
  • Link and consolidate data

Teaching methods

Practical exercises carried out together step by step with the trainer.
Possibility to adapt the exercises to the client's environment.

Certificate, diploma

Certificate of participation issued at the end of the course.

Mode of organisation

Takes place at the client's premises or by videoconference (Teams or Zoom).

Organization contact details

Frédéric Michotte

These courses might interest you

EN
Day
Excel beginner
On request
Software - Office software - Spreadsheet software - Excel software