Free Excel Course: Beginner to Expert (525 Functions)

📊

← All courses

Free Excel Course: Beginner to Expert (525 Functions)

A free, structured Excel course built from the function library. Work through the levels in order — each function page has syntax, examples, common errors and a power combo. New functions are added regularly.

🟢 Beginner (58 functions)

Start here: the functions every Excel user needs for totals, counts, text and dates.

Date

• DAY — Day of the Month
• HOUR — Hour From a Time
• MINUTE — Minute From a Time
• SECOND — Second From a Time

Date & Time

• DATE — Build a Date From Year, Month and Day
• DAYS — Days Between Two Dates
• MONTH — Month Number From a Date
• NOW — Current Date and Time
• TODAY — Current Date That Updates Every Day
• WEEKDAY — Day of the Week as a Number
• YEAR — Year From a Date

Information

• ISBLANK — Is the Cell Truly Empty?
• ISEVEN — Is the Number Even?
• ISODD — Is the Number Odd?

Logical

• AND — TRUE Only When All Conditions Are Met
• FALSE — The Logical Value FALSE
• IF — Make Decisions in a Formula
• IFERROR — Replace Errors With Something Friendly
• NOT — Reverse TRUE and FALSE
• OR — TRUE When Any Condition Is Met
• TRUE — The Logical Value TRUE

Lookup

• COLUMN — Column Number of a Cell
• ROW — Row Number of a Cell

Math

• ABS — Absolute Value (Remove the Minus Sign)
• ARABIC — Roman Numerals to Numbers
• EVEN — Round Up to an Even Number
• INT — Whole Number Part (Rounds Down)
• ODD — Round Up to an Odd Number
• PI — The Value of π
• PRODUCT — Multiply Many Numbers
• RAND — Random Decimal Between 0 and 1
• RANDBETWEEN — Random Whole Numbers for Test Data
• ROMAN — Numbers to Roman Numerals
• ROUND — Round to Any Number of Digits
• ROUNDDOWN — Always Round Towards Zero
• ROUNDUP — Always Round Away From Zero
• SQRT — Square Root
• SUM — Add Numbers, Ranges and Whole Columns

Statistical

• AVERAGE — Arithmetic Mean of Numbers
• COUNT — Count Cells That Contain Numbers
• COUNTA — Count Non-Empty Cells
• COUNTBLANK — Count Empty Cells
• MAX — Largest Value in a Range
• MEDIAN — The Middle Value
• MIN — Smallest Value in a Range

Statistics

• RANK — The Old Ranking Function

Text

• CONCAT — Join Text From Cells and Ranges
• CONCATENATE — The Old Way to Join Text
• LEFT — Take Characters From the Start of Text
• LEN — Count Characters in Text
• LOWER — Convert Text to Small Letters
• MID — Extract Text From the Middle
• PROPER — Capitalise Each Word
• RIGHT — Take Characters From the End of Text
• SUBSTITUTE — Replace Specific Text
• TEXT — Format Numbers and Dates as Text
• TRIM — Remove Extra Spaces
• UPPER — Convert Text to Capitals

🟡 Intermediate (156 functions)

Lookups, conditional logic, dynamic arrays and data cleaning — the skills that save hours every week.

AI

• COPILOT — Ask AI Inside a Formula

Date

• ISOWEEKNUM — ISO Week Number
• TIMEVALUE — Text Time to Real Time

Date & Time

• DATEDIF — Age and Tenure in Years, Months, Days
• DATEVALUE — Convert Text Dates Into Real Dates
• EDATE — Add or Subtract Months From a Date
• EOMONTH — Last Day of a Month
• NETWORKDAYS — Working Days Between Two Dates
• TIME — Build a Time From Hours, Minutes, Seconds
• WEEKNUM — Week Number of the Year
• WORKDAY — A Date N Working Days Away
• YEARFRAC — Fraction of a Year Between Dates

Dynamic Array

• RANDARRAY — A Whole Grid of Random Numbers

Engineering

