/CourseBundles(38250)/2634140-WhatsApp_Image_2024-01-27_at_17.18.11.jpeg)
Course Overview
Schedule of Classes
Course Curriculum
2 Subjects
Basic to Advanced Excel
0 Exercises • 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
Workplace Computer Literacy
0 Exercises • 49 Learning Materials
Computer Fundamentals
Introduction to Computer
Video
16:22
Components of Computer System
Video
18:52
Memory Management
Video
21:54
Operating System & You
Introduction to Operating System
Video
23:32
User Interface
Video
18:19
Controls of Operating System
Video
17:51
Computer Utilities
Video
14:48
User and Password
Video
18:24
Practical ( Functioning of Operating System)
Video
17:38
Practical (Desktop Settings)
Video
16:45
Practical (Storage Management)
Video
17:40
Practical (Control Panel)
Video
19:48
Practical (Disk Utilities)
Video
12:52
Practical (Windows User Account)
Video
13:13
Office Automation(MS Word ,MS PowerPoint)
Word Processor
Video
20:5
Word Formatting
Video
11:49
Word Tabs
Video
19:4
Table Formatting
Video
20:31
Text Formatting -Word Art
Video
12:35
Page Formatting
Video
14:27
Mail Merge
Video
38:32
Getting Started with Powerpoint
Video
24:9
Power Point Views
Video
28:00
Power Point Practical 1
Video
18:21
Power Point Practical 2
Video
19:19
Power Point Practical 3
Video
32:14
Getting Started with the Internet
Getting Started with the Internet
Video
16:58
Getting Started with the Internet- Keywords
Video
17:59
Getting Started with the Internet- Email
Video
24:4
Practical- Creating GMail Accounts
Video
15:41
Practical- Google Search Engine
Video
19:20
Practical- Working with URL
Video
12:37
Practical- E Government Portals
Video
23:6
Practical- Working with Mailing Accounts
Video
13:33
Practical- Google Map/Translator
Video
15:46
Practical YouTube(Tips and Tricks)
Video
17:43
Business Documentation/Cloud Documentation
Cloud Documentation
Video
16:19
Data Sync with Cloud
Video
18:11
Functioning of Google Products
Video
16:56
Email Services
Video
19:41
Practical- Benefits of Cloud System
Video
14:1
Practical- Working with Google tools
Video
8:29
Practical- Google News
Video
21:38
Practical- Working with Google chat/Meet
Video
13:56
Practical- Google Shop
Video
19:13
Practical- Educational Tool Google Earth
Video
26:10
Practical- Google Keep
Video
18:44
Practical- Google Art and Culture
Video
10:32
Practical-Google One Drive
Video
12:45
Course Instructor
/2429808-logo.jpg){kind=logo}
Skill Mantra
45 Courses • 1500 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy