Staff Skills academy+
Home » Courses » Microsoft Excel Intermediate Certification » Module 16: MEDIAN Function
Module 16: MEDIAN Function
16.1 MEDIAN Function The MEDIAN function returns the median number of a set of numbers. The formula for the MEDIAN function is as follows: =MEDIAN(number1, number 2,…) Here, number 1 is required but any additional numbers are optional. Ranges of data can also be included. Keep in mind that the data the cells are referring to could include names, arrays, or references that contain numbers. If an argument doesn’t have any numbers, the MEDIAN function will return 0. There is a maximum...
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
