559 подписчиков
149 видео
EXCEL FORMULA #74 (MID) # Very Useful to Extract Middle letter (s) as per our requirement from text
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 FORMULA #88 (DOLLAR) # Useful to represent number with currency symbol & format as per region
EXCEL TIPS & TRICKS #7 (FILL JUSTIFY) # Very useful to adjust / justify text in cells or range
EXCEL TIPS & TRICKS #27 (3D REFERENCE) # VERY USEFUL TO MAKE REFERENCE FROM MULTIPLE SHEETS
EXCEL FORMULA #87 (TEXTJOIN) # Very Useful to Join a list or various text string with a delimiter
EXCEL FORMULA #94 (RANDBETWEEN) # Very Useful to fill / find random number between specified limits
EXCEL FORMULA #99 (ROUNDDOWN) # Very Useful to round the number towards downside near to zero
EXCEL TIPS & TRICKS #24 (INSERT DATE OR TIME) # USEFUL TO INSERT STATIC Or DYNAMIC DATE / TIME
EXCEL FORMULA #91 (VALUE) # Very Useful to represent text to a number
EXCEL FORMULA #45 (TIMEVALUE)
EXCEL FORMULA #81 (REPLACE) # Very Useful to replace part of any text string with new one
EXCEL FORMULA #98 (ROUNDUP) # Very Useful to round the number towards upside away from zero
EXCEL TIPS & TRICKS #25 (SHOW FORMULA) # USEFUL TO SHOW ALL THE FORMULA IN ONE GO, USED IN WORKSHEET
EXCEL TIPS & TRICKS #26 (FIND THE DIFFERENCE) # VERY USEFUL TO FIND THE DIFFERENCE IN OUR DATA SET
EXCEL TIPS & TRICKS #28 (GOAL SEEK) # VERY USEFUL TO FIND INPUT TO ACHIEVE DESIRED GOAL
EXCEL FORMULA #95 (RAND) # Very Useful to fill random number between 0 to 1
EXCEL FORMULA #7 (MAXIFS) # Useful to find maximum value in data range with more than 1 condition
EXCEL SHORTCUTS GROUP #2 (CTRL + 1 FUNCTION KEY)# Useful to speedup our excel working & timesaving
EXCEL FORMULA #33 (ISOWEEKNUM) # Very useful to check / calculate week number as per ISO
EXCEL FORMULA #92 (EVEN) # Very Useful to convert a number to the nearest EVEN integer
EXCEL FORMULA #90 (NUMBERVALUE) # Very Useful to represent number removing comma/decimal separator
EXCEL SHORTCUTS GROUP #6 (FUNCTION KEYS) # Useful to speedup our excel working & timesaving
