Excel Tutorials & Tips

TANH Function in Excel: Hyperbolic Tangent

5 Jan 2024 · Excel Functions A–Z · 1 min read

TANH Function in Excel: Hyperbolic Tangent

TANH returns the hyperbolic tangent; also an activation function in neural networks.

CHIINV Function in Excel: Chi-Square Critical Value (Older Name)

1 Jan 2024 · Excel Functions A–Z · 1 min read

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

26 Dec 2023 · Excel Functions A–Z · 1 min read

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

14 Dec 2023 · Excel Functions A–Z · 1 min read

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

10 Nov 2023 · Engineering · 1 min read

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 →

BESSELY Function in Excel: Bessel Function Yn(x)

12 Oct 2023 · Engineering · 1 min read

BESSELY Function in Excel: Bessel Function Yn(x)

EngineeringLevel: ExpertAvailable in: Excel 2007+BESSELY returns the Bessel function of the second kind (Weber/Neumann), Yn(x).Syntax=BESSELY(x.

Read article →

BESSELJ Function in Excel: Bessel Function Jn(x)

6 Oct 2023 · Engineering · 1 min read

BESSELJ Function in Excel: Bessel Function Jn(x)

BESSELJ returns the Bessel function of the first kind, Jn(x): vibrating drums, FM radio spectra and wave problems.

Read article →

Build a Monthly MIS Report in Excel From Scratch (Complete Guide)

1 Oct 2023 · Charts & Dashboards · 4 min read

Build a Monthly MIS Report in Excel From Scratch (Complete Guide)

A complete, reusable monthly MIS workbook: raw data sheets, a mapping table, SUMIFS-driven P&L and KPI pages, variance vs budget and last year, conditional…

Read article →

BESSELI Function in Excel: Modified Bessel Function In(x)

24 Sep 2023 · Engineering · 1 min read

BESSELI Function in Excel: Modified Bessel Function In(x)

BESSELI returns the modified Bessel function In(x), used in heat transfer, signal processing and vibration problems.

Read article →

BESSELK Function in Excel: Modified Bessel Function Kn(x)

15 Sep 2023 · Engineering · 1 min read

BESSELK Function in Excel: Modified Bessel Function Kn(x)

EngineeringLevel: ExpertAvailable in: Excel 2007+BESSELK returns the modified Bessel function of the second kind, Kn(x).Syntax=BESSELK(x, n)ArgumentWhat.

Read article →