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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →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 →Compare Two Lists in Excel: Find Matches, Missing Items and Differences
Compare Two Lists in Excel: Find Matches, Missing Items and Differences
Which customers are in this month’s list but not last month’s? Compare two lists with COUNTIF, MATCH/XMATCH, FILTER and conditional formatting — in old…
Read article →INDEX and MATCH Explained: The Lookup That Beats VLOOKUP
INDEX and MATCH Explained: The Lookup That Beats VLOOKUP
Understand INDEX and MATCH separately, combine them for flexible lookups in any Excel version, look left, do two-way and multiple-criteria lookups, approximate matches, and…
Read article →Weighted Average in Excel: SUMPRODUCT / SUM (Prices, Marks, Interest Rates)
Weighted Average in Excel: SUMPRODUCT / SUM (Prices, Marks, Interest Rates)
Calculate weighted averages correctly — average price by quantity, weighted marks, blended interest rates — with SUMPRODUCT/SUM, weighted averages with conditions, and why plain…
Read article →VAR Function in Excel: Sample Variance (Older Name)
VAR Function in Excel: Sample Variance (Older Name)
VAR estimates variance from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →Two-Way Lookup in Excel: INDEX + MATCH + MATCH (and the XLOOKUP Version)
Two-Way Lookup in Excel: INDEX + MATCH + MATCH (and the XLOOKUP Version)
Look up a value at the crossing of a row and a column — target for South in August, price for size L in…
Read article →BITAND Function in Excel: Bitwise AND
BITAND Function in Excel: Bitwise AND
BITAND compares numbers bit by bit. Useful for decoding status flags stored as one number.
Read article →DOLLARDE Function in Excel: Fractional Prices to Decimals
DOLLARDE Function in Excel: Fractional Prices to Decimals
DOLLARDE converts prices quoted in fractions (like 1 and 2/16) into decimals — still seen in some bond and commodity feeds.
Read article →Indian Financial Year and Quarter From a Date in Excel (FY 2026-27, Q1–Q4)
Indian Financial Year and Quarter From a Date in Excel (FY 2026-27, Q1–Q4)
Turn any date into the Indian financial year (April–March) like "FY 2026-27" or "FY27", the fiscal quarter Q1–Q4, the fiscal month number and FY…
Read article →