Staff Skills academy+
Home » Courses » Microsoft Excel Intermediate Certification » Module 10 : AVERAGEA Function
Module 10 : AVERAGEA Function
10.1 AVERAGEA Function AVERAGEA is very similar to the AVERAGE function, in that it returns the arithmetic mean, or average, of a list of numbers. The formula is the following: =AVERAGEA(value1, value2,…) The difference between the AVERAGEA and the AVERAGE formula is that: logical values, within arrays or reference arguments are counted, and text is counted as zero. 10.2 Video Instruction How to use the AVERAGEA Function in Excel – 2m 26s 10.3 Task Estima...
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
