2023-EXCEL-8PM-WEEKDAY-13 MARCH - Innozant MIS & Data Analytics & Data Science

PK
Prerna Kumari Intermediate
  • Home  
  • 2023-EXCEL-8PM-WEEKDAY-13 MARCH

Topics for this course

131 Lessons

CLASS-1-CARREER PATH & EXCEL INTRODUCTION

CAREER PATH & EXCEL INTRODUCTION1:24:34
RESOURCES-CLASS-1

CLASS-2-PASTE SPECIAL

CLASS-3-CELL/FORMULA REFERENCE

CLASS-4-CUSTOM FORMATTING

CLASS-5-CONDITIONAL FORMATTING

CLASS-6-FORMULA VS FUNCTION

CLASS-7-LOGICAL FUNCTION-IF & NESTED IF

CLASS-8-LOGICAL FUNCTION-OR AND

CLASS-9-LOGICAL FUNCTION-IFS,XOR,IFERROR,SWITCH

CLASS-10-MATH FUNCTION-SUMIFS

CLASS-11-MATH FUNCTION MORE

CLASS-12-TEXT FUNCTION BASIC

CLASS-13-TEXT FUNCTION BASIC

CLASS-14-TEXT FUNCTION ADVANCED

CLASS-15-TEXT FUNCTION ADVANCED

CLASS-16-TEXT FUNCTION ADVANCED

CLASS-17-TEXT FUNCTION RECAP

CLASS-18-DATE & TIME FUNCTION

CLASS-19-DATE & TIME FUNCTION

CLASS-20-DATE FUNCTION RECAP

CLASS-21-STATISTICAL FUNCTION

CLASS-22-STATISTICAL FUNCTION

CLASS-23-STATISTICAL FUNCTION

CLASS-24-DATABASE & INFORMATION FUNCTION

CLASS-25-GOTO SPECIAL-PRINTING-SECURITY

CLASS-26-NAMING RANGE-ERROR WORLD

CLASS-27-SORTING

CLASS-28-AUTO FILTER & ADVANCED FILTER

CLASS-29-SUBTOTAL & TEXT TO COLUMN

CLASS-30-DATA VALIDATION

CLASS-31-WHAT IF ANALYSIS 1

CLASS-32-WHAT IF ANALYSIS-2

CLASS-33-WHAT IF ANALYSIS-3

CLASS-34-ARRAY & SUMPRODUCT INTRODUCTION

CLASS-35-SUMPRODUCT ADVANTAGE

CLASS-36-SUMPRODUCT MORE

CLASS-37-VLOOKUP FUNCTION

CLASS-38-VLOOKUP & HLOOKUP

CLASS-39-LOOKUP & MATCH FUNCTION

CLASS-40-INDEX & MATCH

CLASS-41-INDEX & MATCH MORE

CLASS-42-INDEX MATCH ONE-TWO-THREE WAY

CLASS-43-VLOOKUP & CHOOSE FUNCTION

CLASS-44-VLOOKUP & INDIRECT

CLASS-45-INDIRECT FUNCTION

CLASS-46-OFFSET FUNCTION

CLASS-47-OFFSET FUNCTION

CLASS-48-LOOKUP RECAP

CLASS-49-PIVOT TABLE-1

CLASS-50-PIVOT TABLE-2

CLASS-51-PIVOT TABLE-3

CLASS-52-PIVOT TABLE-4

CLASS-53-PIVOT TABLE-5

CLASS-54-PIVOT TABLE-6

CLASS-55-CHART & GRAPH-1

CLASS-56-CHART & GRAPH-2

CLASS-56-CHART & GRAPH-3

CLASS-57-DASHBOARD

CLASS-58-MINI DASHBOARD

CLASS-59-MINI DASHBOARD

CLASS-60-KPI DASHBOARD

CLASS-61-OFFICE 365

CLASS-62-OFFICE 365

CLASS-63-OVERVIEW-MAIL MERGE-POWER BI-VBA

₹4,999.00
  • Course level: Intermediate