Staff Skills academy+
Home » Courses » Microsoft Excel Intermediate Certification » Module 13 : CELL Function With 10 Variations
Module 13 : CELL Function With 10 Variations
13.1 CELL Function The CELL function is an informative formula that tells you about the contents, location, formatting, and properties of a specific cell. The formula for CELL is:=CELL(“what you want to find out about the cell”, cell location) The variations of this formula include the following: =CELL(“address”, cell location), to find the location of the cell =CELL(“col”, cell location), to find the column number. =CELL(“row”, cell location), to find the row number =CELL(“ty...
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
