Aarambh Excel -8th May-7PM - Innozant MIS & Data Analytics & Data Science

innozantseo Intermediate

Topics for this course

147 Lessons

CLASS-1-CAREER GUIDE & EXCEL INTRODUCTION

CAREER GUIDE & EXCEL INTRODUCTION1:31:25
RESOURCES-EXCEL INTRODUCTION

CLASS-2-PASTE SPECIAL

CLASS-3-FORMULA REFERENCE

CLASS-4-CUSTOM FORMATTING

CLASS-5-CONDITIONAL FORMATTING

CLASS-6-CONDITIONAL FORMATTING

CLASS-7-FORMULA VS FUNCTION

CLASS-8-LOGICAL FUNCTION-IF

CLASS-9-LOGICAL FUNCTION-NESTED IF AND OR

CLASS-10-LOGICAL FUNCTION-MORE

CLASS-11-MATH FUNCTION

CLASS-12-MATH FUNCTION

CLASS-13-TEXT FUNCTION

CLASS-14-TEXT FUNCTION

CLASS-15-TEXT FUNCTION

CLASS-16-TEXT FUNCTION

CLASS-17-TEXT FUNCTION

CLASS-18-DATE FUNCTION

CLASS-19-DATE FUNCTION

CLASS-20-DATE FUNCTION

CLASS-21-DATE FUNCTION

CLASS-22-DATE RECAP & ASSIGNMENT

CLASS-23-STATISTICAL FUNCTION

CLASS-24-STATISTICAL FUNCTION

CLASS-25-STATISTICAL FUNCTION

CLASS-26-STATISTICAL FUNCTION

CLASS-27-DATABASE & INFORMATION FUNCTION

CLASS-29-GO TO SPECIAL-FORMULA AUDITING

CLASS-30-SECURITY & NAMING RANGE

CLASS-31-SORTING

CLASS-32-FILTER & ADVANCED FILTER

CLASS-33-SUBTOTAL

CLASS-34-TEXT TO COLUMN-FLASH FILL

CLASS-35-DATA VALIDATION

CLASS-36-DATA VALIDATION

CLASS-37-GOAL SEEK & SOLVER TOOL

CLASS-38-CONSOLIDATION & DATA TABLE

CLASS-39-WORKING WITH EXTERNAL DATA

CLASS-40-HYPERLINK & ARRAY

CLASS-41-SUMPRODUCT

CLASS-42-SUMPRODUCT

CLASS-43-VLOOKUP -1

CLASS-44-COLUMNS-ROWS-HLOOKUP

CLASS-45-DOUBLE VLOOKUP

CLASS-46-LOOKUP FUNCTION

CLASS-47-MATCH FUNCTION

CLASS-48-INDEX ARRAY FORMAT

CLASS-49-INDEX FUNCTION EXAMPLES

CLASS-50-INDEX REFRENCE FORMAT

CLASS-51-ONE-TWO-THREE WAY INDEX

CLASS-51-CHOOSE FUNCTION

CLASS-52-INDIRECT FUNCTION

CLASS-53-OFFSET FUNCTION

CLASS-54-OFFSET FUNCTION

CLASS-55-OFFSET & 2D-3D-LOOKUP RECAP

CLASS-56-MASTERING VLOOKUP RECAP

CLASS-57-PIVOT TABLE-1

CLASS-58-PIVOT TABLE-2

CLASS-59-PIVOT TABLE-3

CLASS-60-PIVOT TABLE-SHOW VALUE AS

CLASS-61-PIVOT TABLE

CLASS-62-PIVOT TABLE

CLASS-63-PIVOT TABLE RELATIONSHIP

CLASS-64-EXCEL CHART

CLASS-65-EXCEL CHART

CLASS-66-DASHBOARD

CLASS-67-DASHBOARD

CLASS-68-DASHBOARD

CLASS-69-DASHBOARD

CLASS-70-DASHBOARD

CLASS-71-DASHBOARD

CLASS-72-OFFICE 365

CLASS-73-OFFICE 365

CLASS-74-OFFICE 365

4,999.00
  • Course level: Intermediate