11. Use dollar signs to keep one cell's formula the same regardless of where it moves.
12. Use the VLOOKUP function to pull data from one area of a sheet to another.
13. Use drop down list in excel
14. Use INDEX and MATCH formulas to pull data from horizontal columns.
15. Use the COUNTIF function to make Excel count words or numbers in any range of cells.
= COUNTIF($B$2:$B$51,"ali akbar")