Learn Excel

Learn Excel

                             By- Nitin Pal Singh

                     (Engineer in Electronics & Communication)

                                                                                  Index

1		Use of AND	35		Use Of DMAX
2		Use of ABS	36		Use Of DMIN
3		Use Of AVERAGE	37		Use Of DOLLAR
4		Use ofAuto Sum	38		Use Of DSUM
5		Change Binary to Decimal	39		Use Of EDATE
6		Use Of Braces in Formula	40		Use Of EOMONTH
7		Use of CEILING	41		Use Of EVEN
8		Use Of Cell	42		Use Of EXACT
9		Use Of Char	43		Use Of FACT
10		USE Of Choose	44		Use Of FILENAME
11		Use Of Clean	45		Use Of FIND
12		Use Of Code	46		Use Of FIXED
13		Use Of Combin	47		Use Of EOMONTH
14		Use Of Concatenate	48		Use Of FORECAST
15		Use Of Convert	49		Use Of FREQUENCY
16		Use Of Correl	50		Use Of GCD
17		Use Of Count	51		Use Of GESTEP
18		Use Of Counta	52		Use Of HEX2DEC
19		Use Of Countblank	53		Use Of HLOOKUP
20		Use Of Count-if	54		Use Of HOUR
21		Use Of Date	55		Use Of HOURUse Of HOUR
22		Use Of Datedif	56		Use Of IF
23		Use Of Datevalue	57		Use Of INDEX
24		Use Of Daverage	58		Use Of INDIRECT
25		Use Of Day	59		Use Of info
26		Use Of Day360	60		Use Of Instant Chart
27		Use Of Datedif	61		Use Of INT
28		Use Of DB	62		Use Of ISBLANK
29		Use Of Dcount	63		Use Of ISBLANK
30		Use Of Dcounta	64		Use Of ISERR
31		Use Of Dec2Bin	65		Use Of ISERROR
32		Use Of Dec2Hex	66		Use Of ISEVEN
33		Use Of Delta	67		Use Of ISLOGICAL
34		Use Of DGET