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