In this tutorial we will learn the list of Excel Engineering functions and how to effectively utilize the Engineering functions for the desired purpose of that we require.

**BIN2DEC Function in Excel: **BIN2DEC Function in Excel converts Binary number to a decimal number.

**BIN2HEX Function in Excel: **BIN2HEX Function in Excel converts Binary number to a Hexadecimal number.

**BIN2OCT Function in Excel: **BIN2OCT Function in Excel converts Binary number to octal number.

**DEC2BIN Function in Excel: **DEC2BIN Function in Excel converts Decimal number to Binary number.

**DEC2HEX Function in Excel: **DEC2HEX Function in Excel converts Decimal number to Hexadecimal number.

**DEC2OCT Function in Excel: **DEC2OCT Function in Excel converts Decimal number to Octal number.

**HEX2BIN Function in Excel: **HEX2BIN Function in Excel converts Hexadecimal number to Binary number.

**HEX2DEC Function in Excel: **HEX2DEC Function in Excel converts Hexadecimal number to Decimal number.

**HEX2OCT Function in Excel: **HEX2OCT Function in Excel converts Hexadecimal number to Octal number.

**OCT2BIN Function in Excel: **OCT2BIN Function in Excel converts Octal number to Binary number.

**OCT2DEC Function in Excel: **OCT2DEC Function in Excel converts Octal number to Decimal number.

**OCT2HEX Function in Excel: **OCT2HEX Function in Excel converts Octal number to Hexadecimal number.

**BITAND Function in Excel: **BITAND Function in Excel returns the bitwise ‘AND’ for two supplied integers.

**BITOR Function in Excel: **BITOR Function in Excel returns the bitwise ‘OR’ for two supplied integers.

**BITXOR Function in Excel: **BITXOR Function in Excel returns the bitwise Exclusive OR, ‘XOR’ for two supplied integers.

**BITLSHIFT Function in Excel: **BITLSHIFT Function in Excel returns the left shift of supplied integers by specified number of bits.

**BITRSHIFT Function in Excel: **BITRSHIFT Function in Excel returns the right shift of supplied integers by specified number of bits.

**DELTA Function in Excel: **DELTA Function in Excel tests the equality of two numbers. DELTA Function returns 1 if the two supplied numbers are equal and returns 0 if two of the numbers are not equal.

**GESTEP Function in Excel: **GESTEP Function in Excel tests whether a supplied number is greater than or equal to the certain threshold. GESTEP Function returns **1**, if supplied number is greater than or equal to threshold [step].GESTEP Function returns **0.**

**COMPLEX Function in Excel: ** COMPLEX Function in Excel takes two arguments, representing the real and the imaginary coefficients of a complex number, and creates a complex number.

**IMABS Function in Excel: **IMABS Function in Excel returns the absolute value (the modulus) of a complex number.

**IMAGINARY Function in Excel: **IMAGINARY Function in Excel returns the imaginary coefficient of a complex number.

The imaginary coefficient of the complex number, z = x + iy is **y**

**IMCONJUGATE Function in Excel: **IMCONJUGATE Function in Excel returns the complex conjugate of a supplied complex number.

The complex conjugate of the complex number, z = x + iy is **x-iy**

**IMEXP Function in Excel: **IMEXP Function in Excel returns the exponential of a supplied complex number.

The exponential of a complex number z = x + iy is calculated by the equation,

**e ^{(x+iy)}=e^{x}e^{yi}= e^{x}(cos y + i sin y)**

**IMLN Function in Excel: **IMLN Function in Excel returns the Natural Logarithm of a supplied complex number.

**IMLOG10 Function in Excel: **IMLOG10 Function in Excel returns the common (base 10) logarithm of a supplied complex number.

**IMLOG2 Function in Excel: **IMLOG2 Function in Excel returns the base 2 logarithm of a supplied complex number.

**IMREAL Function in Excel: **IMREAL Function in Excel returns the real coefficient of a complex number.

**The real coefficient of the complex number, z = x + iy is x**

**IMSQRT Function in Excel: **IMSQRT Function in Excel returns the square root of a complex number.

**IMPOWER Function in Excel: **IMPOWER Function in Excel returns the power of a complex number. i.e a supplied complex number raised to given power.

**IMSUM Function in Excel: **IMSUM Function in Excel returns the sum of two or more complex numbers. IMSUM Function can add up to 255 complex numbers.

**The sum of two complex numbers a+bi and c+di is:(a+bi) + (c+di) = (a+c) + (b+d)i**

**IMPRODUCT Function in Excel: **IMPRODUCT Function in Excel returns the product of two or more complex numbers. IMPRODUCT Function can multiply up to 255 complex numbers.

**The product of two complex numbers a+bi and c+di is: (a+bi) * (c+di) = (ac-bd) + (ad+bc)i**

**IMSUB Function in Excel: **IMSUB Function in Excel returns the difference of two complex numbers .(i.e. subtracts one complex number from another).

**The difference of two complex numbers a+bi and c+di is:(a+bi) – (c+di) = (a-c) + (b-d)i**

**IMDIV Function in Excel: **IMDIV Function in Excel returns the quotient on division of two complex numbers. (i.e. divides one complex number from another).

lets get started with Tutorial on Excel Engineering Functions