Microsoft Excel 2021365 - Beginner to Advanced - Ranking Data with Sorting Using RANK.EQ and RANK.AVG

The video tutorial explains how to rank movies based on the number of five-star reviews using Excel. It introduces the RANK function and its arguments, demonstrating how to rank data without altering the original order. The tutorial also covers handling ties in rankings and introduces the RANK.AVG function, which calculates the average rank for tied values. Examples include ranking movies and call logs, illustrating the differences between RANK and RANK.AVG functions.

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF