Not sure which Excel course you should do? Try out our free Which Excel Course Should you do" questionnaire. 20 questions and you will know exactly what course you should do!
How to use the Excel Maximum and Minimum functions to find the maximum or minimum of a range
In this segment you will learn how to find and activate the Excel Maximum and Minimum functions, and how to use the functions to limit a cells content to a maximum or minimum amount.
In this example we have a list of Players and four Scores for each player. We have the Average, what we’d like to do is automatically work out what the maximum score is and the minimum score for each player. To do this
In order to determine the minimum number,
We can now copy these formulas all the way across, and quickly work out what each players average maximum and minimum score was.
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
A common requirement from Excel users is to merge multiple csv files into a single file for use in Excel. In this post we show a very effective way that makes use of the old DOS (you may not even … Continue reading
Excel users typically like to colour cells to highlight certain items. The problem is once you have all the cells highlighted, you will inevitably need to count or add them. There is currently no SUMIF, COUNTIF, AVERAGEIF that works on … Continue reading
It was most interesting and filled with very useful and relevant tricks and tools that one can start to use immediately. The course was well constructed with a logical flow to be able to reference information easily in the take home materials, with exercises covering many different scenarios.– Hyatt Hotels