GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST returns the gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →PowerShell for Office Work: 10 Small Scripts That Save Real Time
PowerShell for Office Work: 10 Small Scripts That Save Real Time
Practical PowerShell for non-programmers: rename hundreds of files, find duplicates, combine CSVs, clean old downloads, check disk space and more — each script explained…
Read article →WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS takes a long list and wraps it into columns of a fixed height — printable labels, seating plans.
Read article →TTEST Function in Excel: t-Test (Older Name)
TTEST Function in Excel: t-Test (Older Name)
TTEST returns the p-value of a t-test between two samples. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →The 10 Types of Automation (and Whether AI and Automation Are the Same Thing)
The 10 Types of Automation (and Whether AI and Automation Are the Same Thing)
Scripts and macros, RPA, workflow tools, browser automation, ERP scripting like SAP GUI Scripting, schedulers, data pipelines, infrastructure as code and AI agents —…
Read article →How Does a Microwave Heat Food? (And Why It Doesn’t Cook From the Inside)
How Does a Microwave Heat Food? (And Why It Doesn’t Cook From the Inside)
Microwaves make water molecules spin and jostle, turning wave energy into heat in the outer few centimetres of food. How it works, why some…
Read article →WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS reshapes a single column into rows of a fixed width — e.g. a pasted list where every 3 lines are one record.
Read article →ERF.PRECISE Function in Excel: Error Function (2010+ Version)
ERF.PRECISE Function in Excel: Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERF.PRECISE is the 2010 version of ERF with one argument.Syntax=ERF.PRECISE(x)ArgumentWhat it.
Read article →GAMMA.INV Function in Excel: Value for a Gamma Probability
GAMMA.INV Function in Excel: Value for a Gamma Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+GAMMA.INV returns the value at a given gamma probability.Syntax=GAMMA.INV(probability, alpha.
Read article →ERFC.PRECISE Function in Excel: Complementary Error Function (2010+ Version)
ERFC.PRECISE Function in Excel: Complementary Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERFC.PRECISE is the 2010 version of ERFC.Syntax=ERFC.PRECISE(x)ArgumentWhat it meansxValueExamplesExample.
Read article →5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
Five ways to find the last used row in Excel VBA — End(xlUp), UsedRange, Find, CurrentRegion and ListObject — with the traps each one…
Read article →BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE gives the chance of getting between s and s2 successes in n trials, e.g. 3 to 5 sales from 20 calls.
Read article →