+ 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-WEEKDAY-7PM-3RD NOV 2025
A
Administrator
Expert
Home
MASTERING EXCEL-WEEKDAY-7PM-3RD NOV 2025
About Course
MASTERING EXCEL-WEEKDAY-7PM-3RD NOV 2025
Course Content
CLASS-1-EXCEL INTRODUCTION
EXCEL INTRODUCTION
01:01:10
RESOURCES-EXCEL INTRODUCTION
CLASS-2-FORMULA REFERENCE
FORMULA REFERENCE
01:03:46
RESOURCES-FORMULA REFERENCE
CLASS-3-CONDITIONAL FORMATING
CONDITIONAL FORMATING
42:56
RESOURCE CONDITIONAL FORMATING
CLASS-4-CONDITIONAL FORMATING
CONDITIONAL FORMATING
53:23
RESOURCE CONDITIONAL FORMATING
00:00
CLASS-5-CELL REFERENCE
CELL REFERENCE
52:44
RESOURCE CELL REFERENCE
CLASS-6-LOGICAL FUNCTION
LOGICAL FUNCTION
01:00:58
RESOURCE LOGICAL FUNCTION
CLASS-7-LOGICAL FUNCTION
LOGICAL FUNCTION
36:54
RESOURCE LOGICAL FUNCTION
CLASS-8-MATH FUNCTION-SUMIFS
MATH FUNCTION-SUMIFS
54:11
RESOURCE MATH FUNCTION-SUMIFS
CLASS-9-MATH FUNCTION
MATH FUNCTION
56:03
RESOURCE MATH FUNCTION
CLASS-10-TEXT FUNCTION
TEXT FUNCTION
44:54
RESOURCE TEXT FUNCTION
00:00
CLASS-11-TEXT FUNCTION
TEXT FUNCTION
51:37
RESOURCE TEXT FUNCTION
CLASS-12-DATE FUNCTION
DATE FUNCTION
01:03:58
RESOURCE DATE FUNCTION
CLASS -13-DATE FUNCTION
DATE FUNCTION
45:40
RESOURCE DATE FUNCTION
CLASS-14-SUM KING
SUM KING
35:52
resoources
CLASS-15-STATISTICAL FUNCTION
STATISTICAL FUNCTION
42:06
RESOURCE STATISTICAL FUNCTION
CLASS-16-STATISTICAL FUNCTION-COUNTIF
STATISTICAL FUNCTION-COUNTIF
45:18
RESOURCE STATISTICAL FUNCTION-COUNTIF
CORE EXCEL ASSIGNMENT
ASSIGNMENT
CLASS-17-STATISTICAL FUNCTION
STATISTICAL FUNCTION
40:50
RESOURCE STATISTICAL FUNCTION
CLASS-18-GOTO SPECIAL
GOTO SPECIAL
48:48
RESOURCE GOTO SPECIAL
CLASS-19-SORTING
SORTING
47:44
resource SORTING
CLASS-20-SUBTOTAL
SUBTOTAL
49:59
RESOURCE SUBTOTAL
CLASS-21-ASSIGNMENT SOLUTIONS
ASSIGNMENT SOLUTIONS
32:16
CLASS-22-DATA VALIDATION
DATA VALIDATION
01:00:16
RESOURCE DATA VALIDATION
CLASS-23-WHAT IF ANALYSIS
WHAT IF ANALYSIS
53:08
RESOURCE WHAT IF ANALYSIS
ASSIGNMENT EXTRAZ
ASSIGNMENT
CLASS-24-WHAT IF ANALYSIS
WHAT IF ANALYSIS
41:24
RESOURCE WHAT IF ANALYSIS
CLASS-25-ARRAY
ARRAY
44:44
RESOURCE ARRAY
CLASS-26-SUMPRODUCT
SUMPRODUCT
50:41
RESOURCE SUMPRODUCT
CLASS-27-LOOKUP
LOOKUP
54:02
RESOURCE LOOKUP
CLASS-28-VLOOKUP
MATCH
31:21
RESOURCES-MATCH
CLASS-29-INDEX MATCH
INDEX MATCH
44:40
RESOURCE INDEX MATCH
CLASS-30-INDEX MATCH
INDEX MATCH
40:27
RESOURCE INDEX MATCH
CLASS-30-CHOOSE
CHOOSE
43:03
RESOURCE CHOOSE
CLASS-31-INDIRECT FUNCTION
INDIRECT FUNCTION
46:39
RESOURCE INDIRECT FUNCTION
CLASS-32-OFFSET FUNCTION & MASTERING VLOOKUP
OFFSET FUNCTION & MASTERING VLOOKUP
46:39
RESOURCE OFFSET FUNCTION & MASTERING VLOOKUP
CLASS-33-PIVOT TABLE
PIVOT TABLE
29:11
RESOURCE PIVOT TABLE
CLASS-34-PIVOT TABLE
PIVOT TABLE
36:59
RESOURCE PIVOT TABLE
CLASS-35-SUMMARIZE
SUMMARIZE
48:05
RESOURCE SUMMARIZE
CLASS-36-PIVOT TABLE
PIVOT TABLE
43:11
resources-pivot
CLASS-37-PIVOT TABLE
PIVOT TABLE
48:07
RESOURCE PIVOT
CLASS-38-CHART & DYNAMIC CHART
CHART & DYNAMIC CHART
38:30
RESOURCE CHART & DYNAMIC CHART
CLASS-39-CHART
CHART
34:19
RESOURCE CHART
CLASS-40-BULLET CHART
BULLET CHART
43:37
RESOURCE BULLET CHART
CLASS-41-DASHBOARD
DASHBOARD
45:17
RESOURCE DASHBOARD
CLASS-42-EXCEL OFFICE 365
EXCEL DYNAMIC ARRAYS
35:47
RESOURCE EXCEL DYNAMIC ARRAYS
CLASS-43-OFFICE 365
office 365
01:02:56
Resources-office 365
VALUE ADDED TOPIC
VALUE ADDED TOPIC
01:15:02
VALUE ADDED TOPIC
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
01:09:51
VALUE ADDED TOPIC 5
VALUE ADDED TOPIC 5
01:03:07
₹
4,999.00
Course level:
Expert
₹
4,999.00
Add to cart
Hi, Welcome back!
Keep me signed in
Forgot Password?
Sign In