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.
Accessing the task manager from excel A nice shortcut from @TomUrtis shows a quick way to get access the Task Manager from Excel. Normally trying to access the Task Manager is a bad sign in Excel, and in fact you can’t do anything … Continue reading
Excel Quiz Answers Answers for the quiz on our 11 Dec 2014 Newsletter. To subscribe to the newsletter visit the subscribe page. Excel Questions 1) The biggest risk with linking spreadsheets together is a. Rows and columns are added/ deleted when … Continue reading
AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.– Sasol Polymers