Introduction to Excel

Ctrl Shift Down Arrow - to get all number in a column

Copy, Paste, Value Paste - paste numbers without changing their values

Excel Functions:

=SUM: returns the sum of the cells or range selected
=MAX: returns the largest number in a given set of values
=MIN: returns the smallest number in a given set of values
=AVERAGE: returns the average value of the given numbers
=SUMPRODUCT: returns the sum after multiplying numbers in an array.
=RAND(): returns random number greater than 0 and less than 1.
=RANDBETWEEN(#lowest, #highest): return random number between specified numbers.
=TRIM: remove spaces all before and following the words, but does not remove the single space between words.
=CONCATENATE: joins several (more than 1) text strings into 1 string
- Ex: =CONCATENATE(A2,” has scored “,B2,” in “, $B$1”, “.”)
=Left,right and mid: returns the number of specified characters from the start/end of the string.
=MID: returns the number of specified characters from the specified point.
- =MID(A2,5,5)
- =LEN(A8)
- # of characters
- =MID(A8,5,LEN(A8),-6)

And OR

=AND - checks if all arguments are true and returns True value else returns FALSE value
=OR - checks if any of the conditions are true or not and returns TRUE value else returns FALSE value
=IF - checks whether a condition is true or not and on the basis of that returns a value
=COUNTIF - returns the count of number of cells which consist of numbers and meet a given condition
=SUMIF - returns the sum of the cells which meet a given criteria