• BASE — Number in Any Base
• BIN2DEC — Binary to Decimal
• CONVERT — Convert Units
• DEC2BIN — Decimal to Binary
• DEC2HEX — Decimal to Hexadecimal
• DECIMAL — Any Base Back to a Number
• DELTA — Are Two Numbers Equal?
• GESTEP — Is It at Least the Threshold?
• HEX2BIN — Hexadecimal to Binary
• HEX2DEC — Hexadecimal to Decimal

Financial

• FV — Future Value of Savings or SIPs
• PDURATION — Years Needed to Reach a Target
• PMT — Loan EMI in One Formula
• RRI — Equivalent Annual Growth Rate (CAGR)
• SLN — Straight-Line Depreciation

Information

• INFO — About Your Excel Environment
• ISERR — Any Error Except #N/A
• ISERROR — Does the Formula Return Any Error?
• ISFORMULA — Does the Cell Hold a Formula?
• ISLOGICAL — Is It TRUE or FALSE?
• ISNA — Is It “Not Found”?
• ISNONTEXT — Anything But Text
• ISNUMBER — Is It a Real Number?
• ISTEXT — Is It Text?
• NA — Return #N/A on Purpose
• SHEET — Which Sheet Number?
• SHEETS — How Many Sheets?
• TYPE — What Kind of Value Is This?

Logical

• IFNA — Handle “Not Found” Only
• IFS — Several Conditions Without Nested IFs
• SWITCH — Match One Value Against a List
• XOR — Exactly One Condition True

Lookup

• CHOOSE — Pick From a List by Number
• COLUMNS — How Many Columns in a Range
• FORMULATEXT — Show a Formula as Text
• HLOOKUP — Look Up Across the Top Row of a Table
• HYPERLINK — Clickable Links From a Formula
• IMAGE — Put a Picture Inside a Cell
• INDEX — Return the Value at a Row and Column Position
• MATCH — Find the Position of a Value
• ROWS — How Many Rows in a Range
• STOCKHISTORY — Historical Share Prices
• TRANSPOSE — Flip Rows and Columns
• VLOOKUP — Look Up a Value in the First Column of a Table
• XLOOKUP — The Modern Lookup That Replaces VLOOKUP
• XMATCH — MATCH With Better Defaults

Lookup & reference

• IMPORTCSV — Import a CSV File Into the Grid
• IMPORTTEXT — Import a Text or CSV File Into the Grid

Math

• CEILING — Round Up to a Multiple (Classic)
• CEILING.MATH — Round Up to a Multiple
• COMBIN — How Many Groups Are Possible
• COS — Cosine of an Angle
• DEGREES — Radians to Degrees
• FACT — Factorial
• FLOOR — Round Down to a Multiple (Classic)
• FLOOR.MATH — Round Down to a Multiple
• GCD — Greatest Common Divisor
• LCM — Least Common Multiple
• LOG10 — Base-10 Logarithm
• MOD — Remainder After Division
• MROUND — Round to the Nearest Multiple
• PERCENTOF — Share of the Total
• PERMUT — Arrangements Where Order Matters
• POWER — Raise to a Power (and Growth Rates)
• QUOTIENT — Whole-Number Division
• RADIANS — Degrees to Radians
• SIGN — Positive, Negative or Zero?
• SIN — Sine of an Angle
• SUBTOTAL — Totals That Respect Filters
• SUMIF — Sum Values That Meet One Condition
• SUMIFS — Sum With Multiple Conditions
• SUMPRODUCT — Multiply Arrays and Add the Results
• TAN — Tangent of an Angle
• TRUNC — Cut Off Decimals Without Rounding

Maths & trig

• CEILING.PRECISE — Round Up to a Multiple (Sign-Safe)
• FLOOR.PRECISE — Round Down to a Multiple (Sign-Safe)

Statistical

