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 →SAP SE16N and SQVI: Pull Table Data Without ABAP
SAP SE16N and SQVI: Pull Table Data Without ABAP
Use SE16N to browse SAP tables and SQVI QuickViews to join them into your own reports — with the most useful table names for…
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 →SAP Basics Lesson 2: Transaction Codes You Will Use
SAP Basics Lesson 2: Transaction Codes You Will Use
The T-code system explained: /n and /o, display vs change vs create codes (03/02/01), finding a T-code, common codes for finance, purchasing and sales…
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 →