Learn Excel

This set of tutorial on excel is designed to make excel learning quick and easy.  lets get started with excel tutorial

excel tutorial

Excel DATE Function: Excel DATE Function converts supplied Arguments Year, month and day into an Excel date.

DATEVALUE Function in Excel: DATEVALUE Function in Excel, converts a date in text format to a Serial Number that represent particular date in Excel.

DAYS Function in Excel: DAYS Function in Excel returns the number of days between two dates.

DAYS360 Function in Excel: The DAYS360 function in Excel returns the number of days between two dates based on a 360-day year (12 x 30 months).

EDATE Function in Excel: EDATE Function in Excel returns the date, which is specified number of months before or after the input start date.

DATEDIF Function in Excel: The DATEDIF function in Excel returns the difference between two date values in years, months, or days.

YEAR Function in Excel : YEAR function in Excel returns the four digit year when date is given as an input.

YEARFRAC Function in Excel: YEARFRAC Function in Excel returns the difference between two dates in year as a decimal value

NOW Function in Excel: NOW Function in Excel returns the current date and time.

TODAY Function in Excel: TODAY Function in Excel returns the current date.

Excel TIME Function: Excel TIME Function converts supplied Arguments Hours, Minutes and Seconds into an Excel time.

TIMEVALUE Function in Excel: TIMEVALUE Function in Excel, converts a TIME in text format to a decimal Number

HOUR Function in Excel: HOUR Function in excel returns Hour by taking time as input. Value returned by HOUR Function is number between 0 and 23 as it uses 24 hour format.

MINUTE Function in Excel: MINUTE Function in excel returns Minute by taking time as input. Value returned by MINUTE Function is number between 0 and 59.

SECOND Function in Excel: SECOND Function in excel returns Second by taking time as input. Value returned by SECOND Function is number between 0 and 59.

DAY Function in Excel: DAY function in Excel returns the day part of the date by taking date as input.

MONTH Function in Excel: MONTH function in Excel returns the month part of the date, when date is given as an input.

WEEKDAY Function in Excel: WEEKDAY Function in Excel takes the date as input and returns the day of the week.

WEEKNUM Function in Excel: The WEEKNUM function in Excel takes a date and returns a week number (1-54) that corresponds to the week of year.

ISOWEEKNUM Function in Excel: ISOWEEKNUM function in Excel takes a date as input and returns a week number (1-54).

WORKDAY Function in Excel: The WORKDAY function in Excel takes a date as input and returns the nearest working day in the future or past, based on days value you provide.

WORKDAY.INTL Function in Excel: The WORKDAY.INTL Function in Excel takes a date as input and returns the nearest working day in the future or past, based on days value you provide. It is similar to WORKDAY Function in addition to that WORKDAY.INTL Function allows you to customize which days are considered weekends (non-working days).

NETWORKDAYS Function in Excel: NETWORKDAYS Function in Excel calculates the number of working days between two dates.

NETWORKDAYS.INTL Function in Excel: NETWORKDAYS.INTL Function in Excel calculates the number of working days between two dates. You can also exclude holidays. It is similar to NETWORKDAYS Function in addition to that NETWORKDAYS.INTL Function allows you to customize which days are considered weekends (non-working days).

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.

Tutorial on Excel Engineering Functions 1

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)=exeyi= ex(cos y + i sin y)

 

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

Tutorial on Excel Engineering Functions 2

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

Tutorial on Excel Engineering Functions 3

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).

 

ISERROR Function in Excel: ISERROR Function in Excel identifies the Excel Errors, ISERROR Function in Excel returns TRUE if the Excel Error is identified, if not returns FALSE.

ISERR Function in Excel: ISERR Function in Excel identifies the Excel Errors Except #N/A, ISERR Function in Excel returns TRUE if the Excel Error is identified except #N/A , if not returns FALSE.

ISNA Function in Excel: The ISNA function in Excel, tests if an supplied expression or Value returns the Excel #N/A Error, and if so, returns TRUE, If not the function returns FALSE.

ISNUMBER Function in Excel: The ISNUMBER function in Excel, tests if an supplied expression or Value returns the number, and if so, returns TRUE, If not the function returns FALSE.

ISEVEN Function in Excel: ISEVEN Function in Excel tests if a supplied number (or numeric expression) evaluates to an even number, if so then the Function returns TRUE, if not the function returns FALSE.

ISODD Function in Excel: ISODD Function in Excel tests if a supplied number (or numeric expression) evaluates to an odd number, if so then the Function returns TRUE, if not the function returns FALSE.

ISBLANK Function in Excel: ISBLANK Function in Excel tests if a specified cell is blank (empty) and if so, returns TRUE, if not the function returns FALSE.

ISLOGICAL Function in Excel: ISLOGICAL Function in Excel tests if a supplied value or expression returns a logical value(i.e. TRUE or FALSE). If so the ISLOGICAL Function returns TRUE, if not the function returns FALSE.

ISTEXT Function in Excel: ISTEXT Function in Excel tests if a supplied value has text. If so the ISTEXT Function returns TRUE, if not the function returns FALSE.

ISNONTEXT Function in Excel: ISNONTEXT Function in Excel tests if a supplied value has text. If the supplied value has text then ISNONTEXT Function returns FALSE, if not the function returns TRUE.

