+ 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-10AM-7TH JULY 2025
A
Administrator
Expert
Home
MASTERING EXCEL-WEEKDAY-10AM-7TH JULY 2025
About Course
MASTERING EXCEL-WEEKDAY-10AM-7TH JULY 2025
Course Content
CLASS-1-WHY EXCEL-INTRODUCTION
INTRODUCTION
01:08:25
RESOURCES-EXCEL INTRO
CLASS-2-PASTE SPECIAL
PASTE SPECIAL
01:01:17
RESOURCES-PASTE SPECIAL
CLASS-3-FORMULA REFERENCE
FORMULA REFERENCE
00:00
RESOURCES-FORMULA REFERENCE
CLASS-4-CONDITIONAL FORMATING
CONDITIONAL FORMATING
00:00
RESOURCES-CONDITIONAL FORMATING
CLASS-5-FORMULA VS FUNCTION
FORMULA VS FUNCTION
01:01:59
RESOURCES-FORMULA VS FUNCTION
CLASS-6-LOGICAL FUNCTION
LOGICAL FUNCTION
00:00
RESOURCES-LOGICAL FUNCTION
CLASS-7-MATH FUNCTION
MATH
01:08:49
RESOURCES-SUMIF
CLASS-8-MATH FUNCTION
MATH
48:05
Resources-Math
CLASS-9-TEXT FUNCTION
TEXT FUNCTION
49:07
RESOURCES-TEXT FUNCTION
CLASS-10-TEXT FUNCTION
TEXT
00:00
RESOURCES-TEXT
CLASS-11-TEXT FUNCTION
TEXT FUNCTION
00:00
RESOURCES-TEXT
CLASS-12-TEXT FUNCTION
TEXT
48:59
RESOURCES-TEXT3
CLASS-13-DATE FUNCTION
DATE FUNCTION
52:59
RESOURCES-DATE
CLASS-14-DATE FUNCTION
DATE FUNCTION
45:11
RESOURCES-DATE
CLASS-15-STATISTICAL FUNCTION
STATISTICAL
00:00
RESOURCES-STATISTICAL
CLAAS-16-STATISTICAL FUNCTION
STATISTICAL FUNCTION
48:50
RESOURCS-STATISTICAL
CLASS-17-STATISTICAL FUNCTION
STATISTICAL
00:00
RESOURCES-STATISTICAL
CLASS-18-STATISTICAL FUNCTION
STATISTICAL
46:06
RESOURCES-STATISTICAL FUNCTION
CLASS-19-DATABASE & INFORMATION
DATABASE & INFORMATION
42:33
RESOURCES-DATABASE & INFORMATION
CLASS-20-PRINTING-GOTOSPECIAL
GOTO SPECIAL
41:18
RESOURCES-GOTO SPECIAL
CORE EXCEL ASSIGNMENT TEST
ASSIGNMENT
CLASS-21 SECURITY
SECURITY
41:06
RESOURCE SECURITY
CLASS-22-SORTING
SORTING
45:27
Resources-sorting
CLASS-23-AUTO FILTER
AUTO FILTER
53:26
RESOURCES-AUTO FILTER ADV FILTER
CLASS-24-SUB TOTAL
SUB TOTAL
49:49
RESOURCE SUB TOTAL
CLASS-25-DATA VALIDATION
DATA VALIDATION
54:18
RESOURCE DATA VALIDATION
00:00
CLASS-26-WHAT IF ANALYSIS
WHAT IF ANALYSIS
50:46
RESOURCE-WHAT IF ANALYSIS
CLASS-27-WHAT IF ANALYSIS
WHAT IF ANALYSIS
36:56
CLASS-28-ARRAY & SUMPRODUCT
ARRAY & SUMPRODUCT
43:52
RESOURCES-ARRAY & SUMPRODUCT
CLASS-29-MAX VS SUMPRODUCT
MAX VS SUMPRODUCT
37:03
RESOURCE MAX VS SUMPRODUCT
CLASS-30-VLOOKUP
VLOOKUP
39:15
RESOURCE VLOOKUP
CLASS-31-VLOOKUP
VLOOKUP
43:16
RESOURCE VLOOKUP
CLASS-32-HLOOKUP
HLOOKUP
59:01
resources-hlookup-lookup
CLASS-33-INDEX MATCH
INDEX MATCH
36:60
RESOURCE INDEX MATCH
CLASS-34-INDEX MATCH
INDEX MATCH
52:02
RESOURCE INDEX MATCH
CLASS-35-CHOOSE FUNCTION
CHOOSE FUNCTION
46:59
RESOURCE CHOOSE FUNCTION
CLASS-36-INDIRECT FUNCTION
INDIRECT FUNCTION
56:22
RESOURCE INDIRECT FUNCTION
CLASS-37-OFFSET FUNCTION
OFFSET FUNCTION
44:29
RESOURCE OFFSET FUNCTION
00:00
CLASS-38-RECAP
RECAP
50:11
CLASS-39-PIVOT TABLE
PIVOT TABLE
49:23
RESOURCE PIVOT TABLE
CLASS-40-PIVOT TABLE
PIVOT TABLE
50:36
RESOURCE PIVOT TABLE
CLASS-41-PIVOT TABLE
PIVOT TABLE
31:30
RESOURCE PIVOT TABLE
CLASS-42-PIVOT TABLE
PIVOT TABLE
49:10
RESOURCE PIVOT TABLE
CLASS-43-PIVOT TABLE
PIVOT TABLE
46:41
RESOURCE PIVOT TABLE
00:00
CLASS-44-PIVOT TABLE
PIVOT TABLE
30:21
RESOURCE PIVOT TABLE
CLASS-45-CHART
CHART
42:42
CHART RESOURCE
CLASS-46-CHART
CHART
46:51
RESOURCE CHART
CLASS-47 CHART
CHART
55:08
RESOURCE CHART
00:00
CLASS-48-DASHBOARD
DASHBOARD
52:39
RESOURCE DASHBOARD
CLASS-49-MINI DASHBOARD
MINI DASHBOARD
45:06
RESOURCE MINI DASHBOARD
CLASS-50-KPI DASHBOARD
KPI DASHBOARD
54:40
RESOURCE KPI DASHBOARD
CLASS-51-MACRO IN EXCEL
MACRO IN EXCEL
36:36
RESOURCE MACRO IN EXCEL
CLASS-52-OFFICE 365
OFFICE 365
31:16
RESOURCE OFFICE 365
00:00
CLASS-53-XLOOKUP FUNCTION
XLOOKUP FUNCTION
43:09
RESOURCE XLOOKUP FUNCTION
CLASS-54-INTERVIEW CRACKER
INTERVIEW CRACKER
15:58
₹
4,999.00
Course level:
Expert
₹
4,999.00
Add to cart
Hi, Welcome back!
Keep me signed in
Forgot Password?
Sign In