Excel for Finance Lesson 6: Budget vs Actual With Variances
Build a budget vs actual report: variance and variance %, favourable/adverse logic that differs for income and costs, conditional formatting, largest variances, and a…
Read article →Atul Vij
Excel for Finance Lesson 5: 13-Week Cash Flow Forecast
Excel for Finance Lesson 5: 13-Week Cash Flow Forecast
Build a rolling 13-week cash flow forecast in Excel: weekly collections and payments, running closing balance, minimum-cash alerts, the lowest point, and how to…
Read article →RECEIVED Function in Excel: Amount Received at Maturity
RECEIVED Function in Excel: Amount Received at Maturity
FinancialLevel: ExpertAvailable in: Excel 2007+RECEIVED calculates what you get back at maturity for a discounted security.Syntax=RECEIVED(settlement.
Read article →PDURATION Function in Excel: Years Needed to Reach a Target
PDURATION Function in Excel: Years Needed to Reach a Target
PDURATION returns how many periods an investment needs to grow to a target at a given rate (lump sum, no regular payments).
Read article →HARMEAN Function in Excel: The Right Average for Rates
HARMEAN Function in Excel: The Right Average for Rates
HARMEAN averages rates properly. Drive 60 km/h one way and 40 km/h back, and your average speed is 48, not 50.
Read article →SEC Function in Excel: Secant
SEC Function in Excel: Secant
Maths & trigLevel: ExpertAvailable in: Excel 2013+SEC returns 1/COS(x).Syntax=SEC(number)ArgumentWhat it meansnumberValue (angles in.
Read article →GEOMEAN Function in Excel: Average Growth Rate
GEOMEAN Function in Excel: Average Growth Rate
GEOMEAN multiplies values and takes the n-th root. For growth rates it gives the honest average: +50% followed by −50% is not an average…
Read article →Remove Duplicates in Excel: 3 Quick Ways (and Which to Use)
Remove Duplicates in Excel: 3 Quick Ways (and Which to Use)
Remove or find duplicates in Excel three ways: the Remove Duplicates button, Advanced Filter unique records, and UNIQUE/COUNTIF formulas. Which to use when, how…
Read article →INTRATE Function in Excel: Interest Rate of a Fully Invested Security
INTRATE Function in Excel: Interest Rate of a Fully Invested Security
INTRATE returns the annualised return when you invest an amount and receive a larger amount at maturity, with nothing in between.
Read article →NPER Function in Excel: How Many Payments Until Paid Off
NPER Function in Excel: How Many Payments Until Paid Off
NPER returns the number of periods needed to repay a loan or reach a savings goal.
Read article →Look Up the 2nd, 3rd or Nth Match in Excel
Look Up the 2nd, 3rd or Nth Match in Excel
VLOOKUP only finds the first match. Return a customer’s Nth order, the first N rows, the last match or the Nth largest per group…
Read article →PV Function in Excel: What a Future Amount Is Worth Today
PV Function in Excel: What a Future Amount Is Worth Today
PV returns today's value of future payments at a discount rate — how much loan an EMI can support, or what an annuity is…
Read article →