Staff Skills academy+
Home » Courses » Microsoft Excel Intermediate Certification » Module 15: MAX Function
Module 15: MAX Function
15.1 MAX Function The MAX function returns the largest value in a set of values. The formula for the MAX function is as follows: =MAX(number1, number 2,…) Here, number 1 is required but any additional numbers are optional. Ranges of data are also valid. Keep in mind that the data cells are referring to could include names, arrays, or references that contain numbers. If an argument doesn’t have any numbers, the MAX function will return 0. 15.2 Video Instructio...
Lessons
- Module 1: SumProduct Formula
- Module 2 : Data Validation With Date
- Module 3 : Data Validation with Whole Numbers
- Module 4 : Data Validation with List Feature
- Module 5 : ABS Function
- Module 6 : CHAR Function
- Module 7 : CLEAN Function
- Module 8 : CODE Function
- Module 9 : EXACT Function
- Module 10 : AVERAGEA Function
- Module 11 : AVERAGEIF
- Module 12 : AVERAGEIFS Function
- Module 13 : CELL Function With 10 Variations
- Module 14 : LARGE Function
- Module 15: MAX Function
- Module 16: MEDIAN Function
- Module 17: MIN Function
- Module 18: MODE Function
- Module 19 : N Function
- Module 20 : RANDBETWEEN Function (Insert Random Numbers)
- Module 21 : RANK Function
- Module 22 : Remove Duplicate Values
- Module 23 : ROUND Function Up/Down
- Module 24 : Add Custom Background Image
- Module 25: Change Text To Lower Case
- Module 26: Change Text To Upper Case
- Module 27: Change Text To Proper Case
- Module 28: Insert Special Character
- Module 29: Use Autofill : A Time Saving Trick
- Module 30: Treemap Chart
- Module 31: Sunburst Chart
- Module 32: Use Tables
- Module 33: Use Templates
- Module 34: Use Themes
