+ 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-10TH FEB 2025
A
Administrator
Intermediate
Home
MASTERING EXCEL-WEEKDAY-7PM-10TH FEB 2025
Course Content
CLASS-1-EXCEL INTRODUCTION & PASTE SPECIAL
EXCEL PASTE SPECIAL
01:14:27
RESOURCES-EXCEL INTRODUCTION
CLASS-2-FORMULA REFERENCE
FORMULA REFERENCE
01:06:41
RESOURCES-FORMULA REFERENCE
CLASS-3-RECAP & ASSESSMENT
RECAP
59:35
CLASS-4-CONDITIONAL FORMATING
CONDITIONAL FORMATING
57:57
RESOURCES-CF
CLASS-5-FORMULA VS FUNCTION
FORMULA VS FUNCTION
43:48
RESOURCES-FORMULA VS FUNCTION
CLASS-6-LOGICAL FUNCTION
LOGICAL FUNCTION
59:30
RESOURCES-LOGICAL
CLASS-7-LOGICAL FUNCTION
LOGICAL FUNCTION
52:49
RESOURCES-LOGICAL
CLASS-8-MATH FUNCTION
SUMIF
57:52
RESOURCES-SUMIF
CLASS-9-MATH & TEXT FUNCTION
MATH & TEXT FUNCTION
48:05
resources-text 1
CLASS-10-TEXT FUNCTION
TEXT
31:34
RESOURCES-TEXT FUNCTION
CLASS-11-TEXT FUNCTION
TEXT FUNCTION
49:44
RESOURCES-TEXT
CLASS-12-TEXT FUNCTION
TEXT FUNCTION
54:28
CLASS-13-DATE FUNCTION
DATE FUNCTION
01:04:14
RESOURCES-DATE FUNCTION
CLASS-14-DATE & STATISTICAL FUNCTION
DATE & STATISTICAL FUNCTION
01:18:22
RESOURCES-STATISTICAL
EXCEL MCQ ASSESSMENT
EXCEL MCQ ASSESSMENT
CLASS-15-DATABASE & INFORMATION
DATABASE & INFORMATION
38:51
RESOURCES-DATABASE & INFORMATION
CLASS-16-SECURITY-GOTO SPECIAL
SECURITY-GOTO SPECIAL
01:17:28
RESOURCES-SECURITY
CLASS-17-SORTING-FILTER & ADVANCED FILTER
SORTING & FILTER
55:53
RESOURCES-SORTING
CLASS-18-SUBTOTAL-TTC
SUBTOTAL-TTC
45:03
RESOURCES-SUBTOTAL-TTC
CLASS-19-DATA VALIDATION
DATA VALIDATION
54:22
RESOURCES-DATA VALIDATION
CLASS-20-WHAT IF ANALYSIS
WHAT IF
01:03:51
RESOURCES-WHAT IF
CLASS-21-WHAT IF ANALYSIS
WHAT IF
00:00
RESOURCES-WHAT IF
CLASS-22-WHAT IF ANALYSIS
WHAT IF
48:59
CLASS-23-ARRAY & SUMPRODUCT
ARRAY & SUMPRODUCT
53:20
RESOURCES-ARRAY
ASSIGNMENT MASTER
ASSIGNMENT
CLASS-24-VLOOKUP
VLOOKUP
37:27
RESOURCES-VLOOKUP
CLASS-25-HLOOKUP-LOOKUP
HLOOKUP-LOOKUP
48:46
Resources-hlookup-lookup
CLASS-26-MATCH
MATCH
43:56
RESOURCES-MATCH
CLASS-27-INDEX MATCH
INDEX
46:48
Resources-index
CLASS-28-INDEX MATCH
INDEX MATCH
33:34
Resources-index
CLASS-29-INDEX MATCH
INDEX
36:09
CLASS-30-CHOOSE FUNCTION
CHOOSE
42:58
RESOURCES-CHOOSE
CLASS-31-INDIRECT
INDIRECT
33:45
RESOURCES-INDIRECT
CLASS-32-OFFSET
OFFSET
48:01
Resources-Offset
CLASS-33-PIVOT TABLE
PIVOT TABLE
45:46
Resources-pivot table
CLASS-34-PIVOT TABLE
PIVOT TABLE
40:33
RESOURCES-PIVOT TABLE
CLASS-35-PIVOT TABLE
PIVOT TABLE
45:20
RESOURCES-PIVOT-3
CLASS-36-PIVOT TABLE
PIVOT TABLE
40:45
RESOURCES-PIVOT
CLASS-37-PIVOT TABLE
PIVOT
46:35
RESOURCES-PIVOT
CLASS-38-CHART
CHART
33:15
RESOURCES-CHART
CORE ASSIGNMENT MASTER
ASSIGNMENT
CLASS-39-CHART
CHART
00:00
Resources-chart
MASTERING VLOOKUP RECAP
VLOOKUP
CLASS-40-CHART
CHART
00:00
RESOURCES-CHART
CLASS-41-CHART
CHART
00:00
RESOURCES-CHART
CLASS-42-DASHBOARD
DASHBOARD
37:21
RESOURCES-SALES DASHBOARD & ASSIGNMENT
00:00
CLASS-43-DASHBOARD-KPI
KPI
45:25
RESOURCES-KPI
CLASS-44-DASHBOARD
DASHBOARD
00:00
RESOURCES-KPI
CLASS-45-OFFICE 365
OFFICE 365
00:00
RESOURCES-OFFICE 365
₹
4,999.00
Course level:
Intermediate
₹
4,999.00
Add to cart
Hi, Welcome back!
Keep me signed in
Forgot Password?
Sign In