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 →Atul Vij
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 →Linux Server Basics: 15 Commands Every Website Owner Needs
Linux Server Basics: 15 Commands Every Website Owner Needs
The Linux commands you actually need to look after a small website server: disk space, memory, logs, services, permissions, updates and safe file editing…
Read article →SAP Fiori Launchpad for Business Users: Spaces, Tiles and Search
SAP Fiori Launchpad for Business Users: Spaces, Tiles and Search
Find your way around the SAP Fiori launchpad: spaces and pages, tiles and KPIs, enterprise search, personalising your home page and when to fall…
Read article →SAP FICO for Finance Users: GL, AP, AR, Cost Centres and the Reports You Will Use
SAP FICO for Finance Users: GL, AP, AR, Cost Centres and the Reports You Will Use
A plain-English tour of SAP FI and CO for accountants: company codes, GL accounts, document types, vendor and customer processes, cost centres and profit…
Read article →HYPERLINK Function in Excel: Clickable Links From a Formula
HYPERLINK Function in Excel: Clickable Links From a Formula
HYPERLINK builds a clickable link — to websites, files, or other sheets in the same workbook.
Read article →