MASTERING EXCEL-WEEKDAY-7PM-3RD NOV 2025 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

MASTERING EXCEL-WEEKDAY-7PM-3RD NOV 2025

Topics for this course

89 Lessons

CLASS-1-EXCEL INTRODUCTION

EXCEL INTRODUCTION01:01:10
RESOURCES-EXCEL INTRODUCTION

CLASS-2-FORMULA REFERENCE

CLASS-3-CONDITIONAL FORMATING

CLASS-4-CONDITIONAL FORMATING

CLASS-5-CELL REFERENCE

CLASS-6-LOGICAL FUNCTION

CLASS-7-LOGICAL FUNCTION

CLASS-8-MATH FUNCTION-SUMIFS

CLASS-9-MATH FUNCTION

CLASS-10-TEXT FUNCTION

CLASS-11-TEXT FUNCTION

CLASS-12-DATE FUNCTION

CLASS -13-DATE FUNCTION

CLASS-14-SUM KING

CLASS-15-STATISTICAL FUNCTION

CLASS-16-STATISTICAL FUNCTION-COUNTIF

CORE EXCEL ASSIGNMENT

CLASS-17-STATISTICAL FUNCTION

CLASS-18-GOTO SPECIAL

CLASS-19-SORTING

CLASS-20-SUBTOTAL

CLASS-21-ASSIGNMENT SOLUTIONS

CLASS-22-DATA VALIDATION

CLASS-23-WHAT IF ANALYSIS

ASSIGNMENT EXTRAZ

CLASS-24-WHAT IF ANALYSIS

CLASS-25-ARRAY

CLASS-26-SUMPRODUCT

CLASS-27-LOOKUP

CLASS-28-VLOOKUP

CLASS-29-INDEX MATCH

CLASS-30-INDEX MATCH

CLASS-30-CHOOSE

CLASS-31-INDIRECT FUNCTION

CLASS-32-OFFSET FUNCTION & MASTERING VLOOKUP

CLASS-33-PIVOT TABLE

CLASS-34-PIVOT TABLE

CLASS-35-SUMMARIZE

CLASS-36-PIVOT TABLE

CLASS-37-PIVOT TABLE

CLASS-38-CHART & DYNAMIC CHART

CLASS-39-CHART

CLASS-40-BULLET CHART

CLASS-41-DASHBOARD

CLASS-42-EXCEL OFFICE 365

CLASS-43-OFFICE 365

4,999.00
  • Course level: Expert