MASTERING EXCEL-WEEKDAY-8PM-1ST APRIL 2025 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

MASTERING EXCEL-WEEKDAY-8PM-1ST APRIL 2025

Topics for this course

96 Lessons

CLASS-1-EXCEL INTRODUCTION

EXCEL INTRODUCTION01:07:23
RESOURCES-EXCEL INTRODUCTION

CLASS-2-EXCEL PASTE SPECIAL & CUSTOM FORMATING

CLASS-3-FORMULA REFERENCE

CLASS-4-CONDITIONAL FORMATING

CLASS-5-FORMULA VS FUNCTION

CLASS-6-LOGICAL FUNCTION-IF & NESTED IF

CLASS-7-LOGICAL FUNCTION-OR AND

CLASS-8-LOGICAL FUNCTION

CLASS-9-MATH FUNCTION

CLASS-10-MATH FUNCTION

CLASS-11-TEXT FUNCTION

CLASS-12-TEXT FUNCTION

CLASS-13-TEXT ADV

CLASS-14-TEXT ADV

CLASS-15-TEXT QUESTIONS

CLASS-16-DATE

CLASS-17-DATE

CLASS-18-DATE

CLASS-19-STATISTICAL

CLASS-20-STATISTITCAL

CLASS-21-INFORMATION

CLASS-22-PRINTING-GOTO SPECIAL

ASSESSMENT-CORE EXCEL PRACTICAL

CLASS-23-SORT

CLASS-24-FILTER-ADV FILTER

CLASS-25-SUBTOTAL-TTC

CLASS-26-DATA VALIDATION

CLASS-27-WHAT IF

CLASS-28-WHAT IF

CLASS-29-WHAT IF

CLASS-30-INTERVIEW QUESTIONS

CLASS-31-ARRAY & SUMPRODUCT

CLASS-32-SUMPRODUCT

CLASS-33-SUMPRODUCT

CLASS-34-VLOOKUP

CLASS-35-VLOOKUP

CLASS-36-VLOOKUP

CLASS-37-MATCH FUNCTION

CLASS-38-INDEX FUNCTION

CLASS-39-INDEX FUNCTION

CLASS-40-CHOOSE

CLASS-41-INDIRECT

CLASS-42-VLOOKUP RECAP

CLASS-43-OFFSET

CLASS-44-PIVOT TABLE-1

CLASS-45-PIVOT TABLE-2

CLASS-46-PIVOT TABLE-3

CLASS-47-PIVOT TABLE-4

CLASS-48-CHART

CLASS-49-CHART

CLASS-50-DASHBOARD

4,999.00
  • Course level: Expert