NPV Function in Excel: Net Present Value of Future Cash Flows
NPV discounts future cash flows to today’s value at a given rate — the core of investment appraisal.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
PMT Function in Excel: Loan EMI in One Formula
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 →COUNTBLANK Function in Excel: Count Empty Cells
COUNTBLANK Function in Excel: Count Empty Cells
Count the number of empty cells in a range, essential for identifying missing records, incomplete audit checklists, and data hygiene gaps.
Read article →MEDIAN Function in Excel: The Middle Value
MEDIAN Function in Excel: The Middle Value
Calculate the statistical median (exact middle value) of a numeric dataset, providing a realistic baseline unaffected by extreme outliers.
Read article →MOD Function in Excel: Remainder After Division
MOD Function in Excel: Remainder After Division
Calculate the remainder after dividing a number by a divisor, powering alternating row formatting, time calculations, and cyclic patterns.
Read article →MROUND Function in Excel: Round to the Nearest Multiple
MROUND Function in Excel: Round to the Nearest Multiple
MROUND rounds to the nearest multiple you choose — prices to ₹5, times to 15 minutes.
Read article →SUMIF Function in Excel: Sum Values That Meet One Condition
SUMIF Function in Excel: Sum Values That Meet One Condition
Calculate the total of numbers in a range that meet a specific condition, text match, date criteria, or logical comparison.
Read article →MIN Function in Excel: Smallest Value in a Range
MIN Function in Excel: Smallest Value in a Range
StatisticalLevel: BeginnerAvailable in: Excel 2007+MIN returns the smallest number in a set of values, ignoring text and blanks.Syntax=MIN(number1.
Read article →TODAY Function in Excel: Current Date That Updates Every Day
TODAY Function in Excel: Current Date That Updates Every Day
Return the current calendar date in your spreadsheet, updating automatically every time the workbook is recalculated or reopened.
Read article →IFERROR Function in Excel: Replace Errors With Something Friendly
IFERROR Function in Excel: Replace Errors With Something Friendly
Catch and handle formula errors cleanly across your spreadsheet, replacing ugly #N/A, #VALUE!, and #DIV/0! alerts with custom fallbacks.
Read article →OR Function in Excel: TRUE When Any Condition Is Met
OR Function in Excel: TRUE When Any Condition Is Met
LogicalLevel: BeginnerAvailable in: Excel 2007+OR returns TRUE if at least one condition is TRUE.Syntax=OR(logical1, [logical2], ...)ArgumentWhat it.
Read article →AND Function in Excel: TRUE Only When All Conditions Are Met
AND Function in Excel: TRUE Only When All Conditions Are Met
AND returns TRUE when every condition is TRUE. It is almost always used inside IF.
Read article →