PMT Function in Excel: Loan EMI in One Formula
PMT calculates the fixed periodic payment for a loan — the EMI on home, car and personal loans.
Read article →Excel Functions A–Z
Every Excel function explained with syntax, examples, common errors and powerful combinations — from beginner to expert.
YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.
Read article →DATEDIF Function in Excel: Age and Tenure in Years, Months, Days
DATEDIF Function in Excel: Age and Tenure in Years, Months, Days
DATEDIF is a hidden function (not in the autocomplete list) that returns the difference between two dates in completed years, months or days.
Read article →WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday = 7, the easiest for weekend…
Read article →WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY returns the date that is a number of working days before or after a start date, skipping weekends and holidays.
Read article →TRANSPOSE Function in Excel: Flip Rows and Columns
TRANSPOSE Function in Excel: Flip Rows and Columns
TRANSPOSE turns a vertical range horizontal and vice versa, and stays linked to the source.
Read article →INDIRECT Function in Excel: Build a Reference From Text
INDIRECT Function in Excel: Build a Reference From Text
INDIRECT turns text such as "Mar!B5" into a real reference — the key to dependent dropdowns and summary sheets that switch between monthly tabs.
Read article →OFFSET Function in Excel: A Range That Moves or Resizes
OFFSET Function in Excel: A Range That Moves or Resizes
OFFSET returns a range a set number of rows and columns away, optionally with a new size. Classic for rolling totals and dynamic chart…
Read article →CHOOSE Function in Excel: Pick From a List by Number
CHOOSE Function in Excel: Pick From a List by Number
CHOOSE returns the n-th item from a list of values you type in the formula.
Read article →VALUE Function in Excel: Convert Text to a Number
VALUE Function in Excel: Convert Text to a Number
VALUE turns text that looks like a number into a real number, so SUM and lookups work.
Read article →PROPER Function in Excel: Capitalise Each Word
PROPER Function in Excel: Capitalise Each Word
PROPER capitalises the first letter of each word; UPPER and LOWER change the whole text.
Read article →REPLACE Function in Excel: Replace Characters by Position
REPLACE Function in Excel: Replace Characters by Position
REPLACE swaps characters at a given position — useful for masking.
Read article →