MASTERING EXCEL-WEEKDAY-8PM-1ST APRIL 2024 - Innozant MIS & Data Analytics & Data Science

5.00(2)
Administrator Expert

Description

MASTERING EXCEL-WEEKDAY-8PM-1ST APRIL 2024

Topics for this course

115 Lessons

CLASS-1-EXCEL INTRODUCTION

EXCEL INTRODUCTION01:42:57
RESOURCES-EXCEL INTRODUCTION

CLASS-2-EXCEL FORMATTIG & RECAP

CLASS-3-FORMULA REFERENCE

CLASS-4-RECAP CELL REFERENCE & CUSTOM FORMATTING

CLASS-5-CONDITIONAL FORMATTING

CLASS-6-FORMULA VS FUNCTION

CLASS-7-LOGICAL FUNCTION

CLASS-8-LOGICAL-OR AND-CF

CLASS-9-LOGICAL FUNCTION

CLASS-10-LOGICAL & MATH

CLASS-11-MATH FUNCTION

CLASS-12-SUMIFS

EXCEL QUIZ

CLASS-13-TEXT

CLASS-14-TEXT

CLASS-15-TEXT

CLASS-16-TEXT

CLASS-17-DATE

CLASS-18-DATE

CLASS-19-DATE

CLASS-20-STATISTICAL

CLASS-21-STATISTICAL

CLASS-22-STATISTICAL

CLASS-23-STATISTICAL

CLASS-24-STATISTICAL

CLASS-25-DATABSE-INFORMATION

CLASS-26-GOTO SPECIAL

CLASS-27-ERROR & SECURITY

CLASS-28-SORT

CLASS-29-FILTER & ADVANCED FILTER

CLASS-30-SUBTOTAL & TTC

CLASS-31-DATA VALIDATION

CLASS-32-WHAT IF ANALYSIS

CLASS-33-WHAT IF ANALYSIS

ASSIGNMENT MASTER

CLASS-34-ARRAY

CLASS-35-SUMPRODUCT

CLASS-36-INTERVIEW QUESTION

CLASS-37-INTERVIEW QUESTION

CLASS-38-VLOOKUPM FUNCTION

CLASS-39-VLOOKUP – HLOOKUP-LOOKUP

CLASS-40-VLOOKUP & MATCH

CLASS-41-INDEX MATCH -ARRAY FORMAT

CLASS-42-INDEX MATCH REFERENCE

CLASS-43-INDEX-ONE-TWO-THREE WAY LOOKUP

CLASS-44-LOOKUP MORE

CLASS-45-CHOOSE & INDIRECT FUNCTION

CLASS-46-OFFSET

CLASS-47-LOOKUP RECAP

CLASS-48-VBA MACRO

CLASS-49-PIVOT TABLE1

CLASS-50-PIVOT TABLE2

CLASS-51-PIVOT TABLE3

CLASS-52-PIVOT TABLE4

CLASS-53-PIVOT TABLE5

CLASS-54-PIVOT TABLES

CLASS-55-CHART

CLASS-56-CHART

CLASS-57-CHART

CLASS-58-DASHBOARD

CLASS-59-DASHBOARD

Student Feedback

5.0

Total 2 Ratings

5
2 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

Super se bhi upper , jha sir bhut attractive class lete hai , every thing is clear

Excellent🙏

4,999.00
  • Course level: Expert