Mastering Excel-Weekday-7PM-2nd June 2025 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

Mastering Excel-Weekday-7PM-2nd June 2025

Topics for this course

104 Lessons

CLASS-1-EXCEL INTRO & PASTE SPECIAL

PASTE SPECIAL00:00:00
RESOURCES-PASTE SPECIAL

CLASS-2-EXCEL CELL REFERENCE

CLASS-3-RECAP & MCQ

CLASS-4-CONDITIONAL FORMATING

CLASS-5-FORMULA VS FUNCTION

CLASS-6-LOGICAL FUNCTION

CLASS-7-LOGICAL FUNCTION

CLASS-8-LOGICAL FUNCTION

CLASS-9-MATH FUNCTION

CLASS-10-MATH FUNCTION

CLASS-11-TEXT FUNCTION

CLASS-12-TEXT FUNCTION

CLASS-13-TEXT FUNCTION

CLASS-14-TEXT FUNCTION

CLASS-15-DATE FUNCTION

CLASS-16-DATE FUNCTION

CLASS-17-STATISTICAL FUNCTION

CLASS-18-STATISTICAL FUNCTION

CLASS-19-STATISTICAL-INFORAMTION

CLASS-20-SECURITY-NAMING RANGE

CLASS-21-SORTING

ASSIGNMENT-CORE EXCEL

CLASS-22-FILTER & ADVANCED FILTER

CLASS-23-SUBTOTAL & TTC

CLASS-24-DATA VALIDATION

CLASS-25-WHAT IF ANALYSIS-1

CLASS-26-WHAT IF ANALYSIS-2

CLASS-27-ARRAY & SUMPRODUCT

CLASS-28-SUMPRODUCT

CLASS-29-VLOOKUP

CLASS-30-HLOOKUP-LOOKUP

CLASS-31-MATCH

CLASS-32-INDEX ARRAY FORMAT

CLASS-33-INDEX MATCH REFERENCE FORMAT

CLASS-34-INDEX MATCH

CLASS-35-CHOOSE

CLASS-36-INDIRECT

CLASS-37-RECAP

CLASS-38-OFFSET

MASTERING VLOOKUP-5O QUESTION

CLASS-39-PIVOT TABLE

CLASS-40-PIVOT TABLE

CLASS-41 PIVOT TABLE

CLASS-42-PIVOT TABLE

CLASS-43-PIVOT TABLE

CLASS-44-PIVOT TABLE RELATIONSHIP

CLASS-45-CHART

CLASS-45-COMBO CHART

CLASS-46-CHART-CUSTOM CHART

CLASS-47-DASHBOARD

CLASS-48-DASHBOARD

CLASS-49-DASHBOARD

CLASS-50-KPI DASHBOARD

CLASS-51-OFFICE 365

CLASS-52-OFFICE 365

4,999.00
  • Course level: Expert