XOR Function in Excel: Exactly One Condition True
XOR returns TRUE when an odd number of conditions are TRUE — with two conditions, “one or the other but not both”.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
FORMULATEXT Function in Excel: Show a Formula as Text
FORMULATEXT Function in Excel: Show a Formula as Text
FORMULATEXT displays the formula of another cell — perfect for documenting models and training sheets.
Read article →EFFECT Function in Excel: Real Annual Rate With Compounding
EFFECT Function in Excel: Real Annual Rate With Compounding
EFFECT converts a nominal annual rate into the effective rate after compounding. NOMINAL does the reverse.
Read article →RATE Function in Excel: The Interest Rate Hidden in a Loan
RATE Function in Excel: The Interest Rate Hidden in a Loan
RATE works out the interest rate from the loan amount, EMI and term — useful for checking “0% EMI” and flat-rate offers.
Read article →Power Pivot and DAX: Your First Data Model and Measures
Power Pivot and DAX: Your First Data Model and Measures
Start with Power Pivot in Excel: load tables to the Data Model, create relationships, write first DAX measures (SUM, DIVIDE, CALCULATE), build a pivot…
Read article →PERCENTILE Function in Excel: k-th Percentile (Older Name)
PERCENTILE Function in Excel: k-th Percentile (Older Name)
PERCENTILE returns the k-th percentile (inclusive). It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →CORREL Function in Excel: How Strongly Two Things Move Together
CORREL Function in Excel: How Strongly Two Things Move Together
CORREL returns a number between −1 and 1: near 1 means both rise together, near −1 means one falls as the other rises, near…
Read article →PERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th)
PERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th)
PERCENTILE.INC returns the value below which a given percentage of data falls — for salary bands, delivery-time targets and outliers.
Read article →STDEV.S Function in Excel: How Spread Out Are the Numbers?
STDEV.S Function in Excel: How Spread Out Are the Numbers?
STDEV.S measures how far values typically sit from the average (sample standard deviation). A small value means consistent; a large one means volatile.
Read article →POWER Function in Excel: Raise to a Power (and Growth Rates)
POWER Function in Excel: Raise to a Power (and Growth Rates)
POWER raises a number to a power; the ^ operator does the same. Its most useful business job is CAGR.
Read article →FLOOR.MATH Function in Excel: Round Down to a Multiple
FLOOR.MATH Function in Excel: Round Down to a Multiple
FLOOR.MATH rounds down to the nearest multiple — slabs, time buckets and whole units.
Read article →CEILING.MATH Function in Excel: Round Up to a Multiple
CEILING.MATH Function in Excel: Round Up to a Multiple
CEILING.MATH rounds up to the next multiple; FLOOR.MATH rounds down. Great for pricing and pack sizes.
Read article →