Excel - MAXIFS & MINIFS Video

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
2801 views

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.

DiLeaP AI: THIS MIGHT BE HELPFUL

Excel - Determine minimums and maximums

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 search your documents stored across your online storage services and run an online search in the Microsoft Bing search engine.
This will help you gain time and efficiency in your searches, making it easier to find the information you need in your Microsoft 365 account.

1:48
495 views

Excel - Determine minimums and maximums based on criteria

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 search your documents stored across online storage services and run an online search in the Microsoft Bing search engine.
This powerful tool helps you gain time and efficiency in your searches, making it easier to access your most recently used documents.
This will help you improve your productivity and find information quickly in the Microsoft 365 environment.

1:31
523 views

Excel - Find the most present value in a series

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 search your documents stored across online storage services and run an online search in the Microsoft Bing search engine.
This powerful tool helps you gain time and efficiency in your searches, making it easier to find the most present value in a series.

0:46
398 views

Excel - Calculate a median

In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including how to search for documents, emails, notes, and people.
It also demonstrates how to save time while searching and how to access your most recently used documents.
This will help you gain efficiency and save time in your searches using Microsoft's intelligent search tool.

1:30
401 views

Excel - Nested IF functions

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 the information you need quickly and easily in the Microsoft 365 environment.

3:30
3062 views

RELATED COURSES This video is part of the following courses

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 pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

1763 Views

ALL COURSES