Basic Excel Formulas Guide
Author: Rupak Ghanpathi
1. SUM =SUM(A1:A10)
2. AVERAGE =AVERAGE(B1:B10)
3. IF =IF(C1>50,"Pass","Fail")
4. VLOOKUP =VLOOKUP(101,A2:D20,2,FALSE)
5. CONCATENATE =CONCAT(A1," ",B1)
This cheat sheet helps you master Excel basics quickly.