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 →Atul Vij
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 →GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST models waiting times and amounts that are always positive and skewed, like claim sizes or repair times.
Read article →Charts Intermediate Lesson 6: Project – An Interactive Sales Dashboard
Charts Intermediate Lesson 6: Project – An Interactive Sales Dashboard
Final project: KPI cards, a combo trend, a dynamic region chart, an actual-vs-target chart and sparklines on one printable page with slicers and a…
Read article →ZTEST Function in Excel: z-Test (Older Name)
ZTEST Function in Excel: z-Test (Older Name)
ZTEST returns the one-tailed p-value of a z-test. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →