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

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 #113 (SQRT) # VERY USEFUL TO COMPUTE SQUARE ROOT OF A NUMBER

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

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

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

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

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

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

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

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

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

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

EXCEL FORMULA #108 (SUBTOTAL) # Useful to apply various functions on filtered list / data range

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

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

EXCEL FORMULA #105 (SUM) # Very Useful to compute sum of various Numbers/ranges/arrays

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

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

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

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

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

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

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