Mastering EXCEL-6PM-9th Sep-2023 - Innozant MIS & Data Analytics & Data Science

Administrator Intermediate

Topics for this course

62 Lessons

CLASS-1-CAREER GUIDE & EXCEL INTRODUCTION

CAREER GUIDE & EXCEL INTRODUCTION01:40:00
EXCEL INTRODUCTION

CLASS-2-PASTE SPECIAL & BASIC FORMATTING

CLASS-3-CUSTOM FORMATTING & FORMULA REFERENCE

CLASS-4-CONDITIONAL FORMATTING

CLASS-5-FORMULA VS FUNCTION

CLASS-6-LOGICAL FUNCTION

CLASS-7-MATH FUNCTION

CLASS-8-MATH & TEXT FUNCTION

CLASS-9-TEXT FUNCTION

CLASS-10-TEXT ADVANCED

CLASS-11-DATE FUNCTION

CLASS-12-DATE FUNCTION

CLASS-13-STATISTICAL FUNCTION

CLASS-14-STATISTICAL FUNCTION

CLASS-15-DATABASE & INFORMATION FUNCTION

CLASS-16-SECURITY-NAMING RANGE

CLASS-17-SORT-FILTER-ADVANCED FILTER

CLASS-18-SUBTOTAL-TTC-FLASH FILL

CLASS-19-ERROR WORLD-DATA VALIDATION

CLASS-20-WHAT IF ANALYSIS

CLASS-21-ARRAY & SUMPRODUCT

CLASS-22-VLOOKUP-HLOOKUP

CLASS-23-LOOKUP-MATCH-INDEX

CLASS-24-INDEX-CHOOSE-INDIRECT

CLASS-25-VLOOKUP RECAP-OFFSET

CLASS-26-PIVOT TABLE

CLASS-27-PIVOT TABLE

CLASS-28-PIVOT & CHART

CLASS-29-DASHBOARD

CLASS-30-DASHBOARD

CLASS-31-OFFICE 365

4,999.00
  • Course level: Intermediate