MASTERING EXCEL-WEEKDAY-7PM-10TH JUNE 2024 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

MASTERING EXCEL-WEEKDAY-7PM-10TH JUNE 2024

Topics for this course

115 Lessons

CLASS-1-EXCEL INTRODUCTION

EXCEL INTRODUCTION01:07:54
RESOURCES-EXCEL INTRODUCTION

CLASS-2-PASTE SPECIAL & CUSTOM FORMATING

CLASS-3-FORMULA REFERENCE & READYMADE CF

CLASS-4-CONDITIONAL FORMATING & FUNCTION INTRO

CLASS-5-LOGICAL FUNCTION

CLASS-6-LOGICAL FUNCTION

CLASS-7-LOGICAL-MATH FUNCTION

CLASS-8-MATH SUMIFS FUNCTION

CLASS-9-MATH FUNCTION

CLASS-10-TEXT FUNCTION1

CLASS-11-TEXT FUNCTION

CLASS-12-TEXT FUNCTION

CLASS-13-TEXT FUNCTION

CLASS-14-ASSESSMENT & RECAP

CLASS-15-DATE FUNCTION

CLASS-16-DATE FUNCTION

CLASS-17-DATE FUNCTION

CLASS-18-STATISTICAL FUNCTION

CLASS-19-STATISTICAL FUNCTION

CLASS-20-STATISTICAL FUNCTION

CLASS-21-INFORMATION & DATABASE

CLASS-22-SECURITY

CLASS-23-SORTING

CLASS-24-FILTER & ADVANCED FILTER

CLASS-25-SUBTOTAL & TTC

ASSIGNMENT MASTER

CLASS-26-DATA VALIDATION

CLASS-27-WHAT IF ANALYSIS

CLASS-28-WHAT IF ANALYSIS

CLASS-29-WHAT IF ANALYSIS

CLASS-30-ARRAY

CLASS-31-SUMPRODUCT

CLASS-32-SUMPRODUCT

CLASS-33-VLOOKUP

CLASS-34-DOUBLE VLOOKUP

CLASS-35-VLOOKUP MORE

CLASS-36-HLOOKUP & LOOKUP

CLASS-37-MATCH FUNCTION

CLASS-38-INTERVIEW QUESTION

CLASS-39-INDEX

CLASS-40-INDEX

CLASS-41-INDEX

CLASS-42-INDEX

CLASS-43-CHOOSE FUNCTION

CLASS-44-INDIRECT

CLASS-45-LOOKUP RECAP

CLASS-46-OFFSET FUNCTION

CLASS-47-OFFSET FUNCTION

CLASS-48-PIVOT TABLE

CLASS-49-PIVOT TABLE

CLASS-50-PIVOT TABLE

MIS INTERVIEW CRACKER

CLASS-51-PIVOT TABLE

CLASS-52-PIVOT TABLE

CLASS-53-PIVOT TABLE

CLASS-54-PIVOT TABLE

CLASS-55-PIVOT TABLE

CLASS-56-PIVOT TABLE

CLASS-57-CHART

CLASS-58-CHART

CLASS-59-DASHBOARD

4,999.00
  • Course level: Expert