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

94 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

CLASS-31-INDEX FUNCTION

CLASS-32-INDEX FUNCTION

CLASS-33-INDEX

CLASS-34-CHOOSE FUNCTION

CLASS-35-INDIRECT

CLASS-36-OFFSET

COUNTIF SOLUTION

MASTERING VLOOKUP PRACTICE

CLASS-37-PIVOT TABLE

CLASS-38-PIVOT TABLE

CLASS-39-PIVOT TABLE

CLASS-40-CHART

CLASS-41-CHART

CLASS-42-DASHBOARD

CLASS-43-KPI DASHBOARD

CLASS-44-VBA MACRO

CLASS-45-OFFICE 365

CLOSURE

4,999.00
  • Course level: Expert