Excel Learning PDFs

Learn Excel Functions with examples, Free download in PDF File Formats

234 Excel Functions PDF for Free Download

Excel Functions Templates

  • Date - Time Functions

    DATEVALUE
    DAY
    DAYS
    DAYS360
    EDATE
    EOMONTH
    FORMAT Dates
    HOUR
    ISOWEEKNUM
    MINUTE
    MONTH
    MONTHNAME
    NETWORKDAYS
    NETWORKDAYS.INTL
    NOW
    SECOND
    TIME
    TIMESERIAL
    TIMEVALUE
    TODAY
    WEEKDAY
    WEEKDAYNAME
    WEEKNUM
    WORKDAY
    WORKDAY.INTL
    YEAR
    YEARFRAC
    DATE
    DATE
    DATEADD
    DATEDIF
    DATEDIFF
    DATEPART
    DATESERIAL

  • Logical Functions

    AND
    AND
    FALSE
    FOR NEXT
    IF
    IF-THEN-ELSE
    IFERROR
    IFNA
    IFS
    Nested IF
    Nested more than 7 IF
    NOT
    OR
    OR
    SWITCH
    SWITCH
    TRUE
    WHILE WEND
    CASE

  • Lookup - Ref Functions

    COLUMN
    INDEX
    INDIRECT
    LOOKUP
    MATCH
    OFFSET
    ROW
    ROWS
    TRANSPOSE
    VLOOKUP
    XLOOKUP
    COLUMNS
    HLOOKUP
    HYPERLINK
    AREAS
    CHOOSE
    ADDRESS

  • Math - Trig Functions

    ACOS
    ACOSH
    AGGREGATE
    ASIN
    ASINH
    ATAN
    ATAN2
    ATANH
    ATN
    ABS
    CEILING
    CEILING.PRECISE
    COMBIN
    COMBINA
    COS
    COSH
    DEGREES
    EVEN
    EXP
    FACT
    FIX
    FLOOR
    FORMAT Numbers
    INT
    LN
    LOG
    LOG
    LOG10
    MDETERM
    MINVERSE
    MMULT
    MOD
    MOD
    ODD
    PI
    POWER
    PRODUCT
    RADIANS
    RAND
    RANDBETWEEN
    RANDOMIZE
    RND
    ROMAN
    ROUND
    ROUND
    ROUNDDOWN
    ROUNDUP
    SGN
    SIGN
    SIN
    SINH
    SQR
    SQRT
    SUBTOTAL
    SUM
    SUMIF
    SUMIFS
    SUMPRODUCT
    SUMSQ
    SUMX2MY2
    SUMX2PY2
    SUMXMY2
    TAN
    TANH
    TRUNC

  • Statistical Functions

    BETA.DIST
    BETA.INV
    BETADIST
    BETAINV
    BINOM.DIST
    BINOM.INV
    BINOMDIST
    CHIDIST
    CHIINV
    CHITEST
    COUNT
    COUNTA
    COUNTBLANK
    COUNTIF
    COUNTIFS
    COVAR
    FORECAST
    FREQUENCY
    GROWTH
    INTERCEPT
    LARGE
    LINEST
    MAX
    MAXA
    MAXIFS
    MEDIAN
    MIN
    MINA
    MINIFS
    MODE
    MODE.MULT
    MODE.SNGL
    PERCENTILE
    PERCENTRANK
    PERMUT
    QUARTILE
    RANK
    SLOPE
    SMALL
    STDEV
    STDEVA
    STDEVP
    STDEVPA
    VAR
    VARA
    VARP
    VARPA
    AERAGE
    AVEDEV
    AVERAGEA
    AVERAGEIF
    AVERAGEIFS

  • String - Text Functions

    BAHTTEXT
    ASC
    CHAR
    CHR
    CLEAN
    CODE
    CONCAT
    FIXED
    DOLLAR
    FIND
    EXACT
    FORMAT
    INSTRREV
    INSTR
    LCASE
    LEFT
    LEN
    LOWER
    LTRIM
    RIGHT
    MID
    NUMBERVALUE
    PROPER
    REPLACE
    REPLACE
    REPT
    RTRIM
    SEARCH
    SPACE
    SPLIT
    STR
    STRCOMP
    STRCONV
    STRREVERSE
    SUBSTITUTE
    T
    TEXT
    TEXTJOIN
    TRIM
    UCASE
    UNICHAR
    UNICODE
    UPPER
    VAL
    VALUE
    CONCATENATE