Excel, SAP, Oracle & automation tips — plus wacky facts
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Find each customer’s most recent order date, last price paid or latest status with MAXIFS, XLOOKUP search-from-last, SORTBY+UNIQUE and LOOKUP(2,1/…) — so duplicates show…
Read article →Calculate due dates N working days ahead, count working days per month, handle Sunday-only or Friday–Saturday weekends, and keep a holiday list — with…
Read article →COVAR returns the population covariance. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →One #N/A ruins a SUM. Ignore errors with AGGREGATE, SUMIF and IFERROR inside arrays, count the errors so they stay visible, and know when…
Read article →TDIST gives a one- or two-tailed t probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →HEX2OCT converts a hexadecimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →T.DIST.2T turns a t statistic into a two-tailed p-value, the usual one for 'is there any difference?'.
Read article →StatisticsLevel: ExpertAvailable in: Excel 2010+T.DIST.RT gives the right-tailed t probability, for 'is it greater?' tests.Syntax=T.DIST.RT(x.
Read article →TANH returns the hyperbolic tangent; also an activation function in neural networks.
Read article →CHIINV returns the chi-square critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →Maths & trigLevel: ExpertAvailable in: Excel 2013+CSC returns 1/SIN(x).Syntax=CSC(number)ArgumentWhat it meansnumberValue (angles in.
Read article →Maths & trigLevel: ExpertAvailable in: Excel 2013+COT returns 1/TAN(x).Syntax=COT(number)ArgumentWhat it meansnumberValue (angles in.
Read article →