• AVERAGEIF — Average With One Condition
• AVERAGEIFS — Average With Multiple Conditions
• COUNTIF — Count Cells That Meet a Condition
• COUNTIFS — Count With Multiple Conditions
• LARGE — The k-th Largest Value (Top 3, Top 10)
• MAXIFS — Largest Value Meeting Conditions
• MINIFS — Smallest Value Meeting Conditions
• MODE.SNGL — The Most Frequent Number
• RANK.EQ — Rank a Number in a List
• SMALL — The k-th Smallest Value

Statistics

• AVERAGEA — Average Counting Text as Zero
• BINOMDIST — Binomial Probability (Older Name)
• CHIDIST — Chi-Square p-Value (Older Name)
• CHIINV — Chi-Square Critical Value (Older Name)
• CHITEST — Chi-Square Test (Older Name)
• CONFIDENCE — Margin of Error (Older Name)
• FDIST — F Probability (Older Name)
• FINV — F Critical Value (Older Name)
• FORECAST — Straight-Line Forecast (Older Name)
• FTEST — F-Test (Older Name)
• MAXA — Largest Value, Logicals Included
• MINA — Minimum Counting Text and TRUE/FALSE
• MODE — Most Frequent Value (Older Name)
• NORMDIST — Normal Distribution (Older Name)
• NORMINV — Inverse Normal (Older Name)
• NORMSDIST — Standard Normal (Older Name)
• NORMSINV — Inverse Standard Normal (Older Name)
• PERCENTILE — k-th Percentile (Older Name)
• PERCENTRANK — Percentile Rank (Older Name)
• POISSON — Poisson Probability (Older Name)
• PROB — Probability From a Table
• QUARTILE — Quartiles (Older Name)
• QUARTILE.INC — Split Data Into Quarters
• RANK.AVG — Rank That Shares Ties Fairly
• STDEV — Sample Standard Deviation (Older Name)
• STDEVA — Sample SD Counting Text and TRUE/FALSE
• STDEVP — Population Standard Deviation (Older Name)
• STDEVPA — Population SD Counting Text and TRUE/FALSE
• TDIST — Student's t Probability (Older Name)
• TINV — Two-Tailed t Critical Value (Older Name)
• TTEST — t-Test (Older Name)
• VAR — Sample Variance (Older Name)
• VARA — Sample Variance Counting Text and TRUE/FALSE
• VARP — Population Variance (Older Name)
• VARPA — Population Variance Counting Text and TRUE/FALSE
• ZTEST — z-Test (Older Name)

Text

• CHAR — Character From a Code (Line Breaks, Symbols)
• CLEAN — Remove Non-Printing Characters
• CODE — Character Code of the First Letter
• DETECTLANGUAGE — Which Language Is This?
• DOLLAR — Number as Currency Text
• ENCODEURL — Make Text Safe for a URL
• EXACT — Case-Sensitive Comparison
• FIND — Position of Text (Case-Sensitive)
• FIXED — Round and Format as Text
• REPLACE — Replace Characters by Position
• REPT — Repeat Text (In-Cell Bar Charts)
• SEARCH — Position of Text (Any Case, Wildcards)
• T — Keep Text, Blank Out Numbers
• TEXTAFTER — Text After a Delimiter
• TEXTBEFORE — Text Before a Delimiter
• TEXTJOIN — Join Text With a Separator, Skipping Blanks
• TRANSLATE — Translate Text in a Cell
• UNICHAR — Any Unicode Symbol
• UNICODE — Unicode Number of a Character
• VALUE — Convert Text to a Number
• VALUETOTEXT — Any Value as Text

🔴 Expert (311 functions)

Advanced array logic, LAMBDA, financial and statistical analysis, and formula combinations experts use.

AI

• PY — Run Python Inside Excel

Add-in & automation

• CALL — Call a DLL Procedure
• REGISTER.ID — ID of a Registered DLL Function

Complex numbers

