+ 91-7065069985
query@innozant.com
My Courses
Home
Live Class
Data Analytics
निपुण - Data Analytics Bootcamp
Data Science
लक्ष्य - Data Science Bootcamp
Programming
Java Full Stack
Dot Net Full Stack
Web Development Full Stack
Oracle Developer
Digital Marketing
Digital Marketing Professional
Module Course
Mastering Excel
VBA Macros
Microsoft Power BI
Tableau
Microsoft SQL Server
Oracle SQL
DA+ML using Python
Industrial Training
Python Developer
Java Developer
Dot Net Developer
Video Course
Office Application
Basic Computer
Tej Excel
Advanced Excel
Business Analytics
Power BI
DA+ML using Python
Office Automation
VBA Macro
Database
Microsoft SQL Server
Oracle SQL
Placement
Upcoming Batches
Contact us
Home
Live class
Data Analytics
निपुण - Data Analytics Bootcamp
Data Science
लक्ष्य - Data Science Bootcamp
Programming
Java Full Stack
Dot Net Full Stack
Web Development Full Stack
Oracle Developer
Digital Marketing
Digital Marketing Professional
Module Course
Mastering Excel
VBA Macros
Microsoft Power BI
Tableau
Microsoft SQL Server
Oracle SQL
DA+ML using Python
Industrial Training
Python Developer
Java Developer
Dot Net Developer
Video Course
Office Application
Basic Computer
तेज Excel
Advanced Excel
Business Analytics
Power BI
DA+ML using Python
Office Automation
VBA Macro
Database
Microsoft SQL Server
Oracle SQL
Placement
Upcoming Batches
Contact Us
My Courses
MASTERING EXCEL-WEEKEND-10AM-11TH APRIL 2026
A
Administrator
Intermediate
Home
MASTERING EXCEL-WEEKEND-10AM-11TH APRIL 2026
About Course
MASTERING EXCEL-WEEKEND-10AM-11TH APRIL 2026
Course Content
CLASS-1-EXCEL INTRODUCTION & PASTE SPECIAL
EXCEL INTRO & PASTE SPECIAL
01:46:12
RESOURCE EXCEL INTRO & PASTE SPECIAL
CLASS-2-EXCEL FORMULA REFERENCE
FORMULA REFERENCE
01:37:25
RESOURCES-FORMULA REFERENCE
CLASS-3-CONDITIONAL FORMATING
CONDITIONAL FORMATING
02:01:54
RESOURCE CONDITIONAL FORMATING
CLASS-4-LOGICAL & MATH-SUMIFS FUNCTION
LOGICAL & SUMIFS CLASS
01:37:16
RESOURCE -LOGICAL & SUMIFS
CLASS-5-RECAP & ASSESSMENT
RECAP
01:58:06
CLASS-6-TEXT FUNCTION
TEXT FUNCTION
01:40:20
RESOURCES-TEXT
CLASS-7-TEXT & RECAP
TEXT FUNCTION
02:05:45
RESOURCES-TEXT
CLASS-8-DATE FUNCTION
DATE FUNCTION
00:00
RESOURCES-DATE
CLASS-9-DATE TIME FUNCTION
DATE TIME FUNCTION
01:45:45
RESOURCE DATE TIME FUNCTION
CLASS-10-STATISTICAL FUNCTION
STATISTICAL FUNCTION
02:03:26
RESOURCE STATISTICAL FUNCTION
CLASS-11-STATISTICAL FUNCTION
STATISTICAL FUNCTION
01:27:40
RESOURCE STATISTICAL FUNCTION
ASSESSMENT TEST-MACHINE
ASSESSMENT TEST PAPER
00:00
CLASS-12-GOTO SPECIAL
GOTO SPECIAL-ERROR-SECURITY-NAMING RANGE
01:44:41
RESOURCE GOTO SPECIAL
CLASS-13-SORT-FILTER-ADV FILTER
SORT & FILTER
01:47:46
RESOURCES-SORT & FILTER
CLASS-14-SUBTOTAL-TTC-CLASS ASSESSMENT
SUBTOTAL & TTC
02:19:35
RESOURCES-SUBTOTAL-TTC
CLASS-15-DATA VALIDATION
DATA VALIDATION
45:51
RESOURCES-DATA VALIDATION
CLASS-16-WHAT IF ANALYSIS
WHAT IF ANALYSIS
01:53:11
RESOURCES-WHAT IF ANALYSIS
CLASS-17-ARRAY & SUMPRODUCT
ARRAY & SUMPRODUCT
01:37:32
RESOURCE ARRAY & SUMPRODUCT
CLASS-18-FUNCTION
FUNCTION
01:52:27
RESOURCE FUNCTION
CLASS-19-HLOOKUP & MATCH
HLOOKUP & MATCH
01:46:60
RESOURCE HLOOKUP & MATCH
CLASS-20-INDEX MATCH
INDEX MATCH
01:55:05
RESOURCE INDEX MATCH
CLASS-21-INDEX MATCH
INDEX MATCH
01:35:30
RESOURCE INDEX MATCH
CLASS-22-INDIRECT
INDIRECT
01:42:39
RESOURCE INDIRECT
CLASS-23-LOOKUP SESSION
LOOKUP SESSION
01:02:23
RESOURCE LOOKUP SESSION
CLASS-24-PIVOT TABLE
PIVOT TABLE
01:39:44
RESOURCE PIVOT TABLE
CLASS-25-SUMMARIZE VALUE AS
SUMMARIZE VALUE AS
01:33:23
RESOURCE SUMMARIZE VALUE AS
CLASS-26-ADVANCED PIVOT TABLE
ADVANCED PIVOT TABLE
01:38:44
RESOURCE ADVANCED PIVOT TABLE
CLASS-27-CHART CLASS
CHART CLASS
01:43:08
RESOURCE CHART CLASS
CLASS-28-CHART & GRAPH
CHART & GRAPH
01:37:55
RESOURCE CHART & GRAPH
CLASS-29-DASHBOARD
DASHBOARD
01:20:47
RESOURCE DASHBOARD
CLASS-30-KPI DASHBOARD
KPI DASHBOARD
01:14:01
RESOURCE KPI DASHBOARD
CLASS-31-EXCEL-MACRO
EXCEL-MACRO
01:21:59
RESOURCE EXCEL-MACRO
VALUE ADDED TOPIC
VALUE ADDED TOPIC
01:15:02
VALUE ADDED TOPIC 2
VALUE ADDED TOPIC
52:41
VALUE ADDED TOPIC 3
VALUE ADDED TOPIC 3
01:16:01
RESOURCE VALUE ADDED TOPIC 3
VALUE ADDED TOPIC 4
VALUE ADDED TOPIC 4
00:00
VALUE ADDED TOPIC 5
VALUE ADDED TOPIC 5
01:03:07
₹
4,999.00
Course level:
Intermediate
₹
4,999.00
Add to cart
Hi, Welcome back!
Keep me signed in
Forgot Password?
Sign In