Microsoft Excel 2021365 - Beginner to Advanced - Using LARGE and SMALL

This video tutorial explains how to find the largest and smallest values in a dataset using Excel functions. It covers the use of MAX, MIN, LARGE, and SMALL functions to identify top and bottom sales figures. The tutorial also demonstrates advanced techniques using MAXIFS and MINIFS to filter data by specific criteria, such as genre. The video provides step-by-step instructions on applying these functions, locking cell references, and formatting results for clarity.

What functions can be used to find the 2nd, 3rd, 4th, and 5th largest values in a range of data?

How do you use the LARGE function to return the second largest value?

What is the purpose of locking the table range when using the LARGE function?

Explain how to find the highest sales in the pop genre using the MAXIFS function.

What criteria must be specified when using the MINIFS function to find the lowest sales in a specific genre?

Describe the process of using the SMALL function to find the second lowest sales value.

How can you modify the formatting of sales data after calculating the largest or smallest values?