Excel - MAXIFS & MINIFS Tutorial

In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers how to find documents, images, videos, people, and conversations using the search bar located at the top of your Microsoft Office apps.
It also demonstrates how to access your most recently used documents and run an online search in the Microsoft Bing search engine.
This powerful tool helps you search your documents stored across your online storage services and gain time and efficiency in your searches.
This will help you improve your productivity and find everything you need in your Microsoft 365 account.

1:06
3014 views

Available in Microsoft365

00:00:13

MINIFS returns to the minimum value.

00:00:16

Here we would like to know the highest years of service according to qualification and division.

00:00:23

With the MAXIFS function…

00:00:30

The range being the years of experience.

00:00:36

The first criterion: Qualification,

00:00:43

Defined here.

00:00:47

Second criterion: Division,

00:00:53

Defined here.

00:01:00

Same procedure for the MINIFS function which returns the minimum value.

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

1947 Views

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivo...

ALL COURSES