LOG Function in Excel: Logarithm to Any Base
LOG answers “what power gives this number?” — how many doublings, how many digits.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
TREND Function in Excel: Extend a Straight-Line Trend
TREND Function in Excel: Extend a Straight-Line Trend
TREND fits a straight line and returns values on it, for existing points or new ones. In Excel 365 it spills several forecasts at…
Read article →SEARCHB Function in Excel: Search Position in Bytes
SEARCHB Function in Excel: Search Position in Bytes
TextLevel: ExpertAvailable in: Excel 2007+SEARCHB is the byte-based version of SEARCH.Syntax=SEARCHB("B",text)ArgumentWhat it meanstextText to work.
Read article →SLOPE Function in Excel: How Fast a Trend Rises
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 →FORECAST.ETS Function in Excel: Forecast With Seasonality
FORECAST.ETS Function in Excel: Forecast With Seasonality
FORECAST.ETS uses exponential smoothing and detects seasonal patterns — the engine behind Excel’s Forecast Sheet.
Read article →STEYX Function in Excel: Typical Error of a Trend Line
STEYX Function in Excel: Typical Error of a Trend Line
STEYX returns the standard error of predicted y values — roughly how far actual points sit from the trend line.
Read article →Receivables Ageing in Excel: 0–30, 31–60, 61–90, 90+ Day Buckets
Receivables Ageing in Excel: 0–30, 31–60, 61–90, 90+ Day Buckets
Build an accounts receivable ageing report: days overdue from the due date, bucket labels with IFS or a lookup table, totals per bucket and…
Read article →LN Function in Excel: Natural Logarithm
LN Function in Excel: Natural Logarithm
LN is the logarithm with base e. Finance uses it for continuously compounded (log) returns.
Read article →FORECAST.LINEAR Function in Excel: Predict a Value From a Trend
FORECAST.LINEAR Function in Excel: Predict a Value From a Trend
FORECAST.LINEAR predicts a y-value for a given x using a straight-line trend fitted to past data.
Read article →ACOSH Function in Excel: Inverse Hyperbolic Cosine
ACOSH Function in Excel: Inverse Hyperbolic Cosine
Maths & trigLevel: ExpertAvailable in: Excel 2007+ACOSH returns the inverse hyperbolic cosine (input 1 or more).Syntax=ACOSH(number)ArgumentWhat it.
Read article →EXP Function in Excel: e Raised to a Power
EXP Function in Excel: e Raised to a Power
EXP returns e^x and undoes LN. Use it to turn summed log returns back into an ordinary percentage.
Read article →Using AI to Write Excel Formulas — and How to Check Its Work
Using AI to Write Excel Formulas — and How to Check Its Work
AI assistants can draft Excel formulas and VBA in seconds, but they also make confident mistakes. How to prompt them well and a 5-step…
Read article →