COVAR Function in Excel: Covariance (Older Name)
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 →Atul Vij
Sum, Average or Max While Ignoring #N/A and Errors in Excel (AGGREGATE)
Sum, Average or Max While Ignoring #N/A and Errors in Excel (AGGREGATE)
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 Function in Excel: Student’s t Probability (Older Name)
TDIST Function in Excel: Student’s t Probability (Older Name)
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 Function in Excel: Hexadecimal to Octal
HEX2OCT Function in Excel: Hexadecimal to Octal
HEX2OCT converts a hexadecimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →T.DIST.2T Function in Excel: Two-Tailed t-Test p-Value
T.DIST.2T Function in Excel: Two-Tailed t-Test p-Value
T.DIST.2T turns a t statistic into a two-tailed p-value, the usual one for 'is there any difference?'.
Read article →T.DIST.RT Function in Excel: One-Tailed t p-Value (Right)
T.DIST.RT Function in Excel: One-Tailed t p-Value (Right)
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 Function in Excel: Hyperbolic Tangent
TANH Function in Excel: Hyperbolic Tangent
TANH returns the hyperbolic tangent; also an activation function in neural networks.
Read article →CHIINV Function in Excel: Chi-Square Critical Value (Older Name)
CHIINV Function in Excel: Chi-Square Critical Value (Older Name)
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 →CSC Function in Excel: Cosecant
CSC Function in Excel: Cosecant
Maths & trigLevel: ExpertAvailable in: Excel 2013+CSC returns 1/SIN(x).Syntax=CSC(number)ArgumentWhat it meansnumberValue (angles in.
Read article →COT Function in Excel: Cotangent
COT Function in Excel: Cotangent
Maths & trigLevel: ExpertAvailable in: Excel 2013+COT returns 1/TAN(x).Syntax=COT(number)ArgumentWhat it meansnumberValue (angles in.
Read article →BIN2HEX Function in Excel: Binary to Hexadecimal
BIN2HEX Function in Excel: Binary to Hexadecimal
BIN2HEX converts a binary number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →Tally & Busy Lesson 8: Busy Accounting — The Same Tasks in Busy
Tally & Busy Lesson 8: Busy Accounting — The Same Tasks in Busy
Do the same essentials in Busy accounting software: company creation, masters (accounts and items), GST setup, sales/purchase vouchers, and key reports, with the differences…
Read article →