MASTERING EXCEL-WEEKEND-10AM-11TH JAN 2025 - Innozant MIS & Data Analytics & Data Science

A
Administrator Expert
  • Home  
  • MASTERING EXCEL-WEEKEND-10AM-11TH JAN 2025

Description

MASTERING EXCEL-WEEKEND-10AM-11TH JAN 2025

Topics for this course

68 Lessons

CLASS-1-EXCEL INTRODUCTION

EXCEL INTRODUCTION02:03:37
RESOURCES-EXCEL INTRODUCTION

CLASS-2-FORMULA REFERENCE

CLASS-3-CUSTOM & CONDITIONAL FORMATING

CLASS-4-CONDITIONAL FORMATING & FUNCTION INTRO

CLASS-5-LOGICAL FUNCTION

CLASS-6-LOGICAL & MATH FUNCTION

EXCEL MCQ ASSESSMENT LINK

CLASS-7-MATH & TEXT FUNCTION

CLASS-8-TEXT FUNCTION

CLASS-9-DATE FUNCTION

CLASS-10-STATISTICAL FUNCTION

CLASS-11-STATISTICAL FUNCTION

CLASS-12-DATABASE-INFORMATION-SECURITY-SORT

CLASS-13-FILTER-ADV FILTER-SUBTOTAL-TTC

CLASS-14-DATA VALIDATION & WHAT IF ANALYSIS

CLASS-15-WHAT IF ANALYSIS

CLASS-16-ARRAY & SUMPRODUCT

CLASS-17-VLOOKUP & DOUBLE VLOOKUP

ASSESSMENT-SOLUTION-CORE EXCEL PRACTICAL

CLASS-18-HLOOKUP-MATCH

CLASS-19-INDEX MATCH

CLASS-20-INDEX MATCH-CHOOSE-INDIRECT

CLASS-21-OFFSET

COUNTIF-SOLUTION

MASTERING VLOOKUP PRACTICE

CLASS-22-PIVOT TABLE

CLASS-23-PIVOT TABLE

CLASS-24-PIVOT TABLE

CLASS-25-CHART

CV FORMAT

CLASS-26-CHART

CLASS-27-DASHBOARD

CLASS-28-KPI DASHBOARD

CLASS-29-VBA MACRO

CLASS-30-OFFICE 365

CLASS-31-CLOSURE

₹4,999.00
  • Course level: Expert