HYPERLINK Function in Excel: Clickable Links From a Formula
HYPERLINK builds a clickable link — to websites, files, or other sheets in the same workbook.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
NORMDIST Function in Excel: Normal Distribution (Older Name)
NORMDIST Function in Excel: Normal Distribution (Older Name)
NORMDIST gives the normal distribution for a mean and SD. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →PROB Function in Excel: Probability From a Table
PROB Function in Excel: Probability From a Table
PROB adds the probabilities of outcomes falling between two limits, from a simple value/probability table.
Read article →ISNONTEXT Function in Excel: Anything But Text
ISNONTEXT Function in Excel: Anything But Text
ISNONTEXT is TRUE for numbers, blanks, errors and logicals. Handy in data validation to block text in amount columns.
Read article →BINOMDIST Function in Excel: Binomial Probability (Older Name)
BINOMDIST Function in Excel: Binomial Probability (Older Name)
BINOMDIST returns the binomial probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →IMPORTCSV Function in Excel: Import a CSV File Into the Grid
IMPORTCSV Function in Excel: Import a CSV File Into the Grid
IMPORTCSV (2026) is the simple version of IMPORTTEXT for standard CSV files: one argument, a refreshable dynamic array.
Read article →NORMSINV Function in Excel: Inverse Standard Normal (Older Name)
NORMSINV Function in Excel: Inverse Standard Normal (Older Name)
NORMSINV returns z for a probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →TIMEVALUE Function in Excel: Text Time to Real Time
TIMEVALUE Function in Excel: Text Time to Real Time
DateLevel: IntermediateAvailable in: Excel 2007+TIMEVALUE turns text like "2:45 PM" into a real time you can add and.
Read article →BINOM.DIST Function in Excel: Chance of Exactly k Successes
BINOM.DIST Function in Excel: Chance of Exactly k Successes
BINOM.DIST handles yes/no events with a fixed chance — defects in a batch, customers who convert.
Read article →CONFIDENCE Function in Excel: Margin of Error (Older Name)
CONFIDENCE Function in Excel: Margin of Error (Older Name)
CONFIDENCE returns the normal margin of error for a mean. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →NORM.DIST Function in Excel: Bell-Curve Probability
NORM.DIST Function in Excel: Bell-Curve Probability
NORM.DIST gives the probability (cumulative) or the curve height (density) of a normal distribution at a value.
Read article →NORMINV Function in Excel: Inverse Normal (Older Name)
NORMINV Function in Excel: Inverse Normal (Older Name)
NORMINV returns the value at a normal probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →