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

25 Basic Excel Formulas

S.NO.	QUESTIONS	ANSWERS
1	How to sum a range of cells	Sum (Range)
2	How to find an average of number	Average (Range)
3	How to find the maximum value in a range	Max (Range)
4	How to find the minimum value in a range	Min (Range)
5	How to link cells from different sheets	“Sheet name”! Cell Reference
6	How to concatenate two text cells	Concatenate (Cell1,Cell2,Cell3)
7	How to sum if cells meet a condition	Sumif(Range, Criteria, {Sum Range})
8	How to use index to retrieve a value	Index (Range, Row, Num)
9	How to round a number to nearest integer	Round (Cell,0)
10	How to extract left part of a text string	Left (Text, Num, Char)
11	How to extract right part of a text string	Right (Text, Num, Char)
12	How to use a VLOOKUP Function	VLOOKUP (lookup, Value, Table, Col, Index, {True/False})
13	How to use a HLOOKUP Function	HLOOKUP (lookup, Value, Table, Row, Index, {True/False})
14	How to calculate the Square Root	Sqrt (Number)
15	How to generate a random number	Rand ()
16	How to count cells with Numerical date	Count (Range)
17	How to count cells with any date	Count (Range)
18	How to find the current date	Today ()
19	How to add days to a date	Date_Cell+Days
20	How to calculate the percentage change	(New_Value-Old_Value/Old Value)
21	How to check if a cell is empty	Isblank(Cell)
22	How to return the absolute value	Abs (Number)
23	How to check if a condition is true	If (Condition,True_Value,False_Value)
24	How to sum only visible cells	Subtotal (109, Range)
25	How to sum only visible & invisible cells	Subtotal (9, Range)

50 Excel Shortcuts You Need to Know

Shortcut	Action	Shortcut	Action
Shift + Space	Select Entire Row	Ctrl + F	find
Ctrl + Space	Select Entire Column	Ctrl + H	Replace
Ctrl + Shift ++	Insert New Row	Ctrl + A	Select Entire Worksheet
Ctrl + -	Delete Selected Row/Column	Ctrl + =	Sum Selected Range
Ctrl + Z	Undo The Last Action	Ctrl + Shift + &	Add Border
Ctrl + Y	Redo the Last Action	Ctrl + 1	Open Format Cell Dialog
Ctrl +S	Save Workbook	Alt + W + F + F	Freeze Panes
Ctrl +O	Open Workbook	Ctrl + G	Open Go to  dialog
Ctrl + N	Create New Workbook	Ctrl + F3	Open Name Manager
Ctrl + W	Close Workbook	Ctrl + Shift + L	Add Filter
Ctrl + C	Copy	Shift + F2	Insert Comment
Ctrl + V	Paste	Shift + F10 + M	Insert/Delete Comment
Ctrl + X	Cut	Ctrl + P	Open Print Dialog
Ctrl + B	Bold Text	Alt + F1	Create Chart
Ctrl + I	Italicize Text	Shift + F3	Insert Function
Ctrl + U	Underline Text	Alt + Enter	Add New Line In Cell
Ctrl + ;	Insert Current Date	F7	Spell Check
Ctrl +Shift + ;	Insert Current Time	Alt + F5	Refresh Data in Pivot Table
Alt + H + O +I	Auto Fit Column Width	Alt + H + B + A	Apply Border
Ctrl +0	Hide Column	Alt + H + M + C	Merge & Center
Ctrl + 9	Hide Row	Alt + F4	To Close Excel
Ctrl + `	Display All Formulas	Ctrl + K	To Insert a Hyperlink
Ctrl + T	Create Table	F2	To Edit a Cell
Ctrl + Page Down	Move to next Worksheet Tab	Ctrl + Shift + Left Arrow	To Select all the cells on the Left
Ctrl + Page Up	Move to Previous Worksheet Tab	Ctrl + Shift + Right Arrow	To Select all the cells on the Right

follow for more update