Mastering Excel-6th Jan 2024-10AM - Innozant MIS & Data Analytics & Data Science

Administrator Intermediate

Description

Mastering Excel-6th Jan 2024-10AM

Topics for this course

59 Lessons

CLASS-1-EXCEL INTRODUCTION & PASTE SPECIAL

EXCEL INTRODUCTION1:36:38
RESOURCES-EXCEL INTRODUCTION

CLASS-2-CUSTOM FORMAT & FORMULA REFERENCE

CLASS-3-RECAP & CONDITIONAL FORMATTING

CLASS-4-LOGICAL FUNCTION

CLASS-5-MATH & TEXT FUNCTION

CLASS-6-TEXT ADVANCED

CLASS-7-TEXT ADV & DATE

CLASS-8-DATE & STATISTICAL FUNCTION

CLASS-9-STATISTICAL & INFORMATION

CLASS-10-SECURITY-GOTO SPECIAL

CLASS-11-SORT-FILTER-ADV FILTER

CLASS-12-SUBTOTAL-TTC-DATA VALIDATION

CLASS-13-WHAT IF ANALYSIS

CLASS-14-ARRAY & SUMPRODUCT

CLASS-15-VLOOKUP & DOUBLE VLOOKUP

CLASS-16-HLOOKUP-MATCH

CLASS-17-INDEX MATCH

CLASS-18-INDEX MATCH & CHOOSE FUNCTION

CLASS-19-INDIRECT FUNCTION

CLASS-20-OFFSET FUNCTION

RESOURCES-MASTERING VLOOKUP

CLASS-21-PIVOT TABLE

CLASS-22-PIVOT TABLE

CLASS-23-PIVOT TABLE

CLASS-24-CHART & GRAPH

CLASS-25-CHART & GRAPH

CLASS-25-DASHBOARD

CLASS-26-ADV. CONDITIONAL FORMATTING

CLASS-26-DASHBOARD

CLASS-27-OFFICE 365

4,999.00
  • Course level: Intermediate