Learning Excel Function

Excel Functions List
- New Functions
  - XLOOKUP
- LOGICAL
  - AND
  - IF
  - IFERROR
  - NOT
  - OR
  - XOR
- LOOKUP & REFERENCE
  - False
  - True
  - ADDRESS
  - AREAS
  - CHOOSE
  - COLUMN
  - COLUMNS
  - HLOOKUP
  - HYPERLINK
  - INDEX
  - INDIRECT
  - LOOKUP
  - MATCH
  - OFFSET
  - ROW
  - ROWS
  - TRANSPOSE
  - VLOOKUP
- DATE & TIME
  - DATE
  - DATEDIF
  - DATEVALUE
  - DAY
  - DAYS
  - DAYS360
  - EDATE
  - EOMONTH
  - HOUR
  - MINUTE
  - MONTH
  - NETWORKDAYS
  - NETWORKDAYS.INTL
  - NOW
  - SECOND
  - TIME
  - TIMEVALUE
  - TODAY
  - WEEKDAY
  - WEEKNUM
  - WORKDAY
  - WORKDAY.INTL
  - YEAR
  - YEARFRAC
- ENGINEERING
  - CONVERT
- FINANCIAL
  - FV
  - PV
  - NPER
  - PMT
  - RATE
  - NPV
  - IRR
  - XIRR
  - PRICE
  - YIELD
  - INTRATE
- INFORMATION
  - CELL
  - ERROR.TYPE
  - ISBLANK
  - ISERR
  - ISERROR
  - ISEVEN
  - ISFORMULA
  - ISLOGICAL
  - ISNA
  - ISNONTEXT
  - ISNUMBER
  - ISODD
  - ISREF
  - ISTEXT
  - N
  - NA
  - TYPE
- MATH
  - ABS
  - AGGREGATE
  - CEILING
  - COS
  - DEGREES
  - DSUM
  - EVEN
  - EXP
  - FACT
  - FLOOR
  - GCD
  - INT
  - LCM
  - LN
  - LOG
  - LOG10
  - MOD
  - MROUND
  - ODD
  - PI
  - POWER
  - PRODUCT
  - QUOTIENT
  - RADIANS
  - RAND
  - RANDBETWEEN
  - ROUND
  - ROUNDDOWN
  - ROUNDUP
  - SIGN
  - SIN
  - SQRT
  - SUBTOTAL
  - SUM
  - SUMIF
  - SUMIFS
  - SUMPRODUCT
  - TAN
  - TRUNC
- STATS
  - AVERAGE
  - AVERAGEA
  - AVERAGEIF
  - AVERAGEIFS
  - CORREL
  - COUNT
  - COUNTA
  - COUNTBLANK
  - COUNTIF
  - COUNTIFS
  - FORECAST
  - FREQUENCY
  - GROWTH
  - INTERCEPT
  - LARGE
  - LINEST
  - MAX
  - MEDIAN
  - MIN
  - MODE
  - PERCENTILE
  - PERCENTILE.INC
  - PERCENTILE.EXC
  - QUARTILE
  - QUARTILE.INC
  - QUARTILE.EXC
  - RANK
  - RANK.AVG
  - RANK.EQ
  - SLOPE
  - SMALL
  - STDEV
  - STDEV.P
  - STDEV.S
  - STDEVP
  - TREND
- TEXT
  - CHAR
  - CLEAN
  - CODE
  - CONCATENATE
  - DOLLAR
  - EXACT
  - FIND
  - LEFT
  - LEN
  - LOWER
  - MID
  - PROPER
  - REPLACE
  - REPT
  - RIGHT
  - SEARCH
  - SUBSTITUTE
  - TEXT
  - TRIM
  - UPPER
  - VALUE