MASTERING EXCEL-WEEKDAY-8PM-9TH DEC 2024 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

MASTERING EXCEL-WEEKDAY-8PM-9TH DEC 2024

Topics for this course

61 Lessons

CLASS-1-INTRODUCTION & PASTE SPECIAL

PASTE SPECIAL01:08:04
RESOURCES-PASTE SPECIAL

CLASS-2-RECAP

CLASS-3-CUSTOM FORMAT

RECAP

CLASS-4-FORMULA REFERENCE

CLASS-5-CONDITIONAL FORMATING

CLASS-6-FORMULA VS FUNCTION

CLASS-7-LOGICAL FUNCTION

CLASS-8-LOGICAL FUNCTION

CLASS-9-MATH FUNCTION

CLASS-10-SUMIFS FUNCTION

CLASS-11-TEXT FUCNTION

CLASS-12-TEXT FUNCTION

CLASS-13-TEXT FUNCTION

CLASS-14-DATE FUNCTION

MCQ ASSESSMENT

CLASS-15-DATE FUNCTION

CLASS-16-DATE & DATABASE FUNCTION

CLASS-17-GOTO SPECIAL-SECURITY

CLASS-18-STATISTICAL FUNCTION

CLASS-19-STATISTICAL FUNCTION

CLASS-20-SORTING

CLASS-21-FILTER & ADVANCED FILTER

CLASS-22-SUBTOTAL & TTC

CLASS-23-DATA VALIDATION

CLASS-24-WHAT IF ANALYSIS

CLASS-25-WHAT IF ANALYSIS

CLASS-26-ARRAY

CLASS-27-SUMPRODUCT

CLASS-28-VLOOKUP

CLASS-29-DOUBLE VLOOKUP

CLASS-30-HLOOKUP-LOOKUP & MATCH FUNCTION

4,999.00
  • Course level: Expert