ISPMT Function in Excel: Interest on Equal-Principal Loans
ISPMT calculates interest for a loan where the principal is repaid in equal parts (not an EMI). Note the period argument starts at 0.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
LENB Function in Excel: Length in Bytes
LENB Function in Excel: Length in Bytes
LENB returns the number of bytes; identical to LEN in English setups, double for East Asian characters when a DBCS language is set.
Read article →DURATION Function in Excel: How Sensitive a Bond Is to Rates
DURATION Function in Excel: How Sensitive a Bond Is to Rates
DURATION returns Macaulay duration in years. Roughly, a bond with duration 7 loses about 7% in price if rates rise 1% — which is…
Read article →NOMINAL Function in Excel: Effective Rate Back to Nominal
NOMINAL Function in Excel: Effective Rate Back to Nominal
NOMINAL reverses EFFECT: it tells you the quoted annual rate behind an effective yield.
Read article →Protect Excel Sheets and Workbooks the Right Way
Protect Excel Sheets and Workbooks the Right Way
Lock formulas and leave inputs editable: unlock input cells, protect the sheet with the right options, hide formulas, protect workbook structure, allow ranges for…
Read article →MDETERM Function in Excel: Determinant of a Matrix
MDETERM Function in Excel: Determinant of a Matrix
MDETERM returns the determinant. Zero means the equations have no unique solution.
Read article →Excel Data Validation: Stop Bad Data Before It Gets In
Excel Data Validation: Stop Bad Data Before It Gets In
Use Excel Data Validation to block wrong entries: drop-down lists, whole numbers, date ranges, text length, and custom formula rules for PAN, mobile numbers,…
Read article →MINVERSE Function in Excel: Inverse of a Matrix
MINVERSE Function in Excel: Inverse of a Matrix
MathLevel: ExpertAvailable in: Excel 2007+MINVERSE inverts a square matrix — with MMULT it solves simultaneous.
Read article →DEC2OCT Function in Excel: Decimal to Octal
DEC2OCT Function in Excel: Decimal to Octal
DEC2OCT converts a decimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →MMULT Function in Excel: Multiply Matrices
MMULT Function in Excel: Multiply Matrices
MMULT multiplies two matrices. In practice it computes many weighted sums at once — quantities × price lists for many orders.
Read article →Dependent Drop-Down Lists in Excel (State → City, Category → Item)
Dependent Drop-Down Lists in Excel (State → City, Category → Item)
Make a second drop-down that changes with the first: INDIRECT with named ranges for any Excel, and FILTER+UNIQUE dynamic lists for Excel 365, plus…
Read article →KURT Function in Excel: How Heavy Are the Tails?
KURT Function in Excel: How Heavy Are the Tails?
KURT measures whether data has more extreme values than a normal distribution (positive) or fewer (negative).
Read article →