ISREF Function in Excel: ISREF Function in Excel tests if a supplied value is a reference. If the supplied value is reference then ISREF Function returns TRUE, if not the function returns FALSE.

ISFORMULA Function in Excel: ISFORMULA Function in Excel tests if a supplied cell has formula in it. If the supplied cell has any formula then ISFORMULA Function returns TRUE, if not the function returns FALSE.

ABS Function in Excel: ABS function in Excel returns the absolute value (modulus) of a number.

SIGN function in Excel: SIGN function in Excel returns the arithmetic sign of a supplied number. If the number is positive, the SIGN function returns +1, if the number is negative, the function returns -1.

GCD function in Excel: GCD function in Excel returns the greatest common divisor of two or more supplied integers.

LCM function in Excel: LCM function in Excel returns the Least Common Multiple of two or more supplied integers.

SUM function in Excel: SUM function in Excel returns the sum of values supplied as multiple arguments.

PRODUCT function in Excel: PRODUCT function in Excel returns the product of values supplied as multiple arguments.

POWER function in Excel: POWER function in Excel returns a number raised to a given power.

SQRT function in Excel: SQRT function in excel returns the square root of a number, when it is positive. SQRT returns an error if number is negative.

QUOTIENT function in Excel: QUOTIENT function in Excel returns the integer portion of Division .i.e. Quotient portion of division.

MOD Function in Excel: The MOD function in Excel returns the remainder of the division when number and divisor is passed as input.

CEILING Function in Excel: The CEILING function in Excel rounds a supplied number away from zero, to the nearest multiple of a given number.

CEILING.PRECISE Function in Excel: CEILING.PRECISE Function rounds a supplied number up (regardless of the significance’s sign), to the nearest multiple of a given number.

ISO.CEILING Function in Excel: ISO.CEILING Function rounds a supplied number up (regardless of the significance’s sign), to the nearest multiple of a given number. (According to ISO standards).

CEILING.MATH Function in Excel: CEILING.MATH Function rounds a supplied number up (regardless of the significance’s sign), to the nearest multiple of a given number with additional input of another variable called mode.

EVEN Function in Excel: EVEN function in Excel returns the next even integer after rounding a given number up. Please note that EVEN function always rounds numbers up (away from zero).

ODD Function in Excel: ODD function in Excel returns the next odd integer after rounding a given number up. Please note that odd function always rounds numbers up (away from zero).

FLOOR Function in Excel: The FLOOR function in Excel rounds a supplied number towards zero, to the nearest multiple of a given number. FLOOR Function takes up two arguments the Number to be rounded off and significance to which the level of rounding has to be done.

FLOOR.PRECISE Function in Excel: FLOOR.PRECISE Function rounds a supplied number down(regardless of the significance’s sign), to the nearest multiple of a given number.

FLOOR.MATH Function in Excel: FLOOR.MATH Function rounds down a supplied number (regardless of the significance’s sign), to the nearest multiple of a given number with additional input of another variable called mode.

The INT function in Excel: The INT function in Excel round downs a supplied number to the nearest integer.

MROUND Function in Excel: MROUND Function in Excel rounds the number up or down to the nearest multiple of the supplied argument.

ROUND Function in Excel: ROUND Function in Excel Round off the number to the specified decimal places.

ROUNDDOWN Function in Excel: ROUNDDOWN Function in Excel Rounds down the number to the specified decimal places.

ROUNDUP Function in Excel: ROUNDUP Function in Excel Rounds up the number to the specified decimal places.

TRUNC Function in Excel: TRUNC Function in Excel truncates the number to the specified decimal places. If nothing is specified then TRUNC function truncates the number to a integer(truncates the decimal places).

MDETERM Function in Excel: MDETERM Function in Excel calculates the determinant value of a square matrix.

MINVERSE Function in Excel: MINVERSE Function in Excel calculates the inverse of a square matrix.

MMULT Function in Excel: MMULT Function in Excel calculates the multiplication or product of two matrices.

MUNIT Function in Excel: MUNIT Function in Excel creates a unit matrix of specified dimension.

RAND Function in Excel: RAND function in Excel generates a random real number between 0 and 1.  With the Help of RAND Function we can also generate a random real number using the formula

RAND( ) * (b – a) + a

RANDBETWEEN Function in Excel: RANDBETWEEN Function in Excel generates a random integer between two given numbers (integers).

 

SUMPRODUCT function in Excel: SUMPRODUCT Function in Excel calculates and returns the sum of the products of Arrays that has been passed as input.

 

SUMSQ function in Excel: SUMSQ Function in Excel calculates and returns the sum of squares of numbers that has been passed as input.

 

SUMX2MY2 function in Excel: SUMX2MY2 Function in Excel calculates and returns the sum of differences of squares of numbers that has been passed as input.

Excel Mathematical Functions 1

 

SUMX2PY2 Function in Excel: SUMX2PY2 Function in Excel calculates and returns the sum of the sum of squares of numbers that has been passed as input.

Excel Mathematical Functions 2

 

SUMXMY2 Function in Excel: SUMXMY2 Function in Excel calculates and returns the sum of the squares of differences of numbers that has been passed as input.

Excel Mathematical Functions 3

 

SERIESSUM Function in Excel: SERIESSUM Function in Excel returns the sum of power series as shown below

Excel Mathematical Functions 4

 

Lets get started

python basics tutorial