Teach yourself Microsoft Excel Math Function: RANK.AVG()

Teach yourself how to use Excel / Google Sheet function mini-series: RANK.AVG().

This simple and useful function is great to quickly find the top or bottom item by their values. With conditional formatting and sorting, you can create a quick report in minutes.

Download the Excel spreadsheet:

More Videos

Chapters
00:00 Intro
00:00 Download the excel spreadsheet
00:25 RANK.AVG()
01:03 Conditional Formatting
02:07 Sort & Filter
02:43 Check answer

Subscribe

#Excel
#function
#learnyourself
#exercise
#training
#Microsoft
#tutorials #tutorial
#microsoftexcel #rank
#learn #test
#excel2016 #excel2019