Mastering EXCEL-10th July-8PM - Innozant MIS & Data Analytics & Data Science
Administrator
Expert
Description
Mastering EXCEL-10th July-8PM
Topics for this course
77 Lessons
CLASS-1-CAREER GUIDE & EXCEL INTRODUCTION
CAREER GUIDE & SQL INTRODUCTION1:21:03
RESOURCES-EXCEL INTRODUCTION
CLASS-2-PASTE SPECIAL
CLASS-3-CUSTOM FORMATTING
CLASS-4-FORMULA REFERENCE
CLASS-5-FORMUALA REFERENCE-RECAP
CLASS-6-CONDITIONAL FORMATTING
CLASS-7-CUSTOMIZED CF & FORMULA VS FUNCTION
CLASS-8-LOGICAL FUNCTION-IF & NESTED IF
CLASS-9-LOGICAL -AND OR
CLASS-10-LOGICAL RECAP
CLASS-11-LOGICAL MORE
CLASS-12-DOUBT SESSION
CLASS-13-MATH-SUMIFS FUNCTION
CLASS-14-MATH MORE EXAMPLES
CLASS-15-TEXT FUNCTION
CLASS-16-TEXT FUNCTION
CLASS-17-TEXT FUNCTION
CLASS-18-TEXT FUNCTION
CLASS-19-TEXT FUNCTION
CLASS-20-DATE FUNCTION
CLASS-21-DATE FUNCTION
CLASS-22-DATE FUNCTION
CLASS-23-STATISTICAL FUNCTION
CLASS-24-STATISTICAL FUNCTION
CLASS-25-STATISTICAL FUNCTION
CLASS-26-STATISTICAL FUNCTION
CLASS-27-DATABASE & INFORMATION
CLASS-28-GOTO SPECIAL & ERROR WORLD
CLASS-29-SECURITY
CLASS-30-NAMING RANGE & SORTING
CLASS-31-FILTER & ADV FILTER
CLASS-32-SUBTOTAL
CLASS-33-TEXT TO COLUMN & FLASH FILL
CLASS-34-DATA VALIDATION
CLASS-35-WORKING WITH EXTERNAL DATA
CLASS-36-DATA CONSOLIDATION-GOAL SEEK
CLASS-37-SOLVER-DATA TABLE
CLASS-38-ARRAY FUNCTION
CLASS-39-SUMPRODUCT FUNCTION
Knowledgeable