EXCEL-WE-10AM-11 FEB - Innozant MIS & Data Analytics & Data Science

Prerna Kumari Intermediate

Topics for this course

87 Lessons

CLASS-1-EXCEL INTRODUCTION & PASTE SPECIAL

EXCEL INTRODUCTION & PASTE SPECIAL2:23:05
RESOURCES-EXCEL INTRODUCTION & PASTE SPECIAL

CLASS-2-EXCEL FORMULAREFERENCE

CLASS-3-EXCEL CONDITIONAL FORMATTING

CLASS-4-EXCEL FORMULA VS FUNCTION

CLASS-5-LOGICAL FUNCTION

CLASS-6-LOGICAL & MATH FUNCTION

CLASS-7-MATH FUNCTION-2

CLASS-8-TEXT FUNCTION

CLASS-9-TEXT FUNCTION

CLASS-10-TEXT ADVANCED

CLASS-11-DATE FUNCTION

CLASS-12-STATISTICAL FUNCTION

CLASS-13-STATISTICAL FUNCTION

CLASS-14-DATABASE & INFORMATION FUNCTION

CLASS-15-GO TO SPECIAL, PRINTING, SECURITY

CLASS-16-SORTING & FILTER-ADV FILTER

CLASS-17-SUBTOTAL & TTC

CLASS-18-DATA VALIDATION

CLASS-19-WHAT IF ANALYSIS-1

CLASS-20-WHAT IF ANALYSIS-2

CLASS-21-ARRAY & SUMPRODUCT-1

CLASS-22-ARRAY & SUMPRODUCT-2

CLASS-23-LOOKUP & REFERENCE-VLOOKUP-HLOOKUP

CLASS-24-HLOOKUP-LOOKUP-MATCH

CLASS-25-INDEX MATCH-ARRAY FORMAT

CLASS-26-INDEX MATCH-REFERENCE FORMAT

CLASS-27-CHOOSE & INDIRECT FUNCTION

CLASS-28-INDIRECT & OFFSET FUNCTION

CLASS-29-OFFSET & MASTERING VLOOKUP RECAP

CLASS-30-PIVOT TABLE-1

CLASS-31-PIVOT TABLE-2

CLASS-32-PIVOT TABLE-3

CLASS-33-PIVOT TABLE-4-ADVANCED

CLASS-34-CHART & GRAPH

CLASS-35-CHART & GRAPH

CLASS-36-DASHBOARD-1

CLASS-37-DASHBOARD-2

CLASS-38-DASHBOARD-3

CLASS-39-OFFICE 365

CLASS-40-OFFICE 365

4,999.00
  • Course level: Intermediate