Mastering Excel Weekday-3rd October 2023-7PM - Innozant MIS & Data Analytics & Data Science

A
Administrator Intermediate
  • Home  
  • Mastering Excel Weekday-3rd October 2023-7PM

Description

Mastering Excel Weekday-3rd October 2023-7PM

Topics for this course

117 Lessons

CLASS-1-CAREER GUIDE & EXCEL INTRODUCTION

EXCEL INTRODUCTION00:58:33
RESOURCES-EXCEL INTRO

CLASS-2-PASTE SPECIAL

CLASS-3-CUSTOM FORMATTING

CLASS-4-FORMULA REFERENCE

CLASS-5-RECAP & READYMADE CONDITIONAL FORMATTING

CLASS-6-CONDITIONAL FORMATTING

CLASS-7-FORMULA VS FUNCTION

CLASS-8-LOGICAL FUNCTION

CLASS-9-LOGICAL FUNCTION

CLASS-10-LOGICAL FUNCTION

CLASS-11-MATH FUNCTION

CLASS-12-MATH FUNCTION-SUMIFS

CLASS-13-MATH FUNCTION-SUMIFS

CLASS-14-TEXT FUNCTION

CLASS-15-TEXT FUNCTION

CLASS-16-TEXT FUNCTION

CLASS-17-TEXT FUNCTION

CLASS-18-TEXT FUNCTION

CLASS-19-DATE FUNCTION

CLASS-20-DATE FUNCTION

CLASS-21-DATE FUNCTION

CLASS-22-STATISTICAL FUNCTION

CLASS-23-STATISTICAL FUNCTION

CLASS-24-STATISTICAL FUNCTION

CLASS-25-DATABASE & INFORMATION

CLASS-26-PRINTING-GOTOSPECIAL-NAMIMG RANGE

CLASS-27-SECURITY-ERROR WORLD

CLASS-28-SORTING

CLASS-29-FILTER & ADVANCED FILTER

CLASS-30-SUBTOTAL & TEXT TO COLUMN

CLASS-31-DATA VALIDATION

CLASS-32-WHAT IF ANALYSIS

CLASS-33-WHAT IF ANALYSIS

CLASS-34-ARRAY & SUMPRODUCT-1

CLASS-35-ARRAY & SUMPRODUCT-2

CLASS-36-VLOOKUP

CLASS-37-DOUBLE VLOOKUP

CLASS-38-HLOOKUP-MATCH

CLASS-39-VLOOKUP-MATCH

CLASS-40-INDEX -ARRAY FORMAT

CLASS-41-INDEX-REFERENCE FORMAT

CLASS-42-CHOOSE FUNCTION

CLASS-43-INDIRECT FUNCTION

CLASS-44-OFFSET

CLASS-45-OFFSET

CLASS-47-PIVOT TABLE

CLASS-48-PIVOT TABLE

CLASS-49-PIVOT TABLE

CLASS-50-PIVOT TABLE

CLASS-51-PIVOT TABLE

CLASS-52-CHART

CLASS-53-CHART

CLASS-54-CHART

CLASS-55-DASHBOARD

CLASS-56-DASHBOARD

CLASS-57-DASHBOARD

CLASS-58-KPI DASHBOARD

CLASS-59-OFFICE 365

CLASS-60-OFFICE 365

₹4,999.00
  • Course level: Intermediate