EXCEL LEADER
THIS CHANNEL IS ALL ABOUT LEARNING EXCEL AND BECOMING A PRO IN USING EXCEL IN YOUR DAILY LIFE
WE HOPE YOU ENJOY OUR VIDEOS AND ALSO LEARN FROM THEN
IN EVERY VIDEO WE WILL TRY TO TEACH YOU SOMETHING NEW AND SOMETHING DIFFERENT
The first playlist on the channel - "EXCEL FORMULAS & ITS FUNCTIONALITY" is all about using formulas commonly used in Excel.
The second playlist on the channel - "EXCEL TIPS & TRICKS" - is all about smart ways to optimize your work in Excel by basic tips.
VIDEOS MADE BY EXCEL LEADER (YOUTUBE CHANNEL)
THANKS FOR WATCHING THE VIDEOS PLEASE LIKE SHARE AND SUBSCRIBE AND ALSO SHARE YOUR FEEDBACK IN THE COMMENT SECTION
ALSO TURN ON THE NOTIFICATIONS BY CLICKING THE BELL ICON AFTER YOU SUBSCRIBE TO KNOW WHENEVER WE POST A NEW VIDEO
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
EXCEL FORMULA #97 (MROUND) # Very Useful to round the number, output will be in desired multiples
EXCEL FORMULA #96 (ROUND) # Very Useful to Round the numbers as per specified decimal points
EXCEL FORMULA #95 (RAND) # Very Useful to fill random number between 0 to 1
EXCEL FORMULA #94 (RANDBETWEEN) # Very Useful to fill / find random number between specified limits
EXCEL FORMULA #93 (ODD) # Very Useful to convert a number to the nearest ODD integer
EXCEL FORMULA #92 (EVEN) # Very Useful to convert a number to the nearest EVEN integer