EXCEL-WD-7PM-12THDEC22 - Innozant MIS & Data Analytics & Data Science

A
Administrator Intermediate

Description

EXCEL-WD-7PM-12THDEC22

Topics for this course

127 Lessons

CLASS-1-EXCEL INTRO & INTERFACE

EXCEL INTRODUCTION01:18:32
RESOURCES-EXCEL INTRO & SHORTCUTS

CLASS-2-EXCEL PASTE SPECIAL

CLASS-3-FORMULA REFERENCE

CLASS-4-CUSTOM & READYMADE CF

CLASS-5-CONDITIONAL FORMATTING ADV

CLASS-6-CF & FORMULA VS FUNCTION

CLASS-7-LOGICAL FUNCTION-1

CLASS-8-LOGICAL FUNCTION-2

CLASS-9-LOGICAL FUNCTION-3

CLASS-10-MATH SUMIFS

CLASS-11-MATH MORE FUNC

CLASS-12-TEXT FUNCTION BASICS

CLASS-13-TEXT FUNCTION BASICS

CLASS-14-TEXT FUNCTION

CLASS-15-ADV TEXT FUNCTION

CLASS-16-ADV TEXT FUNCTION

CLASS-17-DATE FUNCTION-1

CLASS-18-DATE FUNCTION-2

CLASS-19-DATE FUNCTION-3

CLASS-20-DATABASE FUNCTION

CLASS-21-STATISTICAL FUNCTION

CLASS-22-STATISTICAL FUNCTION-2

CLASS-23-STATISTICAL FUNCTION-3

CLASS-24-GO TO SPECIAL, PRINTING.NAMING RANGE

CLASS-25-SECURITY

CLASS-26-SORTING

CLASS-27-FILTER & ADV.FILTER

CLASS-28-SUBTOTAL

CLASS-29-DATA VALIDATION

CLASS-30-WHAT IF ANALYSIS

CLASS-31-WHAT IF ANALYSIS-2

CLASS-32-WHAT IF ANALYSIS-3

CLASS-33-ARRAY & SUMPRODUCT-1

CLASS-34-ARRAY & SUMPRODUCT-2

CLASS-35-LOOKUP & REFERENCES

CLASS-36-HLOOKUP & DOUBLE VLOOKUP

CLASS-37-LOOKUP RECAP

CLASS-38-LOOKUP FUNCTION

CLASS-39-MATCH

CLASS-40-INDEX MATCH-1

CLASS-41-INDEX MATCH-2

CLASS-42-INDEX MATCH-3

CLASS-43-CHOOSE FUNCTION

CLASS-44-INDIRECT FUNCTION

CLASS-45-LOOKUP SERIES RECAP

CLASS-46-OFFSET FUNCTION

CLASS-47-PIVOT TABLE

CLASS-48-PIVOT TABLE

CLASS-49-PIVOT TABLE

MASTERING VLOOKUP & 2D 3D LOOKUP

CLASS 50-PIVOT TABLE

CLASS-51-PIVOT TABLE ADVANCED

CLASS-52-PIVOT TABLE ADVANCED

CLASS-53-PIVOT TABLE ADVANCED

CLASS-54-CHART & GRAPH

CLASS-55-CHART & GRAPH

CLASS-56-CHART &GRAPH

CLASS-57-DASHBOARD-1

CLASS-58-DASHBOARD-2

CLASS-59-DASHBOARD-3

CV FORMAT

EXCEL MCQ & INTERVIEW QUESTION

₹4,999.00
  • Course level: Intermediate