आरंभ|सक्षम|निपुण-Mastering Excel-Weekday-8PM-5th August 2024 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

आरंभ|सक्षम|निपुण-Mastering Excel-Weekday-8PM-5th August 2024

Topics for this course

111 Lessons

CLASS-1-CAREER GUIDE & EXCEL INTRODUCTION

EXCEL INTRODUCTION01:12:06
RESOURCES-EXCEL INTRODUCTION

CLASS-2-PASTE SPECIAL

CLASS-3-FORMULA REFERENCE

CLASS-4-CELL REFERENCE RECAP

CLASS-5-CUSTOM FORMATING

CLASS-6-CONDITIONAL FORMATTING

CLASS-7-FORMULA VS FUNCTION

CLASS-8-LOGICAL FUNCTION

CLASS-9-LOGICAL FUNCTION

CLASS-10-LOGICAL FUNCTION

CLASS-11-LOGICAL FUNCTION

CLASS-12-MATH FUNCTION

CLASS-13-MATH 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-STATISTICAL

CLASS-21-STATISTICAL

CLASS-22-STATISTICAL

CLASS-23-STATISTICAL-DATABASE-INFORMATION

CLASS-24-PRINTING-GOTO SPECIAL

CLASS-25-SECURITY-ERROR

CLASS-26-SORTING

CLASS-27-FILTER & ADV.FILTER

CLASS-28-SUBTOTAL & TTC

CLASS-29-DATA VALIDATION

CLASS-30-WHAT IF ANALYSIS

CLASS-31-WHAT IF ANALYSIS

CLASS-32-INTERVIEW QUSTION DISCUSSION

CLASS-33-ARRAY

CLASS-34-SUMPRODUCT

CLASS-35-SUMPRODUCT

CLASS-36-VLOOKUP

CLASS-37-DOUBLE VLOOKUP

CLASS-38-HLOOKUP & LOOKUP

CLASS-39-MATCH FUNCTION

CLASS-40-INDEX MATCH

CLASS-41-INDEX

CLASS-42-INDEX

CLASS-43-CHOOSE FUNCTION

CLASS-44-INDIRECT FUNCTION

CLASS-45-OFFSET FUNCTION

CLASS-46-OFFSET RECAP

CLASS-47-LOOKUP RECAP

CLASS-48-PIVOT TABLE

CLASS-49-PIVOT TABLE

CLASS-50-PIVOT TABLE

CLASS-51-PIVOT TABLE

CLASS-52-PIVOT TABLE

CLASS-53-PIVOT TABLE

CLASS-54-CHART

CLASS-55-CHART

CLASS-56-DASHBOARD

CLASS-57-DASHBOARD

30,000.00
  • Course level: Expert