• COMPLEX — Build a Complex Number
• IMABS — Size (Modulus) of a Complex Number
• IMAGINARY — Imaginary Part
• IMARGUMENT — Angle of a Complex Number
• IMCONJUGATE — Complex Conjugate
• IMCOS — Cosine of a Complex Number
• IMCOSH — Hyperbolic Cosine of a Complex Number
• IMCOT — Cotangent of a Complex Number
• IMCSC — Cosecant of a Complex Number
• IMCSCH — Hyperbolic Cosecant of a Complex Number
• IMDIV — Divide Complex Numbers
• IMEXP — e to a Complex Power
• IMLN — Natural Log of a Complex Number
• IMLOG10 — Base-10 Log of a Complex Number
• IMLOG2 — Base-2 Log of a Complex Number
• IMPOWER — Complex Number to a Power
• IMPRODUCT — Multiply Complex Numbers
• IMREAL — Real Part
• IMSEC — Secant of a Complex Number
• IMSECH — Hyperbolic Secant of a Complex Number
• IMSIN — Sine of a Complex Number
• IMSINH — Hyperbolic Sine of a Complex Number
• IMSQRT — Square Root of a Complex Number
• IMSUB — Subtract Complex Numbers
• IMSUM — Add Complex Numbers
• IMTAN — Tangent of a Complex Number

Cube

• CUBEKPIMEMBER — KPI Value From a Data Model
• CUBEMEMBERPROPERTY — Property of a Cube Member
• CUBERANKEDMEMBER — The n-th Member of a Set
• CUBESETCOUNT — Number of Items in a Set

Database

• DAVERAGE — Average With a Criteria Table
• DCOUNT — Count Numbers With a Criteria Table
• DCOUNTA — Count Non-Empty Records Matching Criteria
• DGET — Get the One Matching Value
• DMAX — Largest Value With a Criteria Table
• DMIN — Smallest Value With a Criteria Table
• DPRODUCT — Multiply Values Matching Criteria
• DSTDEV — Sample SD of Matching Records
• DSTDEVP — Population SD of Matching Records
• DSUM — Sum With a Criteria Table
• DVAR — Sample Variance of Matching Records
• DVARP — Population Variance of Matching Records

Date

• DAYS360 — Days on a 360-Day Year
• NETWORKDAYS.INTL — Working Days With Your Own Weekend
• WORKDAY.INTL — Due Date With Your Own Weekend

Dynamic Array

• CHOOSECOLS — Pick Specific Columns
• CHOOSEROWS — Pick Specific Rows
• DROP — Remove First or Last Rows
• EXPAND — Grow an Array to a Fixed Size
• FILTER — Return Every Row That Matches
• GROUPBY — A Pivot-Style Summary in One Formula
• HSTACK — Put Arrays Side by Side
• PIVOTBY — A Cross-Tab Without a Pivot Table
• SEQUENCE — Generate a List of Numbers or Dates
• SORT — Sort Data With a Formula
• SORTBY — Sort by Another Column
• TAKE — First or Last N Rows of a Range
• TOCOL — Turn a Grid Into One Column
• TOROW — Flatten Into One Row
• TRIMRANGE — Cut Empty Edges Off a Range
• UNIQUE — Distinct List Without Remove Duplicates
• VSTACK — Stack Tables Vertically
• WRAPCOLS — Fold a List Into Columns
• WRAPROWS — Reshape a List Into a Grid

Engineering

• BESSELI — Modified Bessel Function In(x)
• BESSELJ — Bessel Function Jn(x)
• BESSELK — Modified Bessel Function Kn(x)
• BESSELY — Bessel Function Yn(x)
• BIN2HEX — Binary to Hexadecimal
• BIN2OCT — Binary to Octal
• BITAND — Bitwise AND
• BITLSHIFT — Shift Bits Left
• BITOR — Bitwise OR
• BITRSHIFT — Shift Bits to the Right
• BITXOR — Bitwise Exclusive OR
• DEC2OCT — Decimal to Octal
• ERF — Error Function
• ERF.PRECISE — Error Function (2010+ Version)
• ERFC — Complementary Error Function
• ERFC.PRECISE — Complementary Error Function (2010+ Version)
• HEX2OCT — Hexadecimal to Octal
• OCT2BIN — Octal to Binary
• OCT2DEC — Octal to Decimal
• OCT2HEX — Octal to Hexadecimal

