SAP ALV Layouts: Save Your Own Report Views
Most SAP reports use the ALV grid. Learn to choose columns, sort, filter, subtotal and save your own layout — and set it as…
Read article →Focus Mode on Windows and Android: Silence Notifications Without Missing What Matters
Focus Mode on Windows and Android: Silence Notifications Without Missing What Matters
Set up Do Not Disturb and focus sessions on Windows 11 and Android with exceptions for the people and apps that matter, scheduled quiet…
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 →TYPE Function in Excel: What Kind of Value Is This?
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 →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 →