Excel Introduction

0
131

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

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here