SLOPE Function in Excel: How Fast a Trend Rises
SLOPE returns the slope of the best-fit straight line — “sales grow by about ₹42,000 a month”.
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 →TRIMMEAN Function in Excel: Average That Ignores Extremes
TRIMMEAN Function in Excel: Average That Ignores Extremes
TRIMMEAN drops a share of the highest and lowest values and averages the rest, much like judges scoring gymnastics. One giant order stops distorting…
Read article →Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Calculate depreciation in Excel with SLN, DB and custom formulas: straight-line (Companies Act), written-down value, the 180-day half-rate rule, and a complete fixed-asset schedule.
Read article →VAR.S Function in Excel: Variance of a Sample
VAR.S Function in Excel: Variance of a Sample
VAR.S is the square of STDEV.S. You rarely report it directly, but it turns up in forecasting, portfolio risk and quality-control formulas.
Read article →STDEV.P Function in Excel: Standard Deviation of a Whole Population
STDEV.P Function in Excel: Standard Deviation of a Whole Population
STDEV.P measures spread when your data is the entire group, not a sample. The P version divides by n instead of n−1, so it…
Read article →VBA Dictionary: Fast Lookups and Unique Lists in Your Macros
VBA Dictionary: Fast Lookups and Unique Lists in Your Macros
Use the Scripting.Dictionary in VBA to build unique lists, count items and replace slow VLOOKUP loops — with complete examples and early vs late…
Read article →QUARTILE.INC Function in Excel: Split Data Into Quarters
QUARTILE.INC Function in Excel: Split Data Into Quarters
QUARTILE.INC returns the minimum, the 25th, 50th or 75th percentile, or the maximum. It is the fastest way to see whether a salary band…
Read article →Build a Data Entry Form in Excel VBA (UserForm Step by Step)
Build a Data Entry Form in Excel VBA (UserForm Step by Step)
Create a clean data-entry UserForm in Excel VBA: text boxes, a dropdown, validation, saving to the next empty row and clearing the form —…
Read article →Debtors Ageing Report in Excel: 0–30, 31–60, 61–90 and 90+ Days
Debtors Ageing Report in Excel: 0–30, 31–60, 61–90 and 90+ Days
Build an accounts-receivable ageing report in Excel from an invoice list: days outstanding, ageing buckets with a lookup table, a pivot by customer, and…
Read article →Excel Solver: Find the Best Answer (Budgets, Staffing, Product Mix)
Excel Solver: Find the Best Answer (Budgets, Staffing, Product Mix)
Use Excel’s free Solver add-in to maximise profit or minimise cost under constraints — a product-mix example with step-by-step settings and how to read…
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 →