MUNIT Function in Excel: Identity Matrix
MUNIT returns an identity matrix — 1s on the diagonal, 0s elsewhere. Handy for checking MINVERSE results.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
CEILING.PRECISE Function in Excel: Round Up to a Multiple (Sign-Safe)
CEILING.PRECISE Function in Excel: Round Up to a Multiple (Sign-Safe)
CEILING.PRECISE rounds up to a multiple regardless of the signs of number and significance; negatives round toward zero.
Read article →ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING always rounds towards positive infinity, whatever the sign of the multiple — useful when data mixes positive and negative adjustments.
Read article →FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR rounds down to a multiple — full boxes you can ship, 15-minute billing blocks.
Read article →CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING rounds up to the nearest multiple — prices ending in 5 or 9, pack sizes. CEILING.MATH is the newer version that handles negatives…
Read article →MINUTE Function in Excel: Minute From a Time
MINUTE Function in Excel: Minute From a Time
DateLevel: BeginnerAvailable in: Excel 2007+MINUTE returns 0–59 from a time.Syntax=MINUTE(serial_number)ArgumentWhat it.
Read article →SECOND Function in Excel: Second From a Time
SECOND Function in Excel: Second From a Time
DateLevel: BeginnerAvailable in: Excel 2007+SECOND returns 0–59. Mostly used to strip seconds from machine.
Read article →HOUR Function in Excel: Hour From a Time
HOUR Function in Excel: Hour From a Time
HOUR returns 0–23 from a time or date-time. The quickest way to group call-centre or sales data by hour of day.
Read article →TIME Function in Excel: Build a Time From Hours, Minutes, Seconds
TIME Function in Excel: Build a Time From Hours, Minutes, Seconds
TIME creates a time value. Excel stores time as a fraction of a day: 12:00 is 0.5, 6:00 is 0.25.
Read article →NOW Function in Excel: Current Date and Time
NOW Function in Excel: Current Date and Time
NOW returns the current date and time and updates every time the sheet recalculates. For a timestamp that stays fixed, press Ctrl+; then Space…
Read article →VARP Function in Excel: Population Variance (Older Name)
VARP Function in Excel: Population Variance (Older Name)
VARP gives the variance of a whole population. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE
VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+VARPA is the population version of VARA.Syntax=VARPA(value1, [value2], ...)ArgumentWhat it.
Read article →