EXCEL LEADER

EXCEL FORMULA #74 (MID) # Very Useful to Extract Middle letter (s) as per our requirement from text

EXCEL TIPS & TRICKS #27 (3D REFERENCE) # VERY USEFUL TO MAKE REFERENCE FROM MULTIPLE SHEETS

EXCEL FORMULA #90 (NUMBERVALUE) # Very Useful to represent number removing comma/decimal separator

EXCEL FORMULA #74 (MID) # Very Useful to Extract Middle letter (s) as per our requirement from text

EXCEL FORMULA #99 (ROUNDDOWN) # Very Useful to round the number towards downside near to zero

EXCEL FORMULA #83 (TRIM) # Very Useful to remove extra spaces from any text value

EXCEL FORMULA #91 (VALUE) # Very Useful to represent text to a number

EXCEL FORMULA #101 (INT) # Very Useful to rounds the number down to the nearest integer

EXCEL FORMULA #111 (MOD) # Very Useful to find a REMAINDER after a division operation done

EXCEL FORMULA #106 (SUMIF) # Very Useful to compute sum of various Numbers,satisfied one Condition

EXCEL SHORTCUTS GROUP #6 (FUNCTION KEYS) # Useful to speedup our excel working & timesaving

EXCEL FORMULA #112 (POWER) # Very Useful to compute the result of a number raised to a power

EXCEL TIPS & TRICKS #24 (INSERT DATE OR TIME) # USEFUL TO INSERT STATIC Or DYNAMIC DATE / TIME

EXCEL FORMULA #98 (ROUNDUP) # Very Useful to round the number towards upside away from zero

EXCEL FORMULA #103 (SUMPRODUCT) # Very Useful to compute sum of products of various ranges / arrays

EXCEL FORMULA #104 (SUMSQ) # Very Useful to compute sum of Squares of various Numbers/ranges/arrays

EXCEL FORMULA #113 (SQRT) # VERY USEFUL TO COMPUTE SQUARE ROOT OF A NUMBER

EXCEL FORMULA #114 (EXP) # VERY USEFUL TO COMPUTE e raised POWER OF A NUMBER

EXCEL TIPS & TRICKS #28 (GOAL SEEK) # VERY USEFUL TO FIND INPUT TO ACHIEVE DESIRED GOAL

EXCEL FORMULA #102 (LCM) # Very Useful to compute the LEAST COMMON MULTIPLE

EXCEL FORMULA #100 (TRUNC) # Very Useful to truncates the decimal/ fractional part of numbers

EXCEL FORMULA #107 (SUMIFS) # Useful to compute sum of various Numbers, satisfied Many Conditions

EXCEL TIPS & TRICKS #26 (FIND THE DIFFERENCE) # VERY USEFUL TO FIND THE DIFFERENCE IN OUR DATA SET

EXCEL FORMULA #109 (PRODUCT) # Very Useful to Compute multiplication of various numbers/ data range

EXCEL TIPS & TRICKS #25 (SHOW FORMULA) # USEFUL TO SHOW ALL THE FORMULA IN ONE GO, USED IN WORKSHEET

EXCEL FORMULA #110 (ROMAN) # Very Useful to convert numbers to ROMAN Numbers

EXCEL FORMULA #70 (UPPER)# Useful to convert text from lower case (Small) to upper case ( Capital )

ADVANCED EXCEL # 01 (TEXT TO COLUMN)# Very Useful Convert Data from single column to multiple column

EXCEL FORMULA

EXCEL TIPS & TRICKS #7 (FILL JUSTIFY) # Very useful to adjust / justify text in cells or range

EXCEL FORMULA #95 (RAND) # Very Useful to fill random number between 0 to 1