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.
Copy excel cell without changing formula Occasionally you may want to override Excel’s natural temptation to adjust cell references when you copy and paste, and just copy the existing formula as they are, with no changes to where they refer … Continue reading
CPD Courses Based on our presentation to CPD Courses – Gauteng (see photos on Google+ or Facebook), below are the links to the appropriate video clips and downloads mentioned during the presentations, and the additional material provided. If you want … Continue reading
We have used AuditExcel over the last 5 years to develop large scale property modelling developments. All the templates are still in use and allow for intricate sensitivity analysis. As a result we are better able to assess projects and choose the optimal ones. Their response times also make it easy to rely on them for new developments.– Property Modelling- Basil Read