AVEDEV Function in Excel: Average Distance From the Mean
AVEDEV is the average of absolute deviations — an easier-to-explain measure of spread than standard deviation (“on average we are off by 12 units”).
Read article →DEVSQ Function in Excel: Sum of Squared Deviations
DEVSQ Function in Excel: Sum of Squared Deviations
DEVSQ adds up how far each value is from the mean, squared. It is the raw ingredient of variance and of ANOVA tables.
Read article →VAR.P Function in Excel: Variance of a Whole Population
VAR.P Function in Excel: Variance of a Whole Population
VAR.P is the population version of VAR.S: it divides by n, not n−1. Use it when the data is everything there is — all…
Read article →Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Excel 365’s dynamic arrays let one formula return a whole list. Learn SORT, FILTER, UNIQUE and SEQUENCE with practical examples, the # spill reference…
Read article →VBA String Functions: Left, Mid, InStr, Replace, Split and More
VBA String Functions: Left, Mid, InStr, Replace, Split and More
Clean and reshape text in Excel VBA with Left, Right, Mid, Len, InStr, Replace, Trim, UCase, Split and Join — with real data-cleaning examples.
Read article →STOCKHISTORY Function in Excel: Historical Share Prices
STOCKHISTORY Function in Excel: Historical Share Prices
STOCKHISTORY fetches daily, weekly or monthly prices for a stock or currency pair into a spill range.
Read article →VBA Loops Explained: For, For Each, Do While and Do Until
VBA Loops Explained: For, For Each, Do While and Do Until
Learn every Excel VBA loop — For…Next, For Each, Do While, Do Until — when to use each, how to exit early, and how…
Read article →5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
Five small, useful Excel VBA macros explained: the Mod operator, finding the second highest value, summing by cell colour, deleting blank rows and highlighting…
Read article →Decisions in VBA: If…Then, And/Or and Select Case
Decisions in VBA: If…Then, And/Or and Select Case
Make Excel macros decide: If…Then…ElseIf, logical operators And/Or/Not, and Select Case — with real examples and common mistakes.
Read article →Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Excel cells from VBA: fonts, fill colours, borders, number and date formats, alignment and conditional formatting — with copy-paste examples.
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Learn how to declare variables in Excel VBA, choose the right data type, use Option Explicit, and avoid the mistakes that cause type mismatch…
Read article →DELTA Function in Excel: Are Two Numbers Equal?
DELTA Function in Excel: Are Two Numbers Equal?
DELTA returns 1 if two numbers are equal and 0 otherwise — easy to SUM for a count of matches.
Read article →