Finance

• ACCRINTM — Interest Accrued When Paid at Maturity
• AMORDEGRC — French Degressive Depreciation
• COUPDAYBS — Days From Last Coupon to Settlement
• COUPDAYS — Days in the Current Coupon Period
• COUPDAYSNC — Days From Settlement to Next Coupon
• COUPPCD — Previous Coupon Date
• EUROCONVERT — Convert Between Euro and Old Euro-Zone Currencies
• ODDFPRICE — Price of a Bond With an Odd First Period
• ODDFYIELD — Yield of a Bond With an Odd First Period
• ODDLPRICE — Price of a Bond With an Odd Last Period
• ODDLYIELD — Yield of a Bond With an Odd Last Period
• PRICEDISC — Price of a Discounted Security
• PRICEMAT — Price of a Security Paying Interest at Maturity
• TBILLEQ — Bond-Equivalent Yield of a T-Bill
• YIELDDISC — Yield of a Discounted Security
• YIELDMAT — Yield of a Security Paying Interest at Maturity

Financial

• ACCRINT — Interest Earned Since Last Coupon
• AMORLINC — Depreciation With Part-Year Start
• COUPNCD — Next Coupon Date
• COUPNUM — Coupons Left Until Maturity
• CUMIPMT — Total Interest Over a Range of EMIs
• CUMPRINC — Principal Repaid Over a Period
• DB — Declining-Balance Depreciation
• DDB — Double-Declining Depreciation
• DISC — Discount Rate of a Security
• DOLLARDE — Fractional Prices to Decimals
• DOLLARFR — Decimal Prices to Fractions
• DURATION — How Sensitive a Bond Is to Rates
• EFFECT — Real Annual Rate With Compounding
• FVSCHEDULE — Growth at Changing Rates
• INTRATE — Interest Rate of a Fully Invested Security
• IPMT — Interest Part of an EMI
• IRR — Return of Regular (Periodic) Cash Flows
• ISPMT — Interest on Equal-Principal Loans
• MDURATION — Modified Duration
• MIRR — IRR With Realistic Reinvestment
• NOMINAL — Effective Rate Back to Nominal
• NPER — How Many Payments Until Paid Off
• NPV — Net Present Value of Future Cash Flows
• PPMT — Principal Part of an EMI
• PRICE — Bond Price From Its Yield
• PV — What a Future Amount Is Worth Today
• RATE — The Interest Rate Hidden in a Loan
• RECEIVED — Amount Received at Maturity
• SYD — Sum-of-Years’ Digits Depreciation
• TBILLPRICE — Treasury Bill Price
• TBILLYIELD — Treasury Bill Yield
• VDB — Depreciation for Any Span
• XIRR — Real Return on SIPs and Irregular Cash Flows
• XNPV — NPV for Cash Flows on Specific Dates
• YIELD — Bond Yield From Its Price

Information

• CELL — Information About a Cell
• ERROR.TYPE — Which Error Is It?
• ISREF — Is It a Valid Reference?
• N — Turn a Value Into a Number
• RTD — Real-Time Data From a COM Server

Logical

• BYCOL — Apply a Calculation to Each Column
• BYROW — Apply a Calculation to Each Row
• ISOMITTED — Was an Optional Argument Left Out?
• LAMBDA — Create Your Own Excel Functions
• LET — Name Parts of a Formula
• MAKEARRAY — Generate a Grid From Row and Column Numbers
• MAP — Transform Every Value in an Array
• REDUCE — Boil an Array Down to One Result
• SCAN — Running Totals in One Formula

Lookup

• ADDRESS — Build a Cell Address as Text
• AREAS — How Many Blocks in a Reference
• CUBEMEMBER — A Label From the Data Model
• CUBESET — A Set of Members for Top-N Reports
• CUBEVALUE — Numbers Straight From the Data Model
• GETPIVOTDATA — Reliable Numbers From a Pivot Table
• INDIRECT — Build a Reference From Text
• LOOKUP — The Old Lookup With a Famous Trick
• OFFSET — A Range That Moves or Resizes
• WEBSERVICE — Read Data From a URL

