EXCEL IS THE PART OF MISCROSOFT WORD IN WHICH ANYLIZE
YOUR DATA,DATA PROCESSING.
HOW TO OPEN EXCEL
START BUTTON PRESS- TYPE EXCEL- THEN ENTER PRESS
EXCEL
FORMULA
FUNCTIONS
FORMATINGS
FORMULA
ADDITION(+)
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A12+A13
THEN ENTER
=SUM(A1:A13)
DOUBLE CLICK ON SUM (AUTO SUM)ON HOME TABE RIGHT
CORNOR….
ALT+==
SUBTRACTION(-)
MULTIPLICATION(*)
SINGLE TYPE
DIVISION
FIND OUT LCM
6,8,4
=LCM(SELECT ALL RANGE)
FIND OUT THE MAXIMUM VALUE FROM THE RECORDS
=MAX(SELECT RANGE)
CREATE DATA
=MIN(SELECT RANGE)
=MODE(SELECT RANGE)
=SQRT(SELECT RANGE ANY ONE) SQUARE FIND
CONVERT NUMBER TO ROMAN NUMBER
10-X
1000-M
=ROMAN(SELECT RANGE)
FIND OUT AVERAGE
=AVERAGE(SELECT RANGE)
TEXT AND
DATEDIF
C:\Users\RITURAJ
KUMAR\Desktop\excel & advance excel\ADD,SUB,MULT,DIV.xlsx
|
CHAR FORMULA USE TO WRITE DOWN IN EXCEL A TO
Z CAPTIAL LETTER AND ALSO SMALL LETTER |
|
|
=CHAR(A1) R-A 65/90
=CHAR(B1) R-a 97/122
|
Emp name |
sales |
|
A |
60 |
|
b |
5 |
|
c |
40 |
|
d |
2 |
|
e |
11 |
|
f |
90 |
|
g |
25 |
|
h |
7 |
Find out the
largest 3rd rank of the emp
=large(b2:b9,3)
Find out the smallest 4th rank of the emp.
=small(b2:b9,4)
Title bar
Menu bar
Ribbon(hide ribbon press( ctrl+1))
Formula bar
How to sheet hide and unhide
How to hide column and unhide column
How to hide row and unhide rows
Ctrl+0
Ctrl+shift+9
Status bar ?
Task bar?
Cell?
Row?
Column?
Gridlines?
Row-10,48,576
Column-16384(a-xfd)
1.Used for see the current row postions
=row()
2.find out the current column postion
=column()
3.used for insert the auto numbering in row waise
|
S no |
|
=rows($a$2:a2) |
4.used for insert the auto numbering in column waise
|
S no |
=columns($B$1:B1) |
5.COUNT THE RECORDS
ANY DATA
|
8 |
|
5 |
|
6 |
|
5 |
|
7 |
|
=COUNT(A1:A10)
6.COUNT THE RECORDS TEXT
|
|
SONU |
ANIL |
MONU |
|
=COUNTA(B1:B5)
7.COUNT THE BLANK AREA FROM THE RECORDS
=COUNTNLANK(A1:A9)
|
|
|
|
|
|
|
|
|
|
8.COUNT THE TEXT LENGTHS
=LEN(A1)
|
RAJ KUMAR |
9.INSERT
CURRENT DATE
CTRL+;
=TODAY()
10.INSERT TIME
CTRL+:
=NOW()
11.DATA VERIFY
=EXACT(A1,B1)-FALSE
=EXACT(A2,B2)-TRUE
D FUNCTION
D SUM,AVEARGE,MAX,MIN,COUNT,PRODUCT
=DSUM(DATABASE,CERTIA,FIELD)
COVERT SMALL TO CAPITAL LETTER
=UPPER(A1)
CONVERT CAPITAL TO SMALL LETTER
=LOWER(B1)
CONVERT ANY TEXT FROM CAPITAL +SMALL TO SENTENCE CASE
=PROPER(A1)
CUSTOM
SUMIF WITH FUNCTIONS
