MASTERING EXCEL WEEKDAY-10AM-7TH APRIL 2025 - Innozant MIS & Data Analytics & Data Science

A
Administrator Expert
  • Home  
  • MASTERING EXCEL WEEKDAY-10AM-7TH APRIL 2025

Description

MASTERING EXCEL WEEKDAY-10AM-7TH APRIL 2025

Topics for this course

84 Lessons

CLASS-1-EXCEL INTRODUCTION

EXCEL INTRODUCTION01:07:23
RESOURCES-EXCEL INTRODUCTION

CLASS-2-CUSTOM FORMATING-PASTE SPECIAL

CLASS-3-FORMULA REFERENCE

CLASS-4-CONDITIONAL FORMATING

CLASS-5-FORMULA VS FUNCTION

CLASS-6-LOGICAL FUNCTION

CLASS-7-LOGICAL FUNCTION

CLASS-8-MATH-SUMIFS

CLASS-9-TEXT

CLASS-10-TEXT

CLASS-11-TEXT

CLASS-12-TEXT

CLASS-13-DATE

CLASS-14-DATE

CLASS-15-STATISTICAL

CLASS-16-STATISTICAL

CLASS-17-INFORMATION & DATABASE

CLASS-18-GOTO-NAMING RANGE

ASSESSMENT-PRACTICAL

CLASS-19-SECURITY

CLASS-20-SORT & FILTER

CLASS-21-SUBTOTAL-TTC

CLASS-22-DATA VALIDATION

CLASS-23-WORKING WITH EXTERNAL DATA

CLASS-24-WHAT IF ANALYSIS

CLASS-25-ARRAY

CLASS-26-SUMPRODUCT

CLASS-27-VLOOKUP

CLASS-28-VLOOKUP

CLASS-29-VLOOKUP

CLASS-30-HLOOKUP & LOOKUP

CLASS-31-MATCH

CLASS-32-INDEX

CLASS-33-INDEX

ASSESSMENT-LOOKUP SECTION

CLASS-34-CHOOSE

CLASS-35-LOOKUP RECAP

CLASS-36-INDIRECT & OFFSET

CLASS-37-PIVOT TABLE

CLASS-38-PIVOT TABLE

CLASS-39-PIVOT TABLE

CLASS-40-PIVOT TABLE

CLASS-41-CHART

CLASS-42-CHART & DASHBOARD

₹4,999.00
  • Course level: Expert