Math

• ACOS — Angle From a Cosine
• AGGREGATE — SUBTOTAL That Can Ignore Errors
• ASIN — Angle From a Sine
• ATAN — Angle From a Slope
• ATAN2 — Angle From X and Y
• COMBINA — Combinations With Repeats
• EXP — e Raised to a Power
• FACTDOUBLE — Double Factorial
• ISO.CEILING — Round Up, Ignoring the Sign
• LN — Natural Logarithm
• LOG — Logarithm to Any Base
• MDETERM — Determinant of a Matrix
• MINVERSE — Inverse of a Matrix
• MMULT — Multiply Matrices
• MULTINOMIAL — Ways to Split Into Groups
• MUNIT — Identity Matrix
• SUMSQ — Sum of Squares

Maths & trig

• ACOSH — Inverse Hyperbolic Cosine
• ACOT — Inverse Cotangent
• ACOTH — Inverse Hyperbolic Cotangent
• ASINH — Inverse Hyperbolic Sine
• ATANH — Inverse Hyperbolic Tangent
• COSH — Hyperbolic Cosine
• COT — Cotangent
• COTH — Hyperbolic Cotangent
• CSC — Cosecant
• CSCH — Hyperbolic Cosecant
• PERMUTATIONA — Arrangements With Repeats
• SEC — Secant
• SECH — Hyperbolic Secant
• SERIESSUM — Sum of a Power Series
• SINH — Hyperbolic Sine
• SQRTPI — Square Root of x Times Pi
• SUMX2MY2 — Sum of Differences of Squares
• SUMX2PY2 — Sum of Sums of Squares
• SUMXMY2 — Sum of Squared Differences
• TANH — Hyperbolic Tangent

Statistical

• CORREL — How Strongly Two Things Move Together
• FORECAST.LINEAR — Predict a Value From a Trend
• FREQUENCY — Count Values Into Bins
• PERCENTILE.INC — Value at a Percentile (e.g. 90th)
• STDEV.S — How Spread Out Are the Numbers?

Statistics

