Get a quote
FREN
Get a quote

Trainings

Optimizing the digital workspace

Collaboration, communication and project planning

Productivity and professional performance

Any particular software?

Training path

Services

Optimizing the digital workspace

Collaboration, communication and project planning

Productivity and professional performance

Any particular software?

FREN

Discover all the Possibilities offered by Excel Built-In Functions

Live trainer | Practical exercises | Small-group learning

6 hours

Advanced

English - French

250$ per person
Would you like to train your teams? Contact us for a quote

New skills!

This training will take you further in your knowledge of complex and nested functions. You will learn calculation functions for basic statistics, but also more complex functions. Equally important, you'll also learn how to find a specific value from another table and save valuable time.
Download the lesson plan

Objectives and prerequisites

-

With this training, you will be able to:

  • Calculate statistics (IF, AND, OR, SUMIF, AVERAGEIFS…) 
  • Create and modify complex and nested functions
  • Merge values from multiple cells into one
  • Search for a value in another table according to a criterion (VLOOKUP, XLOOKUP, etc.)

Training plan

+

Included with your course

+

How to buy our courses?

Discover our different options to meet all your training needs.

Independent registration

Register directly for your training courses on our training platform. Take advantage of our wide choice of scheduled dates.

Register for training

License purchase

Distribute training licenses to your teams to register for the dates available on our training platform.

Ask for a quote

Private group

Plan exclusive dates for members of your company, and benefit from our turnkey support.

Ask for a quote

Satisfied or your money back!
Test our training courses without fear, we guarantee your satisfaction.

If you have any questions about registration, cancellations, training courses or any other information, you’ll find the answers in our FAQ.

Contact our team

Our clients testify

What could be better than the opinion of our participants who have experienced our courses.

  • “

    J'ai vraiment apprécié la facilité du formateur de rendre facile à comprendre la matière, mais aussi les trucs/raccourcis que je ne connaissais pas, ou la notion d'insérer des formules dans des formules, etc.

    Participant anonyme au cours EXE-301

    See more testimonials

Want to learn more about Excel ?

Sign up for our newsletter.
Every month we share with you a tip about your favourite software..