Nice things you can do with Excel

Excel can be a very useful tool with few tricks.
Here is a collection of some of them:

1. ALT + Enter - to go on second line inside a cell.

2. View -> Freeze Panes -> Freeze top Row.

3. =IF(logical_test,[value_if_true],[value_if_false]) - to display a result if the logical_test is true or false.

4. =SUMIF(range,criteria,[sum_range]) - to add elements in a range that match given criteria.

5. =COUNTIF(range,criteria) - to count elements in a range that match given criteria.


6. =COUNT(value1,[value2],...) - to count the number of cells in a range that contain numbers.


7. =COUNTBLANK(range) - to count number of blank cells in a range.

8. =COUNTA(value1,[value2],...) - to count the number of cells in a range that are not empty.

9. =OR(logical1,[logical2],...) - logic OR. Same for AND and NOT.

10. =SUM(number1,[number2],..) - to add numbers

11. =CONCATENATE(text1,[text2],...) - to concatenate strings

12. =VALUE(text) - to convert text to numbers

13. =TRIM(text) - to remove all spaces from a string

14. =ROUND(number,num_digits) - to round a number with specified number of digits.

15. =INT(number) - to round a number to the closest integer.

16. =RANDBETWEEN(top,bottom) - generates random number in given range.

17. =ISBLANK(value) - returns True if blank and False otherwise.

18. =CONVERT(number,from_unit,to_unit) - used to convert from a unit to another.

19. Home -> Conditional Formating.

Have fun :)