Next Live Training Date:

12-16 May 2014

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.

Excel Maximum and Minimum

Excel Maximum and Minimum
Watch this video

How to use the Excel Maximum and Minimum functions to find the maximum or minimum of a range

  • 1:26
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

Excel Maximum and Minimum formula

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.

Handy Tips & Tricks

Format painter graph excel

Format painter graph excel A useful trick when using Excel charts or graphs is a format painter graph. Excel allows you to use the format painter on cells by simply clicking on the icon. For graphs it is slightly different. … Continue reading

How to work on two different excel worksheets at once

How to work on two different excel worksheets at once A common requirement is how to work on two different excel worksheets at once. The wording is important. It is not two different SPREADSHEETS, but rather two (or more) worksheets … Continue reading

“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”

– Absa Capital

Video Library & Tutorials //

View Entire Video Gallery ››

Solver Excel 2013

Solver Excel 2013

Offset Excel 2013

Offset Excel 2013

Vlookup Approximate Match

Vlookup Approximate Match

Vlookup Exact Match

Vlookup Exact Match

Some of our Featured Clients