Use Excel In Professional way Part -3 By T2T

Опубликовано: 13 Март 2022
на канале: TOP 2 TIP YOUTUBE CHANNEL
604
219

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")