NEGBINOMDIST Function in Excel: Negative Binomial (Older Name)
NEGBINOMDIST returns the probability of a number of failures before the k-th success. It is a compatibility function: Excel keeps it so workbooks from…
Read article →Why Do We Get Goosebumps?
Why Do We Get Goosebumps?
Goosebumps are tiny muscles pulling your hairs upright — a leftover reflex from furry ancestors that fluffed up to keep warm or look bigger.…
Read article →CRITBINOM Function in Excel: Binomial Threshold (Older Name)
CRITBINOM Function in Excel: Binomial Threshold (Older Name)
CRITBINOM returns the smallest count whose cumulative binomial probability reaches alpha. It is a compatibility function: Excel keeps it so workbooks from Excel 2007…
Read article →POISSON Function in Excel: Poisson Probability (Older Name)
POISSON Function in Excel: Poisson Probability (Older Name)
POISSON returns the Poisson probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →EXPON.DIST Function in Excel: Waiting-Time Probability
EXPON.DIST Function in Excel: Waiting-Time Probability
EXPON.DIST gives the chance the wait until the next event is under a given time.
Read article →CHOOSECOLS Function in Excel: Pick Specific Columns
CHOOSECOLS Function in Excel: Pick Specific Columns
Dynamic ArrayLevel: ExpertAvailable in: Excel 365 / 2021+CHOOSECOLS returns only the columns you list, in the order you list them.Syntax=CHOOSECOLS(array.
Read article →ERF Function in Excel: Error Function
ERF Function in Excel: Error Function
ERF returns the error function between 0 and x (or between two limits), used in probability and diffusion.
Read article →AI Models Compared: GPT, Claude, Gemini, Llama, DeepSeek, Qwen, Mistral and More
AI Models Compared: GPT, Claude, Gemini, Llama, DeepSeek, Qwen, Mistral and More
A practical guide to today’s popular AI model families — OpenAI GPT, Anthropic Claude, Google Gemini, Meta Llama, DeepSeek, Qwen, Mistral, Gemma, Kimi and…
Read article →SAP Basics Lesson 6: FI Overview for Finance Users
SAP Basics Lesson 6: FI Overview for Finance Users
SAP Financial Accounting explained for users: G/L, AP and AR, documents and posting keys, line item reports, open item clearing, period closing and the…
Read article →ENCODEURL Function in Excel: Make Text Safe for a URL
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 →SAP GUI Scripting Lesson 2: Recording Your First Script
SAP GUI Scripting Lesson 2: Recording Your First Script
Record a script with Script Recording and Playback: start recording, run a report, stop, find the .vbs file and replay it, with tips for…
Read article →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 →