• AVEDEV — Average Distance From the Mean
• BETA.DIST — Probability for Values Between 0 and 1
• BETA.INV — Value for a Beta Probability
• BETADIST — Beta Distribution (Older Name)
• BETAINV — Inverse Beta (Older Name)
• BINOM.DIST — Chance of Exactly k Successes
• BINOM.DIST.RANGE — Probability of Successes in a Range
• BINOM.INV — Smallest Count Reaching a Probability
• CHISQ.DIST — Chi-Square Distribution (Left Tail)
• CHISQ.DIST.RT — Chi-Square p-Value (Right Tail)
• CHISQ.INV — Chi-Square Value for a Left-Tail Probability
• CHISQ.INV.RT — Chi-Square Critical Value
• CHISQ.TEST — Are These Categories Related?
• CONFIDENCE.NORM — Margin of Error
• CONFIDENCE.T — Margin of Error for Small Samples
• COVAR — Covariance (Older Name)
• COVARIANCE.P — Covariance of a Whole Population
• COVARIANCE.S — Do Two Series Move Together?
• CRITBINOM — Binomial Threshold (Older Name)
• DEVSQ — Sum of Squared Deviations
• EXPON.DIST — Waiting-Time Probability
• EXPONDIST — Exponential Distribution (Older Name)
• F.DIST — F Distribution (Left Tail)
• F.DIST.RT — F Test p-Value (Right Tail)
• F.INV — F Value for a Left-Tail Probability
• F.INV.RT — F Critical Value
• F.TEST — Are Two Spreads Different?
• FISHER — Fisher Transformation of a Correlation
• FISHERINV — Back From Fisher's z to a Correlation
• FORECAST.ETS — Forecast With Seasonality
• FORECAST.ETS.CONFINT — How Uncertain Is the Forecast?
• FORECAST.ETS.SEASONALITY — Which Cycle Did Excel Find?
• FORECAST.ETS.STAT — Statistics of an ETS Forecast
• GAMMA — The Gamma Function
• GAMMA.DIST — Gamma Distribution
• GAMMA.INV — Value for a Gamma Probability
• GAMMADIST — Gamma Distribution (Older Name)
• GAMMAINV — Inverse Gamma (Older Name)
• GAMMALN — Natural Log of the Gamma Function
• GAMMALN.PRECISE — Natural Log of Gamma (2010+ Version)
• GAUSS — Probability Between the Mean and z
• GEOMEAN — Average Growth Rate
• GROWTH — Extend an Exponential Trend
• HARMEAN — The Right Average for Rates
• HYPGEOM.DIST — Sampling Without Replacement
• HYPGEOMDIST — Hypergeometric (Older Name)
• INTERCEPT — Where the Trend Line Starts
• KURT — How Heavy Are the Tails?
• LINEST — Full Regression Statistics
• LOGEST — Exponential Curve Fit
• LOGINV — Inverse Lognormal (Older Name)
• LOGNORM.DIST — Lognormal Distribution
• LOGNORM.INV — Value for a Lognormal Probability
• LOGNORMDIST — Lognormal (Older Name)
• MODE.MULT — All the Most Common Values
• NEGBINOM.DIST — Failures Before the k-th Success
• NEGBINOMDIST — Negative Binomial (Older Name)
• NORM.DIST — Bell-Curve Probability
• NORM.INV — Value for a Given Probability
• NORM.S.DIST — Standard Normal Probability
• NORM.S.INV — Z-Score for a Probability
• PEARSON — Correlation (Pearson)
• PERCENTILE.EXC — Percentile Without the End Points
• PERCENTRANK.EXC — Percentile Position, Excluding Ends
• PERCENTRANK.INC — Where a Value Stands, as a %
• PHI — Standard Normal Density
• POISSON.DIST — Chance of Rare Events
• QUARTILE.EXC — Quartiles Excluding the Ends
• RSQ — How Well a Line Fits
• SKEW — Is the Data Lopsided?
• SKEW.P — Skewness of a Population
• SLOPE — How Fast a Trend Rises
• STANDARDIZE — Z-Score in One Step
• STDEV.P — Standard Deviation of a Whole Population
• STEYX — Typical Error of a Trend Line
• T.DIST — Student’s t Probability
• T.DIST.2T — Two-Tailed t-Test p-Value
• T.DIST.RT — One-Tailed t p-Value (Right)
• T.INV — t Value for a Left-Tail Probability
• T.INV.2T — Critical t Value
• T.TEST — Is the Difference Real?
• TREND — Extend a Straight-Line Trend
• TRIMMEAN — Average That Ignores Extremes
• VAR.P — Variance of a Whole Population
• VAR.S — Variance of a Sample
• WEIBULL — Weibull (Older Name)
• WEIBULL.DIST — Weibull Distribution for Failure Times
• Z.TEST — One-Sample z-Test

Text

• ARRAYTOTEXT — A Whole Range as One Text
• ASC — Full-Width to Half-Width Characters
• BAHTTEXT — Number to Thai Baht Words
• DBCS — Half-Width to Full-Width (Older Name)
• FILTERXML — Pick Values Out of XML
• FINDB — Find Position in Bytes
• JIS — Half-Width to Full-Width Characters
• LEFTB — Leftmost Bytes
• LENB — Length in Bytes
• MIDB — Middle Bytes
• NUMBERVALUE — Convert Text Numbers With Any Separators
• PHONETIC — Furigana Reading of Japanese Text
• REGEXEXTRACT — Pull Text That Matches a Pattern
• REGEXREPLACE — Find and Replace With Patterns
• REGEXTEST — Does Text Match a Pattern?
• REPLACEB — Replace by Bytes
• RIGHTB — Rightmost Bytes
• SEARCHB — Search Position in Bytes
• TEXTSPLIT — Split Text Into Cells

Keep going

Put functions together in formula combos, automate with the free VBA course, and practise in the Formula Lab.