EXCEL-8PM WEEKEND-12TH NOV-22 - Innozant MIS & Data Analytics & Data Science

Deepti Rawat Intermediate

Topics for this course

97 Lessons

CLASS-1-WHY MIS & EXCEL INTRODUCTION

WHY MIS & EXCEL INTRO-LIVE CLASS01:45:10
INTRO-MAIN EDITED VIDEO35:37
Resources-Excel Introduction

CLASS-2-PASTE SPECIAL & CELL REFERENCE

CLASS-3-CUSTOM & CONDITIONAL FORMATTING

CLASS-4-FUNCTION VS FORMULA-LOGICAL FUNC

CLASS-5-LOGICAL FUNCTION-2

CLASS-6-MATH FUNCTION

CLASS-7-TEXT FUNCTION-1

CLASS-8-TEXT FUNCTION-2

CLASS-9-OLD CLASS REVISION

CLASS-10-TEXT FUNCTION-3

CLASS-11-TEXT FUNCTION-4

CLASS-12-DATE FUNCTION-1

CLASS-13-DATE FUNCTION-2

CLASS-14-STATISTICAL FUNCTION

CLASS-15-STATISTICAL FUNCTION

CLASS-16-DATABASE-INFORMATION-ERROR

CLASS 17-GOTO SPECIAL, PRINTING. NAMING RANGE & SECURITY

CLASS-18-SORTING

CLASS-19-FILTER & ADVANCED FILTER

CLASS-20-SUBTOTAL-TTC-DATA VALIDATION

CLASS-21-WHAT IF ANALYSIS

CLASS-22-WHAT IF ANALYSIS

CLASS-23-ARRAY & SUMPRODUCT

CLASS-24-ARRAY & SUMPRODUCT

CLASS-25-LOOKUP & REFERENCES-1

CLASS-26-HLOOKUP & LOOKUP

CLASS-27-MATCH & INDEX MATCH

CLASS-28-MATCH & INDEX MATCH

CLASS-29-INDEX MATCH (REFERENCE) & CHOOSE FUNCTION

CLASS-30-INDIRECT FUNCTION

CLASS-31-OFFSET FUNCTION

CLASS-32-PIVOT TABLE

CLASS-33-PIVOT TABLE

CLASS-34-PIVOT TABLE

CLASS-35-PIVOT TABLE

CLASS-36-CHART

CLASS-37-EXCEL DASHBOARD

MASTERING VLOOKUP & 2D 3D LOOKUP

4,999.00
  • Course level: Intermediate