267 подписчиков
35 видео
MACROS!!!! WHAT IS MACROS!!! EXCEL MACROS!!!! HOW MACROS WORKS!!!.
Conditional Formatting!!! New Rule!!! How we use Conditional Formatting!!!
GO TO !! GO TO SPECIAL !! WHAT IS GO TO SPECIAL IN EXCEL !! USE OF GO TO SPECIAL.
CELL REFERENCE IN EXCEL !! RELATIVE REFERENCE !! ABSOLUTE REFERENCE !! MIXED CELL REFERENCE.
GOOGLE SHEET TUTORIAL FOR BEGINNERS !! EXCEL !! GOOGLE ! !
NESTED IF IN MS EXCEL ! LOGIC FORMULA ! IF ! MORE THAN ONE CRITERIA.
VLOOKUP ! TRICKS ! TRUE ! FALSE !
ADVANCED FILTER - MS EXCEL
CONSOLIDATION- MS EXCEL
SUMPRODUCT,SUMSQ,SUMX2MY2,SUMX2PY2,SUMXMY2- ALL SUM FORMULA'S
PIVOT TABLE- EXCEL
TEXT TO COLUMN- EXCEL
