LN Function in Excel: Natural Logarithm
LN is the logarithm with base e. Finance uses it for continuously compounded (log) returns.
Read article →LOG Function in Excel: Logarithm to Any Base
LOG Function in Excel: Logarithm to Any Base
LOG answers “what power gives this number?” — how many doublings, how many digits.
Read article →SUMSQ Function in Excel: Sum of Squares
SUMSQ Function in Excel: Sum of Squares
SUMSQ squares each value and adds them up — the building block of error measures such as RMSE.
Read article →ODD Function in Excel: Round Up to an Odd Number
ODD Function in Excel: Round Up to an Odd Number
ODD rounds away from zero to the next odd integer — for example committee sizes that must avoid tied votes.
Read article →Python: Sort a Messy Downloads Folder by Year and Month
Python: Sort a Messy Downloads Folder by Year and Month
A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before…
Read article →EVEN Function in Excel: Round Up to an Even Number
EVEN Function in Excel: Round Up to an Even Number
EVEN rounds away from zero to the next even integer — handy when items come in pairs.
Read article →DAYS Function in Excel: Days Between Two Dates
DAYS Function in Excel: Days Between Two Dates
DAYS returns the number of days between two dates. Subtracting the dates (=B2-A2) gives the same answer.
Read article →LCM Function in Excel: Least Common Multiple
LCM Function in Excel: Least Common Multiple
LCM finds the smallest number all inputs divide into — when two repeating schedules line up again.
Read article →YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.
Read article →WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY returns the date that is a number of working days before or after a start date, skipping weekends and holidays.
Read article →GCD Function in Excel: Greatest Common Divisor
GCD Function in Excel: Greatest Common Divisor
GCD returns the largest number that divides all inputs — for simplifying ratios and finding pack sizes.
Read article →NETWORKDAYS Function in Excel: Working Days Between Two Dates
NETWORKDAYS Function in Excel: Working Days Between Two Dates
NETWORKDAYS counts Monday–Friday working days between two dates, optionally excluding a holiday list. NETWORKDAYS.INTL lets you choose the weekend.
Read article →