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.
Do I have PowerPivot? This is a surprisingly difficult question to answer. Due to the way it has been rolled out you may or may not already have it, and even if you download it (Excel 2010) you may or … Continue reading
Fast financial modeling help If you are a regular builder of financial models you may be feeling that you require fast financial modeling help as the year end approaches. We have two options available to clients who need immediate help with … Continue reading
... I have always found them to be very adaptable to the various clients we send them to and they are able to solve the most complex of modelling problems...– Investment property spreadsheets- Old Mutual