Not sure which of these videos to watch? Try out our 'Which Excel Formula to Use' App to get guidance. NOTE: All these free Excel video tutorials are streamed via YouTube. If your network does not allow YouTube videos, you can access the video via your smartphone or from a different network.
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!
Live versus online Excel training What are the pros and cons of live versus online Excel training. Can you really learn how to use Excel online, or do you have to attend a live course. And if you need to … Continue reading
New Online Data Cleanup Course, Repair Corrupt Files, tables slowing Excel down, Excel and BI In this issue: Next Advanced Excel course dates 12-16 Oct, 9-13 Nov Beginner Excel Course Dates- Next 12 Feb 2016 Data Cleanup online Course In … Continue reading
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd