ENCODEURL Function in Excel: Make Text Safe for a URL
TextLevel: IntermediateAvailable in: Excel 2013+ENCODEURL converts spaces and symbols into URL codes (%20 and so on).Syntax=ENCODEURL(text)ArgumentWhat it.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
BETA.INV Function in Excel: Value for a Beta Probability
BETA.INV Function in Excel: Value for a Beta Probability
BETA.INV is the reverse of BETA.DIST: for a probability it returns the value, e.g. the duration you will meet 90% of the time.
Read article →NORMSDIST Function in Excel: Standard Normal (Older Name)
NORMSDIST Function in Excel: Standard Normal (Older Name)
NORMSDIST gives the cumulative standard normal probability for z. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier…
Read article →POISSON.DIST Function in Excel: Chance of Rare Events
POISSON.DIST Function in Excel: Chance of Rare Events
POISSON.DIST models counts per interval — calls per minute, breakdowns per month.
Read article →IMAGE Function in Excel: Put a Picture Inside a Cell
IMAGE Function in Excel: Put a Picture Inside a Cell
IMAGE shows an image from a web address inside a cell — product catalogues that sort and filter with their pictures.
Read article →NORM.S.DIST Function in Excel: Standard Normal Probability
NORM.S.DIST Function in Excel: Standard Normal Probability
NORM.S.DIST is NORM.DIST with mean 0 and standard deviation 1 — perfect for z-scores.
Read article →BETADIST Function in Excel: Beta Distribution (Older Name)
BETADIST Function in Excel: Beta Distribution (Older Name)
BETADIST returns the cumulative beta probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →BINOM.INV Function in Excel: Smallest Count Reaching a Probability
BINOM.INV Function in Excel: Smallest Count Reaching a Probability
BINOM.INV returns the smallest number of successes whose cumulative probability reaches the target, e.g. how many defects is 'unusual'.
Read article →NEGBINOM.DIST Function in Excel: Failures Before the k-th Success
NEGBINOM.DIST Function in Excel: Failures Before the k-th Success
NEGBINOM.DIST gives the chance of a number of failures before reaching a set number of successes, e.g. calls before the 3rd sale.
Read article →STANDARDIZE Function in Excel: Z-Score in One Step
STANDARDIZE Function in Excel: Z-Score in One Step
STANDARDIZE converts a value to a z-score: how many standard deviations it sits from the mean. Z-scores let you compare marks from an easy…
Read article →BETA.DIST Function in Excel: Probability for Values Between 0 and 1
BETA.DIST Function in Excel: Probability for Values Between 0 and 1
BETA.DIST gives the beta distribution, used for proportions and task-duration estimates (PERT). With A and B you can rescale it to any range, e.g.…
Read article →HYPGEOM.DIST Function in Excel: Sampling Without Replacement
HYPGEOM.DIST Function in Excel: Sampling Without Replacement
HYPGEOM.DIST gives the chance of k successes when you draw a sample without putting items back, e.g. defective units found in an inspection sample.
Read article →