/CourseBundles(38737)/2733446-WhatsApp_Image_2024-03-21_at_4.39.50_PM.jpeg)
Course Overview
Schedule of Classes
Course Curriculum
1 Subject
Basic to Advanced Excel
54 Learning Materials
Introduction to Excel
Excel Preview
Video
17:9
Hometab Interface Part 1
Video
29:6
Hometab Interface Part 2
Video
36:00
Excel Insert Tab
Video
32:40
Data Entry & Formatting
Home Tab Tools With Marksheet Part 1
Video
32:40
Home Tab Tools with Marksheet Part 2
Video
34:57
Home Tab Tools With Marksheet Part 3
Video
23:14
Cell Reference
Video
40:39
EMI (Equaty Monthly Installment)
Video
24:29
Creating Salary Chart
Video
32:40
Data Analysis Functions
PROPER, UPPER, LEN Functions
Video
36:41
LEFT, MID, RIGHT Functions
Video
31:16
COUNT Series Part 1
Video
28:30
COUNT Series Part 2
Video
34:10
SUM Series Part 1
Video
32:39
SUM Series Part 2
Video
25:28
AVERAGE Series
Video
45:33
Logical Functions & Scenario
IF Scenerio Part 1
Video
40:3
IF Scenerio Part 2
Video
24:30
IF Senerio Part 3
Video
26:22
All LOOKUP Functions
VLOOKUP Part 1
Video
36:15
VLOOKUP Part 2
Video
20:41
HLOOKUP
Video
36:18
VLOOKUP Multiple Sheet
Video
21:22
INDEX Match Part 1
Video
23:38
INDEX Match Part 2
Video
41:31
XLOOKUP PART 1
Video
25:46
XLOOKUP Part 2
Video
24:7
AND & OR
Video
43:43
LOOKUP
Video
28:19
Excel Interface
Page Layout Introduction
Video
10:37
Formula Tab Introduction
Video
9:39
Data Tab Introduction
Video
13:30
Review Tab Introduction
Video
9:48
View Tab Introduction
Video
16:59
Detailed Learning of Functions
ROUND Function Part 1
Video
35:22
ROUND Function Part 2
Video
34:56
TRUNC & FLOOR Functions
Video
25:40
CEILING & MROUND Functions
Video
29:46
Working with Cells & Functions
Cell Reference Part 2
Video
15:37
Convert Text to Number
Video
22:41
DATE Function
DATE, DATEVALUE etc.
Video
32:51
EOMONTH, MONTH etc.
Video
23:29
WEEKDAY, WEEKNUM etc.
Video
17:40
WHAT IF Analysis
WHAT IF Analysis
Video
16:24
DATA Validation
Video
21:00
Advance Conditional Formatting with Data Validation
Video
33:25
Automation
Data Automation Part 1
Video
33:54
Data Automation Part 2
Video
27:56
Data Automation Part 3
Video
24:5
Data Automation with Macros
Video
30:25
Pivot Table Introduction
Pivot Table Introduction
Video
34:31
Pivot Table & Chart Introduction
Video
27:1
Slicer & Timeline Introduction
Video
26:55
Revision Test 1
Course Instructor
/2429808-logo.jpg){kind=logo}
Skill Mantra
28 Courses • 2098 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy