MASTERING EXCEL-WEEKDAY-10AM-7TH JULY 2025 - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

MASTERING EXCEL-WEEKDAY-10AM-7TH JULY 2025

Topics for this course

106 Lessons

CLASS-1-WHY EXCEL-INTRODUCTION

INTRODUCTION01:08:25
RESOURCES-EXCEL INTRO

CLASS-2-PASTE SPECIAL

CLASS-3-FORMULA REFERENCE

CLASS-4-CONDITIONAL FORMATING

CLASS-5-FORMULA VS FUNCTION

CLASS-6-LOGICAL FUNCTION

CLASS-7-MATH FUNCTION

CLASS-8-MATH FUNCTION

CLASS-9-TEXT FUNCTION

CLASS-10-TEXT FUNCTION

CLASS-11-TEXT FUNCTION

CLASS-12-TEXT FUNCTION

CLASS-13-DATE FUNCTION

CLASS-14-DATE FUNCTION

CLASS-15-STATISTICAL FUNCTION

CLAAS-16-STATISTICAL FUNCTION

CLASS-17-STATISTICAL FUNCTION

CLASS-18-STATISTICAL FUNCTION

CLASS-19-DATABASE & INFORMATION

CLASS-20-PRINTING-GOTOSPECIAL

CORE EXCEL ASSIGNMENT TEST

CLASS-21 SECURITY

CLASS-22-SORTING

CLASS-23-AUTO FILTER

CLASS-24-SUB TOTAL

CLASS-25-DATA VALIDATION

CLASS-26-WHAT IF ANALYSIS

CLASS-27-WHAT IF ANALYSIS

CLASS-28-ARRAY & SUMPRODUCT

CLASS-29-MAX VS SUMPRODUCT

CLASS-30-VLOOKUP

CLASS-31-VLOOKUP

CLASS-32-HLOOKUP

CLASS-33-INDEX MATCH

CLASS-34-INDEX MATCH

CLASS-35-CHOOSE FUNCTION

CLASS-36-INDIRECT FUNCTION

CLASS-37-OFFSET FUNCTION

CLASS-38-RECAP

CLASS-39-PIVOT TABLE

CLASS-40-PIVOT TABLE

CLASS-41-PIVOT TABLE

CLASS-42-PIVOT TABLE

CLASS-43-PIVOT TABLE

CLASS-44-PIVOT TABLE

CLASS-45-CHART

CLASS-46-CHART

CLASS-47 CHART

CLASS-48-DASHBOARD

CLASS-49-MINI DASHBOARD

CLASS-50-KPI DASHBOARD

CLASS-51-MACRO IN EXCEL

CLASS-52-OFFICE 365

CLASS-53-XLOOKUP FUNCTION

CLASS-54-INTERVIEW CRACKER

4,999.00
  • Course level: Expert