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 →Atul Vij
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 →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 →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 →