MASTERING EXCEL-WEEKDAY-8PM-4TH DEC-23 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

MASTERING EXCEL-WEEKDAY-8PM-4TH DEC-23

Topics for this course

104 Lessons

CLASS-1-WHY MIS & DATA ANALYTICS

WHY MIS & DATA ANALYTICS00:35:42

CLASS-2-EXCEL INTERFACE & OPTIONS

CLASS-3-PASTE SPECIAL

CLASS-4-CUSTOM FORMAT

CLASS-5-FORMULA REFERENCE & CONDITIONAL FORMATTING

CLASS-6-FORMULA VS FUNCTION-LOGICAL

CLASS-7-LOGICAL

CLASS-8-MATH-SUMIFS

CLASS-9-TEXT FUNCTION

CLASS-10-TEXT FUNCTION

CLASS-11-TEXT FUNCTION

CLASS-12-TEXT FUNCTION

CLASS-13-TEXT FUNCTION

CLASS-14-DATE FUNCTION

CLASS-15-DATE FUNCTION

CLASS-16-STATISTICAL FUNCTION

CLASS-17-STATISTICAL FUNCTION

CLASS-18-STATISTICAL FUNCTION

CLASS-19-GOTO SPEICAL-SECURITY

CLASS-20-SORTING

CLASS-21-FILTER & ADVANCED FILTER

CLASS-22-SUBTOTAL-TTC

CLASS-23-DATA VALIDATION

CLASS-24-WHAT IF ANALYSIS

CLASS-25-WHAT IF ANALYSIS

CLASS-26-WHAT IF ANALYSIS

CLASS-27-ARRAY

CLASS-28-SUMPRODUCT

CLASS-29-VLOOKUP

CLASS-30-VLOOKUP & HLOOKUP

CLASS-31-MATCH FUNCTION

CLASS-32-INDEX FUNCTION-ARRAY FORMAT

CLASS-33-INDEX EXAMPLES

CLASS-34-INDEX REFRENCE & CHOOSE FUNCTION

SKILL ENHANCER MCQ TEST QUESTIONS

CLASS-35-INDIRECT

CLASS-36-OFFSET

CLASS-37-OFFSET

CLASS-38-PIVOT TABLE-1

EXTRAZ-MATH FUNCTION

CLASS-39-PIVOT TABLE-2

CLASS-40-PIVOT TABLE-3

CLASS-41-PIVOT TABLE-4

CLASS-42-PIVOT TABLE-5

CLASS-43-CHART

CLASS-44-CHART

CLASS-45-DASHBOARD

CLASS-46-DASHBOARD

CLASS-47-DASHBOARD & ADV. CONDITIONAL FORMATTING

CLASS-48-SALES MINI DASHBOARD

CLASS-49-KPI DASHBOARD

CLASS-50-OFFICE 365

CLASS-51-OFFICE 365

4,999.00
  • Course level: Expert