Mastering EXCEL-10th July-8PM - Innozant MIS & Data Analytics & Data Science

5.00(1)
Administrator Expert

Description

Mastering EXCEL-10th July-8PM

Topics for this course

145 Lessons

CLASS-1-CAREER GUIDE & EXCEL INTRODUCTION

CAREER GUIDE & SQL INTRODUCTION1:21:03
RESOURCES-EXCEL INTRODUCTION

CLASS-2-PASTE SPECIAL

CLASS-3-CUSTOM FORMATTING

CLASS-4-FORMULA REFERENCE

CLASS-5-FORMUALA REFERENCE-RECAP

CLASS-6-CONDITIONAL FORMATTING

CLASS-7-CUSTOMIZED CF & FORMULA VS FUNCTION

CLASS-8-LOGICAL FUNCTION-IF & NESTED IF

CLASS-9-LOGICAL -AND OR

CLASS-10-LOGICAL RECAP

CLASS-11-LOGICAL MORE

CLASS-12-DOUBT SESSION

CLASS-13-MATH-SUMIFS FUNCTION

CLASS-14-MATH MORE EXAMPLES

CLASS-15-TEXT FUNCTION

CLASS-16-TEXT FUNCTION

CLASS-17-TEXT FUNCTION

CLASS-18-TEXT FUNCTION

CLASS-19-TEXT FUNCTION

CLASS-20-DATE FUNCTION

CLASS-21-DATE FUNCTION

CLASS-22-DATE FUNCTION

CLASS-23-STATISTICAL FUNCTION

CLASS-24-STATISTICAL FUNCTION

CLASS-25-STATISTICAL FUNCTION

CLASS-26-STATISTICAL FUNCTION

CLASS-27-DATABASE & INFORMATION

CLASS-28-GOTO SPECIAL & ERROR WORLD

CLASS-29-SECURITY

CLASS-30-NAMING RANGE & SORTING

CLASS-31-FILTER & ADV FILTER

CLASS-32-SUBTOTAL

CLASS-33-TEXT TO COLUMN & FLASH FILL

CLASS-34-DATA VALIDATION

CLASS-35-WORKING WITH EXTERNAL DATA

CLASS-36-DATA CONSOLIDATION-GOAL SEEK

CLASS-37-SOLVER-DATA TABLE

CLASS-38-ARRAY FUNCTION

CLASS-39-SUMPRODUCT FUNCTION

CLASS-40-SUMPRODUCT MORE

CLASS-41-VLOOKUP

CLASS-42-DOUBLE VLOOKUP

CLASS-43-HLOOKUP & LOOKUP

CLASS-44-MATCH FUNCTION

CLASS-45-INDEX FUNCTION

CLASS-46-INDEX FUNCTION EXAMPLES

CLASS-47-INDEX REFERENCE FORMAT

CLASS-48-INDEX ONE TWO THREE WAY LOOKUP

CLASS-49-CHOOSE FUNCTION

CLASS-50-INDIRECT

CLASS-51-INDIRECT MORE

CLASS-52-OFFSET

CLASS-53-OFFSET

CLASS-54-MASTERING VLOOKUP REHEARSE

CLASS-55-PIVOT TABLE-1

CLASS-56-PIVOT TABLE-2

CLASS-57-PIVOT TABLE-3

CLASS-58-PIVOT TABLE-4

CV FORMAT-RESUME WRITING TIPS

CLASS-59-PIVOT TABLE-5

CLASS-60-PIVOT ADVANCED

CLASS-61-PIVOT ADVANCED

CLASS-62-PIVOT TABLE

CLASS-63-CHART & GRAPH

CLASS-64-CHART & GRAPH

CLASS-65-DASHBOARD

CLASS-66-DASHBOARD

CLASS-67-DASHBOARD

CLASS-68-DASHBOARD

CLASS-69-DASHBOARD

CLASS-70-DASHBOARD-KPI1

CLASS-71-OFFICE 365

CLASS-72-OFFICE 365

BATCH FINISHED-THANKS FOR YOUR LOVE AND SUPPORT

Student Feedback

5.0

Total 1 Ratings

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

Thanks for Dilip sir, what you teach is fun. I don't even realize when the course ends. Thanks a lot once again.

4,999.00
  • Course level: Expert