Top Institute for IT Training Courses

Mastering Excel-Weekday-7PM-2nd June 2025

Administrator Expert

Home
Mastering Excel-Weekday-7PM-2nd June 2025

About Course

Mastering Excel-Weekday-7PM-2nd June 2025

Course Content

CLASS-1-EXCEL INTRO & PASTE SPECIAL

PASTE SPECIAL

00:00
RESOURCES-PASTE SPECIAL

CLASS-2-EXCEL CELL REFERENCE

CLASS-3-RECAP & MCQ

CLASS-4-CONDITIONAL FORMATING

CLASS-5-FORMULA VS FUNCTION

CLASS-6-LOGICAL FUNCTION

CLASS-7-LOGICAL FUNCTION

CLASS-8-LOGICAL FUNCTION

CLASS-9-MATH FUNCTION

CLASS-10-MATH FUNCTION

CLASS-11-TEXT FUNCTION

CLASS-12-TEXT FUNCTION

CLASS-13-TEXT FUNCTION

CLASS-14-TEXT FUNCTION

CLASS-15-DATE FUNCTION

CLASS-16-DATE FUNCTION

CLASS-17-STATISTICAL FUNCTION

CLASS-18-STATISTICAL FUNCTION

CLASS-19-STATISTICAL-INFORAMTION

CLASS-20-SECURITY-NAMING RANGE

CLASS-21-SORTING

ASSIGNMENT-CORE EXCEL

CLASS-22-FILTER & ADVANCED FILTER

CLASS-23-SUBTOTAL & TTC

CLASS-24-DATA VALIDATION

CLASS-25-WHAT IF ANALYSIS-1

CLASS-26-WHAT IF ANALYSIS-2

CLASS-27-ARRAY & SUMPRODUCT

CLASS-28-SUMPRODUCT

CLASS-29-VLOOKUP

CLASS-30-HLOOKUP-LOOKUP

CLASS-31-MATCH

CLASS-32-INDEX ARRAY FORMAT

CLASS-33-INDEX MATCH REFERENCE FORMAT

CLASS-34-INDEX MATCH

CLASS-35-CHOOSE

CLASS-36-INDIRECT

CLASS-37-RECAP

CLASS-38-OFFSET

MASTERING VLOOKUP-5O QUESTION

CLASS-39-PIVOT TABLE

CLASS-40-PIVOT TABLE

CLASS-41 PIVOT TABLE

CLASS-42-PIVOT TABLE

CLASS-43-PIVOT TABLE

CLASS-44-PIVOT TABLE RELATIONSHIP

CLASS-45-CHART

CLASS-45-COMBO CHART

CLASS-46-CHART-CUSTOM CHART

CLASS-47-DASHBOARD

CLASS-48-DASHBOARD

CLASS-49-DASHBOARD

CLASS-50-KPI DASHBOARD

CLASS-51-OFFICE 365

CLASS-52-OFFICE 365

₹4,999.00

Course level: Expert

Get In Touch

C-54 ,Third Floor, Sector-2, Near Sec-15 Metro Station, Noida ,Landmark-Priyagold Building , Uttar Pradesh , 201301

+91-7065069985

query@innozant.com

Copyright @ 2025 innozant. All Rights Reserved. Designed and Developed by Cybetiq.com

Follow Us: