Basic Microsoft Excel Formulas/ 25 Basic Excel Formulas/ 50 Excel Shortcuts You Need To You

Basic Microsoft Excel Formulas/ 25 Basic Excel Formulas/ 50 Excel Shortcuts You Need to You 

50 Excel Shortcuts /25 Basic Excel Formulas

Basic Microsoft Excel Formulas

S.NO.	FORMULA NAME	FORMULA PATTERN
1	SUM	=SUM(A1:A5)
2	SUM	=(A1+A2+A3+A4+A5)
3	SUM	=(45+4+44+48)
4	PRODUCT	=PRODUCT (F1:F2)
5	PRODUCT	=(B3*B4*B5)
6	PRODUCT	=(34*56)
7	SUBTRACT/MIN IS	=(E3-E4)
8	DIVIDE	=(F3/F4)
9	PERCENTAGE	=(G3/G4*100)
10	MAXIMUM	=MAX(H3:M3)
11	MINIMUM	=MIN(H3:M3)
12	POWER	=POWER(2,4)[24=26]
13	AVERAGE	=AVERAGE(C3:C14)
14	SQUARE ROOT	=SQRT(25)
15	COUNT	=COUNT(C4:P4)
16	COUNT BLANK	=COUNTBLANK(C3:C16)
17	COUNT IF	=COUNTIF(D4:Z4,”P”)
18	CURRENT DATE & TIME	=NOW()
19	TODAYS DATE	=TODAY()
20	DAY# OF CURRENT MONTH	=DAY(NOW())
21	CURRENT MONTH	=MONTH(NOW())
22	CURRENT YEAR	=YEAR(NOW))