+ 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-8PM-8TH JUNE 2026
A
Administrator
Expert
Home
MASTERING EXCEL-WEEKDAY-8PM-8TH JUNE 2026
About Course
MASTERING EXCEL-WEEKDAY-8PM-8TH JUNE 2026
Course Content
CLASS-1-EXCEL INTRODUCTION
EXCEL INTRODUCTION
01:11:23
RESOURCE EXCEL INTRODUCTION
CLASS-2- PASTE SPECIAL
PASTE SPECIAL
55:41
RESOURCE PASTE SPECIAL
CLASS-3–CELL REFERENCE
CELL REFERENCE
01:05:22
RESOURCE CELL REFERENCE
CLASS-4-CUSTOM FORMAT
CUSTOM FORMAT
57:30
RESOURCE CUSTOM FORMAT
CLASS-5-CONDITIONAL FORMATING
CONDITIONAL FORMATING
49:10
RESOURCE CONDITIONAL FORMATING
CLASS-6-CONDITIONAL FORMATING
CONDITIONAL FORMATING
58:13
RESOURCE CONDITIONAL FORMATING
CLASS-7-FORMULA VS FUNCTION
FORMULA VS FUNCTION
01:05:31
RESOURCE FORMULA VS FUNCTION
CLASS-8-LOGICAL CLASS
LOGICAL CLASS
01:06:22
RESOURCE LOGICAL CLASS
CLASS-9-SUMIF
SUMIF
51:58
RESOURCE SUMIF
CLASS-10-SUM KING
SUM KING
58:24
RESOURCE SUM KING
CLASS-11-MATH FUNCTION
MATH FUNCTION
01:05:03
RESOURCE MATH FUNCTION
CLASS-12-TEXT BASIC FUNCTION
TEXT BASIC FUNCTION
01:11:01
RESOURCE TEXT BASIC FUNCTION
CLASS-13-TEXT BASIC FUNCTION
TEXT BASIC FUNCTION
01:11:01
RESOURCE TEXT BASIC FUNCTION
CLASS-14-TEXT ADVANCED FUNCTION
TEXT ADVANCED FUNCTION
01:03:29
RESOURCE TEXT ADVANCED FUNCTION
CLASS-15-MATH FUNCTION
MATH FUNCTION
00:00
RESOURCE MATH FUNCTION
CLASS-16-DATE TIME FUNCTION
DATE TIME FUNCTION
54:49
RESOURCE DATE TIME FUNCTION
CLASS-17-DATE TIME FUNCTION
DATE TIME FUNCTION
01:13:59
RESOURCE DATE TIME FUNCTION
CLASS-18-RECAP
CORE EXCEL SESSION
01:16:55
RESOURCE CORE EXCEL SESSION
CLASS-19-DATE & TIME
DATE
01:18:54
RESOURCE DATE
CLASS-20-STATISTICAL FUNCTION
STATISTICAL
01:11:59
RESOURCE STATISTICAL
CLASS-21-COUNTIF
COUNTIF
01:06:09
RESOURCE COUNTIF
CLASS-22-Statistical functions
Statistical functions
51:50
RESOURCE Statistical functions
ASSIGNMENT MASTER
CORE EXCEL ASSIGNMENT MASTER
CLASS-23-INFORMATION
INFORMATION
01:04:00
Resources-database & information
CLASS-24-GOTO SPECIAL
GOTO SPECIAL
01:03:28
RESOURCE GOTO SPECIAL
CLASS-25-SORTING
SECURITY-SORTING
01:12:47
RESOURCE SECURITY
CLASS-26-FILTER
FILTER
01:04:57
RESOURCE FILTER
00:00
CLASS-27-SUBTOTAL
SUBTOTAL
59:26
RESOURCE SUBTOTAL
00:00
ASSIGNMENT MASTER
ASSIGNMENT MASTER
CLASS-28-DATA VALIDATION
DATA VALIDATION
01:05:34
RESOURCE DATA VALIDATION
CLAS-29-WHAT IF ANALYSIS
CONSOLIDATESUM
01:05:20
RESOURCE CONSOLIDATESUM
CLASS-30-ARRAY FUNCTION
ARRAY FUNCTION
01:19:23
RESOURCE ARRAY FUNCTION
00:00
CLASS-31-VLOOKUP
VLOOKUP
01:11:20
RESOURCE VLOOKUP
CLASS-32-VLOOKUP
VLOOKUP
01:02:52
RESOURCE VLOOKUP
CLASS-33-LOOKUP
LOOKUP
48:19
RESOURCE LOOKUP
CLASS-34-LOOKUP
LOOKUP
54:48
RESOURCE LOOKUP
CLASS-35-INDEX
INDEX
56:46
RESOURCE INDEX
CLASS-36-INDEX MATCH
INDEX MATCH
49:59
RESOURCE INDEX MATCH
CLASS-37-INDEX MATCH
INDEX MATCH
49:23
RESOURCE INDEX MATCH
CLASS-38-CHOOSE & INDIRECT
CHOOSE & INDIRECT
59:05
RESOURCE CHOOSE & INDIRECT
CLASS-39-CHOOSE FUNCTION
CHOOSE FUNCTION
41:35
RESOURCE CHOOSE FUNCTION
CLASS-40-OFFSET FUNCTION
OFFSET FUNCTION
51:04
RESOURCE OFFSET FUNCTION
CLASS-41-LOOKUP RECAP
LOOKUP RECAP
56:26
MASTERING LOOKUP ASSIGNMENT
CLASS-42-PIVOT TABLE-1
PIVOT TABLE-1
58:47
Resources-Pivot Table1
CLASS-43-PIVOT TABLE-2
PIVOT TABLE-2
59:11
RESOURCE PIVOT TABLE-2
CLASS-44-PIVOT TABLE-3
PIVOT TABLE-3
01:03:51
RESOURCE PIVOT TABLE-3
00:00
CLASS-45-PIVOT TABLE-4
PIVOT TABLE
48:50
RESOURCES-PIVOT TABLE
CLASS-46-PIVOT TABLE
PIVOT TABLE
48:50
CLASS-47-CHART
CHART
58:13
RESOURCE CHART
CLASS-48-CHART
CHART
01:04:24
RESOURCE CHART
CLASS-49-DASHBOARD
DASHBOARD
57:40
RESOURCE DASHBOARD
CLASS-50-DASHBOARD
DASHBOARD
01:03:27
RESOURCE DASHBOARD
VALUE ADDED TOPIC 1
VALUE ADDED TOPIC
01:15:02
RESOURCES-DASHBOARD
VALUE ADDED TOPIC 2
VALUE ADDED TOPIC 2
52:41
RESOURCES-KPI
VALUE ADDED TOPIC 3
VALUE ADDED TOPIC 3
01:16:01
RESOURCES-OFFICE 365
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