MASTERING EXCEL-WEEKDAY-7PM-10TH FEB 2025 - Innozant MIS & Data Analytics & Data Science

A
Administrator Intermediate
  • Home  
  • MASTERING EXCEL-WEEKDAY-7PM-10TH FEB 2025

Topics for this course

90 Lessons

CLASS-1-EXCEL INTRODUCTION & PASTE SPECIAL

EXCEL PASTE SPECIAL01:14:27
RESOURCES-EXCEL INTRODUCTION

CLASS-2-FORMULA REFERENCE

CLASS-3-RECAP & ASSESSMENT

CLASS-4-CONDITIONAL FORMATING

CLASS-5-FORMULA VS FUNCTION

CLASS-6-LOGICAL FUNCTION

CLASS-7-LOGICAL FUNCTION

CLASS-8-MATH FUNCTION

CLASS-9-MATH & TEXT FUNCTION

CLASS-10-TEXT FUNCTION

CLASS-11-TEXT FUNCTION

CLASS-12-TEXT FUNCTION

CLASS-13-DATE FUNCTION

CLASS-14-DATE & STATISTICAL FUNCTION

EXCEL MCQ ASSESSMENT

CLASS-15-DATABASE & INFORMATION

CLASS-16-SECURITY-GOTO SPECIAL

CLASS-17-SORTING-FILTER & ADVANCED FILTER

CLASS-18-SUBTOTAL-TTC

CLASS-19-DATA VALIDATION

CLASS-20-WHAT IF ANALYSIS

CLASS-21-WHAT IF ANALYSIS

CLASS-22-WHAT IF ANALYSIS

CLASS-23-ARRAY & SUMPRODUCT

ASSIGNMENT MASTER

CLASS-24-VLOOKUP

CLASS-25-HLOOKUP-LOOKUP

CLASS-26-MATCH

CLASS-27-INDEX MATCH

CLASS-28-INDEX MATCH

CLASS-29-INDEX MATCH

CLASS-30-CHOOSE FUNCTION

CLASS-31-INDIRECT

CLASS-32-OFFSET

CLASS-33-PIVOT TABLE

CLASS-34-PIVOT TABLE

CLASS-35-PIVOT TABLE

CLASS-36-PIVOT TABLE

CLASS-37-PIVOT TABLE

CLASS-38-CHART

CORE ASSIGNMENT MASTER

CLASS-39-CHART

MASTERING VLOOKUP RECAP

CLASS-40-CHART

CLASS-41-CHART

CLASS-42-DASHBOARD

CLASS-43-DASHBOARD-KPI

CLASS-44-DASHBOARD

CLASS-45-OFFICE 365

₹4,999.00
  • Course level: Intermediate