What is Excel ?
It is a spreadsheet program developed by Microsoft. Excel organizes data in columns and rows and allows you to do mathematical functions
Excel is used in Following
- Analysis
- Data entry
- Data management
- Accounting
- Budgeting
- Data analysis
- Visuals and graphs
- Programming
- Financial modeling
EXCEL FORMULA INDEX
- COUNTIFS:
- FIND
- LEFT
- RIGHT
- TEXTBEFORE
- YEAR
- BYROW
- UNITQUE
- SORT
- LET
- SUMPRODUCT
- COUNTIF
- EXACT
- ISNUMBER
- MATCH
- SUM
- ISNA
- COUNTA
- LEN
- N
- COUNTBLANK
- ISERROR
- ISERR
- ERROR.TYPE
- IFERROR
- REPT
- ISTEXT
- NOT
- SEARCH
- MMULT
- TRANSPOSE
- REDUCE
- COLUMN
- BYCOL
- LAMBDA
- WEEKDAY
- MID
- FREQUENCY
- DROP
- VSTACK
- ABS
- MOD
- CONCAT
- ROW
- OFFSET
- INDEX
- INDIRECT
- IF
- EDATE
- HSTACK
- SCAN
- ISFORMULA
- SUMIF
- AGGREGATE
- SMALL
- FILTER
- SEQUENCE
- TEXT
- MONTH
- EOMONTH
- ROUNDUP
- WEEKNUM
- UNIQUE
- TAKE
- DATE
- TODAY
- LARGE
- SUBTOTAL
- AVERAGEIF
- AVERAGE
- AVERAGEIFS
- LOOKUP
- MIN
- INT
- XLOOKUP
- SORTBY
- RANDARRAY
- CHAR
- SUBSTITUTE
- TRIM
- FILTERXML
- XMATCH
- MAP
- OR
- WORKDAY.INTL
- TEXTAFTER
- MAX
- MEDIAN
- MINIFS
- MAXIFS
- CHOOSECOLS
- NA
- CELL
- ADDRESS
- HLOOKUP
- CHOOSE
- TEXTJOIN
- RANK
- DATEVALUE
- IFNA
- ISBLANK
- FLOOR
- CEILING
- AND
- QUARTILE
- ISEVEN
- ISODD
- UPPER
- TRUNC
- LOG10
- MROUND
- CLEILING
- ROUND
- WORKDAY
- NETWORKDAYS
- DAY
- TIME
- YEARFRAC
- SING
- TIMEVALUE
- DATEIF
- DATEDIF
- ISOWEEKNUM
- IFS
- CODE
- INFO
- VALUE
- TEXTSPLIT
- CLEAN
- REPLACE
- T
- FV
- RATE
- PV
- PRICE
- GEOMEAN
- RRI
- CUMIPMT
- CUMPRINC
- PPMT
- PMT
- NPER
- STOCKHISTORY
- EFFECT
- FIELDVALUE
- NPV
GEOMETRY FORMULA IN EXCEL
-
- PI
- POWER
- SQRT
OTHER EXCEL FORMULA
-
- SHEET
- ISREF
- LOWER
- CONCATENATE
- PROPER
- RANDBETWEEN
- PERCENTILE
