TYPE Function in Excel: What Kind of Value Is This?
InformationLevel: IntermediateAvailable in: Excel 2007+TYPE returns 1 number, 2 text, 4 logical, 16 error or 64 array.Syntax=TYPE(value)ArgumentWhat it.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
COLUMNS Function in Excel: How Many Columns in a Range
COLUMNS Function in Excel: How Many Columns in a Range
COLUMNS counts columns in a range — useful for dynamic column numbers and checks.
Read article →DATEVALUE Function in Excel: Convert Text Dates Into Real Dates
DATEVALUE Function in Excel: Convert Text Dates Into Real Dates
DATEVALUE turns a date written as text into a real date number. It follows your Windows regional settings, which is exactly why it sometimes…
Read article →IMPORTTEXT Function in Excel: Import a Text or CSV File Into the Grid
IMPORTTEXT Function in Excel: Import a Text or CSV File Into the Grid
IMPORTTEXT (2026) loads a .txt, .csv or .tsv file into a refreshable dynamic array with one formula, with options for delimiter, encoding and rows…
Read article →NUMBERVALUE Function in Excel: Convert Text Numbers With Any Separators
NUMBERVALUE Function in Excel: Convert Text Numbers With Any Separators
NUMBERVALUE converts text to a number using separators you specify — essential for European-style “1.234,56” exports.
Read article →DSTDEVP Function in Excel: Population SD of Matching Records
DSTDEVP Function in Excel: Population SD of Matching Records
DSTDEVP returns the population standard deviation for matching records. Like all D-functions it uses a database range and a criteria range you can edit…
Read article →CONFIDENCE.T Function in Excel: Margin of Error for Small Samples
CONFIDENCE.T Function in Excel: Margin of Error for Small Samples
CONFIDENCE.T is the margin of error using the t-distribution, correct for small samples (under ~30) where CONFIDENCE.NORM is too narrow.
Read article →Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Step-by-step: enable SAP GUI Scripting, record a transaction, and run it from Excel VBA to export a report automatically.
Read article →NORM.S.INV Function in Excel: Z-Score for a Probability
NORM.S.INV Function in Excel: Z-Score for a Probability
NORM.S.INV returns the z-score for a cumulative probability — where the famous 1.96 comes from.
Read article →ISTEXT Function in Excel: Is It Text?
ISTEXT Function in Excel: Is It Text?
ISTEXT returns TRUE for text — the quickest way to find numbers or dates that were imported as text.
Read article →MODE Function in Excel: Most Frequent Value (Older Name)
MODE Function in Excel: Most Frequent Value (Older Name)
MODE returns the most frequent number. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →RANDARRAY Function in Excel: A Whole Grid of Random Numbers
RANDARRAY Function in Excel: A Whole Grid of Random Numbers
RANDARRAY returns an array of random numbers, optionally whole numbers between limits — instant test data.
Read article →