Diploma In Computer Application

About Course

डिप्‍लोमा इन कंप्‍यूटर एप्‍लीकेशन को DCA भी कहा जाता है, डिप्‍लोमा इन कंप्‍यूटर एप्‍लीकेशन एक Best Job Oriented कोर्स है जिसको करने के बाद जॉब मिलने में आसानी होती है, Diploma in Computer Application Course में आपको बहुत सारी चीजे सिखाई जाती है, अगर आपने अभी-अभी 10वीं पास की है या फिर आप 12वीं कर रहे हैं तो आप इस कोर्स को कर सकते हैं, इस कोर्स में आपको कंप्‍यूटर फंडामेंटल, एम एस ऑफिस (Microsoft Office) का पूरा कोर्स, फोटोशॉप, कोरल ड्रॉ, टैली ईआरपी 9 इत्‍यादि रोजगार परक कोर्स कराए जाते हैं –

15 Courses + 550 + Videos + Course Test + Course Completion Certificate and more

DCA Computer Course syllabus

कंप्यूटर फंडामेंटल (Computer Fundamental)
माइक्रोसॉफ्ट वर्ड (Microsoft Word)
माइक्रोसॉफ्ट एक्सल (Microsoft Excel (Beginners to Advance)
माइक्रोसॉफ्ट पावर पॉइंट (Microsoft PowerPoint)
माइक्रोसॉफ्ट एक्सेस (Microsoft Access)
माइक्रोसॉफ्ट पब्लिशर (Microsoft Publisher)
माइक्रोसॉफ्ट आउटलुक (Microsoft Outlook)
टैली प्राइम + जीएसटी रिटर्न्स (Tally Prime with GST Returns)
फोटोशॉप (Photoshop Full Course)
कोरल ड्रॉ (CorelDraw Full Course)
एक्सेल एम आई एस (Excel MIS Full Course)
एक्सेल पावर क्वेरी (Excel Power Query Full Course)
गूगल शीट्स (Google Sheets Full Course)
वीडियो एडिटिंग (Video Editing Full Course)
एचटीएमएल (HTML Full Course)

Course Content

Computer Fundamental (6 videos)

1 – Computer Parts Introduction

13:38
2 – CPU Hardware Parts

09:19
3 – Desktop Icon Settings

08:44
4 – Keyboard and Mouse Information

11:14
5 – Software Installation

09:46
6 – Change Computer Password

09:17

Microsoft Word (33 videos)

1- Introduction to Microsoft Word

11:56
2- Use Clipboard Group Of Home Tab

12:32
3- Text Formatting in Microsoft Word

05:50
4 – Line and Paragraph Spacing

08:53
5 – Sort Paragraph, Bullet and Number Lists

09:54
6- Using Find, Replace, and Go To

06:43
7- Page Setup And Printing

08:31
8- How to Create Custom Cover Pages

06:55
9- Hyperlink, Bookmark And Cross Reference

18:54
10- Creating and Formatting Tables

10:39
11- Insert Pictures in Word

09:22
12- Insert ClipArt & Online Image

05:22
13- Using Word Text Boxes

05:44
14- Create a SmartArt graphic

04:28
15- Add or Edit Shapes in Microsoft Word

06:14
16- Create or Run a Macro

05:21
17- Create Fillable Forms

06:07
18- Use Autocorrect in Word

04:51
19- How to Insert Watermarks

03:33
20- Set Default Hindi Font And Font Size

01:49
21- Check Spelling and Grammar

05:31
22- Perfect Text Alignment Using Tabs

09:51
23- Add Footnote And Endnote

04:11
24- Insert Caption in Word

05:28
25- Insert Table of Contents

05:58
26- Create a Bibliography, Citations, and Referencess son

07:14
27- Microsoft Word Best Keyboard Shortcuts

08:47
28- Letter Format Example and Writing Tips

09:33
29- How to Create a Resume in Word

06:43
30- Using Mail Merge in MS Word

06:01
31- How to Use Sum Formula in Word

05:05
32 – Create Certificate in MS Word

11:18
33 – How To Make Visiting Card

18:26

Microsoft Excel (90 videos)

1- Microsoft Excel Introduction

12:33
2 – How to Work in Excel And Use Basic Formulas

11:10
3- Use Clipboard Like Pro Full Explain

11:57
4 – Organize Row Column And Worksheet

08:47
5 – Data Entry Like Pro

05:45
6 – Create Your Own Custom List

06:30
7 – How Make Password your Excel File

05:54
8 – How To Create a Backup Excel File

06:01
9 – How to Use Sum Formula

06:15
10 – How to Use Skip Blanks

03:24
11 – Subtract, Multiple, Divide And Percentage

07:58
12 – Use of Number Format in Excel

11:15
13 – Use Conditional Formatting

13:37
14 – How to Sort & Filter Data

08:37
15 – Using Find and Replace and Using GoTo

07:19
16 – How to Use Status Bar

07:27
17 – Freeze Panes Option

04:42
18 – Split Window

04:41
19 – Fill Option

10:51
20 – Flesh Fill

08:10
21 – Pivot Table

11:40
22 – All Table Option

11:23
23 – Pictures Option

11:36
24 – Use Shape

12:24
25 – Use 3D Modal

06:04
26 – Smart Art

08:28
27 – Advanced Charts & Graph

06:29
28 – People Graph

03:18
29 – Create Hyperlinks

07:46
30 – Header and Footer

07:30
31 – Write, Insert, or Change an Equation

04:27
32 – Using the Draw Tab

03:45
33 – How to Use Themes

04:45
34 – Complete Page Setup

15:03
35 – Scale to Fit Setup

04:44
36 – IF Formula

05:20
37 – IF Formula With Multiple Conditions

06:37
38 – Change Case and Round Figure Formula

05:07
39 – VLOOKUP Formula

06:49
40 – VLOOKUP Formula Examples

16:30
41- HLOOKUP Formula

05:49
42 – And Formula

04:12
43 – Convert Number into Word Formula

04:37
44 – Use Macros with Example

04:37
45 – Subtotal Formula

04:37
46 – Link Data in Excel Spreadsheets Formula

04:37
47 – Data Consolidate Formula

04:37
48 – Calculate Age With Date, Date If Formula

04:37
49 – E-Date and Eo-Month Formula

04:37
50 – Calculating Percent Formula

04:37
51 – Superscript and Subscript Formula

04:37
52 – Group Ungroup Subtotal Formula

04:37
53 – Goal Seek Formula

04:37
54 – PMT Formula

04:37
55 – Goal With PMT Formula

04:37
56 – Concat Formula

04:37
57 – INDIRECT Formula

04:37
58 – Match Formula

04:37
59 – Count, Counta, Countblank Formula

04:37
60 – EXACT Formula

04:37
61 – Sumif Formula

04:37
62 – Sumifs Formula

04:37
63 – Round, RoundUp, RoundDown, MRound Formula

04:37
64 – Array Formula

04:37
65 – LEFT, RIGHT, MID, LEN & FIND Formula

04:37
66 – Split Name Using LEFT, RIGHT, MID, LEN Formula

04:37
67 – Mod Formula

04:37
68 – Quotient Formula

04:37
69 – Replace Formula

04:37
70 – SUBSTITUTE Formula

04:37
71- Excel Formula Error Types

04:37
72 – SUMPRODUCT Formula

04:37
73 – Text Formula

04:37
74 – Double VLOOKUP Formula

04:37
75 – Simple Interest Formula

04:37
76 – Compound Interest Formula

04:37
77 – Ceiling And Floor Formula

04:37
78 – Index Formula

04:37
79 – INDEX + MATCH Formula

04:37
80 – Forecast Formula

04:37
81 – Value Formula

04:37
82 – Most Important Keyboard Shortcut

04:37
83 – Employees Payroll and Salary Slip

04:37
84 – Daily Stock Register

04:37
85 – Dynamic Unit Converter

06:00
86 – Dynamic Dropdown List

08:52
87 – School Marksheet With Grade

07:39
88 – Make Checklist & To Do List

05:11
89 – Make Attendance Sheet

07:19
90 – Student Database With Mail Merge

32:56

Microsoft PowerPoint (7 videos)

Microsoft Access (4 videos)

Microsoft Outlook (1 video)

Microsoft Publisher (1 video)

Google Sheets Full Course (60 videos)

1 – Google Sheets Introduction

15:59
2 – Google Sheets – Use of Functions

09:25
3 – Google Sheets – Inserting and Deleting Sheets, Navigating Sheets
4 – Google Sheets – Paint Format, Currency Format, %Age Formula
5 – Google Sheets – Enable Keyboard Shortcuts, Format Sheet
6 – Google Sheets – Hyperlink and Insert Comment
7 – Goolge Sheeets – Share sheets with multiple people and word together

08:25
8 – Google Sheets – Insert Chart & Format Chart -1

10:32
9 – Google Sheets – Insert Chart & Format Chart – 2

11:31
10 – Google Sheets – Sort and Filter Options

12:23
11 – Google Sheets – Save Filter, Create Filter

07:29
12 – Google Sheets – Filter formula

07:15
13 – Google Sheets – File Menu – Save Version History, Open Excel file

10:00
14 – Google Sheets – File Menu – Publish file to web

06:09
15 – Google Sheets – Printing Tips

08:20
16 – Google Sheets – Edit Menu – Paste Special

10:16
17 – Google Sheets – Edit Menu – Find and Replace

08:44
18 – Google Sheets – View Menu – Freeze Panes

08:44
19 – Google Sheets – Insert Menu – 1 – Image, Rows, columns

12:03
20 – Google Sheets – Insert Menu – 2 – Google Forms Link to Google sheets

11:12
21- Google Sheets – Insert Menu – 3 – Check Boxes – Create To do List

06:02
22 – Google Sheets – Format Tab – Conditional formatting, Number formatting

11:37
23 – Google Sheets – Data Menu – use of Slicers

07:09
24 – Google Sheets – Data Menu – Data Validation

17:17
25 – Google Sheets – Pivot Table – Create summerize reports

12:22
26 – Google Sheets – Add Named Ranges and apply formula

07:14
27 – Google Protect Worksheet and Range

09:07
28 – Google Sheets – Split Text to Columns, Remove Duplicates

08:41
29 – Google Sheets – Macro Recordings

10:06
30 – Google Sheets – Accessibility Options

06:37
31 – Google Sheets – Mail Merge – Send Bulk Emails

09:14
32 – Google Sheets – IFS formula use

04:45
33 – Google Sheets – Text Join and Concatenate formula

07:39
34 – Google Sheets – Google Translate formula

04:39
35 – Google Sheets – Vlookup and Hlookup in Google Sheet

12:13
36 – Google Sheets – Countif, Countifs, Sumif, Sumifs

12:30
37 – Google Sheets – Sumif, Sumifs Formula in Google sheet

05:05
38 – Google Sheets – CountUniqueIFS new formula

05:32
39 – Google Sheets – Sparklines Formula Bar Columnline Chart

09:33
40 – Google Sheets – All IsFormula – Isemail, IsNumber, Istext

07:30
41 – Google Sheets – Create QR Code using Formula

05:58
42 – Google Sheets – All useful Text Formulas

11:44
43 – Google Sheets – All useful Number Formulas

09:36
44 – Google Sheets – Get Uniue Record

03:28
45 – Google Sheets – Use of Query Formula – Remove Blanks

06:36
46 – Google Sheets – Import Data from Web

04:20
47 – Google Sheets – Merge Sheets Data

07:16
48 – Google Sheets – Merge Workbooks

12:54
49 – Google Sheets – Remove Blank rows tricks

06:13
50 – Google Sheets – Offset Formula Introduction

09:15
51 – Google sheets – Real Use of Offset Formula

09:20
52 – Google Sheets – Created Monthly report dashboard

11:14
53 – Google Sheets – Sequence and Rand Formulas

05:45
54 – Google Sheets – Unique Rank Formula-1

07:19
55 – Google Sheets – Send Auto Email – Add-Ons-1

14:30
56 – Google Sheets – Copy Down Formula Add-Ons

11:58
57 – Google Sheets – Query Formula -1

08:20
58 – Google Sheets – Query Formula – 2

07:39
59 – Google Sheets – Query Formula – 3

07:43
60 – Google Sheets – Project On Query Formula

20:24

Tally Prime Course (115 videos)

1 – Tally Prime – Download and Install Tally Prime

09:53
2 – Tally Prime – Create Company in Tally Prime

12:53
3- Tally Prime – Alter Company Data

10:15
4 – Tally Prime – Tally Vault Password

09:35
5 – Tally Prime – Tally Company Configuration

08:15
6 – Tally Prime – Tally Create Users & Security

09:35
7 – Tally Prime – View Tally Reports in Mobile / Browser

05:22
8 – Tally Prime – What is Accounting Explain in Hindi

09:45
9 – Tally Prime – What is Financial year

07:58
10 – Tally Prime – Create, Alter and Delete Group

16:51
11 – Tally Prime – Create Ledgers in Tally Prime

10:01
12 – Tally Prime – Create Multiple Ledgers in Tally Prime

05:29
13 – Tally Prime – Different Ledgers and Their Meanings in Tally

10:47
14 – Tally Prime – Business First Voucher entry in Tally

18:02
15 – Tally Prime – Receipt Voucher – Goods sold on cash

05:39
16 – Tally Prime – Receipt Voucher – Amount received in cash

08:30
17 – Tally Prime – Receipt Voucher – Amount received in cheque

05:26
18 – Tally Prime – Contra Voucher – 1

11:39
19 – Tally Prime – Contra Voucher – 2

07:30
20 – Tally Prime – Payment Voucher

07:08
21 – Tally Prime – Payment Voucher

11:24
22 – Tally Prime – Purchase Voucher

12:33
23 – Tally Prime – Sales Voucher

07:17
24 – Tally Prime – After Purchase Sales

08:05
25 – Tally Prime – Journal Voucher

09:40
26 – Tally Prime – Adjustment Entries – 1

04:48
27 – Tally Prime – Adjustment Entries – 2

05:19
28 – Tally Prime – Purchase Return And Sales Return

11:10
29 – Tally Prime – Assignment on Voucher Entries – 1

13:58
30 – Tally Prime – Assignment on Voucher Entries – 2

15:29
31 – Tally Prime – Assignment on Voucher Entries – 3a

15:42
32 – Tally Prime – What Is Accounting Cycle

08:12
33 – Tally Prime – What Is Balance Sheet

05:19
34 – Tally Prime – Stock Entries – 1

06:05
35 – Tally Prime – Stock Entries – 2

10:57
36 – Tally Prime – Stock Entries – 3

08:30
37 – Tally Prime – Stock Entries – 4

05:29
38 – Tally Prime – Cost Centers Introduction – 1

16:53
39 – Tally Prime – Cost Centers Hide Details

04:27
40 – Tally Prime – Cost Centers Example – 1

06:36
41 – Tally Prime – Cost Centers Example – 2

07:58
42 – Tally Prime – Keyboard Shortcuts

16:23
43 – Tally Prime – Multiple Stock Item Entries

09:57
44 – Tally Prime – Stock Transfer – Stock Journal Vouchers

08:08
45 – Tally Prime – Physical Stock Voucher

05:03
46 – Tally Prime – Organization Types

05:25
47 – Tally Prime – Trading Organization Accounting

07:29
48 – Tally Prime – Purchase Order

15:56
49 – Tally Prime – Receipt Note Voucher

07:05
50 – Tally Prime – Rejection Out Voucher

06:54
51 – Tally Prime – Purchase Invoice

09:40
52 – Tally Prime – Debit Note – Purchase Return

09:40
53 – Tally Prime – Sales Order

13:17
54 – Tally Prime – Delivery Note-1

07:30
55 – Tally Prime – Rejection In-1

04:56
56 – Tally Prime – Create Sales Bill-1

08:11
57 – Tally Prime – Credit Note – Sales Return-1

08:26
58 – Tally Prime – TDS Introduction-1

14:40
59 – Tally Prime – TDS Introduction-2

10:23
60 – Tally Prime – TDS on Interesta

07:07
61 – Tally Prime – Frequently Ask Questions

05:14
62 – Tally Prime – TDS Entry in Tally

11:30
63 – Tally Prime – TDS Adjustment Entries

10:37
64 – Tally Prime – Tds Certificate-1

11:40
Before Practice on TDS Important Instruction

07:42
65 – Tally Prime – TDS Related Questions

09:19
66 – Tally Prime – TDS Entry as a Deductor 1

13:47
67 – Tally Prime – Tds Entry As A Deductor 2

12:52
68 – Tally Prime – Tds Entry As A Deductor 3

13:07
69 – Tally Prime – Tds Entry As A Deductor 4

04:17
70 – Tally Prime – Tds Payment-1

10:37
71 – Tally Prime – GST Introduction

11:08
72 – Tally Prime – SGST, CGST and IGST Terms

05:54
73 – Tally Prime – GST – What is HSN and SAC

07:35
74 – Tally Prime – What is Regular Dealer and Composition

08:59
75 – Tally Prime – Create Purchase Invoice Intrastate GST

27:44
76 – Tally Prime – Create Purchase Invoice Interstate GST

10:19
77 – Tally Prime – Check Stock and Purchase Registera

04:58
78 – Tally Prime – Create Sales Invoice Intrastate GST

13:10
79 – Tally Prime – Create Sales Invoice Interstate GST

05:39
80 – Tally Prime – Check Sales Register and Stock Summery

07:09
81 – TALLY PRIME – GSTR1, GSTR2, GSTR3B

09:46
82 – TALLY PRIME -What is E-Way Bill

09:01
83 – TALLY PRIME -Genterate JSON of E-Way Bill

15:03
84 – TALLY PRIME – Purchase RAW Material

17:36
85 – TALLY PRIME – Create BOM (Bill of Material)

06:55
86 – TALLY PRIME – Create Manufacturing Journal

10:08
87 – TALLY PRIME – Sold Finish Goods

07:48
88 – TALLY PRIME – Introduction of Service Organization

08:52
89 – TALLY PRIME – Introduce Capital in Service Sector

04:57
90 – TALLY PRIME – Purchased Fixed Assets with GST Invoice

12:31
91 – TALLY PRIME – Purchased Stationery with GST Invoice

11:01
92 – TALLY PRIME – Purchased Computers GST Invoice

05:24
93 – TALLY PRIME – Taken Advertisement Service

06:36
94 – TALLY PRIME – Provide Service and Received Payment-1

10:58
95 – TALLY PRIME – Provide Service and Received Payment-2

09:18
96 – TALLY PRIME – Sales Services and Received Payment-3

05:16
97 – TALLY PRIME – View Reports of Service Sectors

14:10
Tally Prime Features VS Tally ERP

18:08
98 – TALLY PRIME – Customize Sales Invoice Number

10:16
99 – TALLY PRIME – Compound Unit and Alternate Unit

11:31
100 – TALLY PRIME – Backup and Restore DATA

08:42
101 – TALLY PRIME – Import and Export

10:32
102 – TALLY PRIME – Export data in Excel

04:45
103 – TALLY PRIME – Payroll Introduction

10:45
104 – TALLY PRIME – Create Employee Record

05:33
105 – TALLY PRIME – Create Work Unit

07:31
106 – TALLY PRIME – Create Earning Panhead

08:46
107 – TALLY PRIME – Create Earning Payhead-2

10:52
108 – TALLY PRIME – Create Deduction Panhead

10:10
109 – TALLY PRIME – Define Salary Structure

04:23
110 – TALLY PRIME – Create Payroll Voucher

08:19
111- GST Filliing – GST Registration Process

15:37
112- GST Filling – Export Data in CSV Form in Tally

14:11
113- GST Filling – Create Json File With GST Offline Tool

10:37
114- GST Filling – Filling GSTR 1 (Sales) on GST Portal

10:54
115- GST Filling – Making Payment on GST Portal Filling GSTR3B

09:08
1 – TCS – What is TCS?

10:02
2 – TCS – Practical Entry in Tally Prime
3 – TCS – Payment Entry’s
1 – BRS In Tally Complete Video

18:00
1 – Practice Assignment of Tally Prime –

12:17

Tally ERP 9 Tutorial For Beginners (40 videos)

1 – Tally ERP 9 – How to Download and Install Tally Software

12:34
2 – Tally ERP 9 – Create Company in Tally

19:51
3 – Tally ERP 9 – Shut Company and Select Company

08:50
4 – Tally ERP 9 – Delete company and Change Company Information

08:50
5 – Tally ERP 9 – How to Create Password Protected Company

13:25
6 – Tally ERP 9 – Create Multiple Users in Tally

13:25
7 – Tally ERP 9 – What is Accounting

09:45
8 – Tally ERP 9 – What is Financial Year, Assets, Debtors and Creditors

07:47
9 – Tally ERP 9 – Create Group in Tally

13:14
10 – Tally ERP 9 – Alter, Delete Group in Tally

07:24
11 – Tally ERP 9 – Create Ledger in Tally

09:35
12 – Tally ERP 9 – Create Multiple ledgers in Tally

06:16
13 – Tally ERP 9 – Different Ledgers and Their Meanings in Tally

10:47
14 – Tally ERP 9 – Voucher Entries – Business First Voucher Entry

18:32
15 – Tally ERP 9 – Voucher Entries – Sold Goods on Cash

09:01
16 – Tally ERP 9 – Voucher Entries – Amount Recieved by Cheque

08:39
17 – Tally ERP 9 – Voucher Entries – Amount Recieved in Cash

08:37
18 – Tally ERP 9 – Voucher Entries – Contra Voucher

10:00
19 – Tally ERP 9 – Voucher Entries – Contra Voucher 2

07:55
20 – Tally ERP 9 – Voucher Entries – Payment Voucher

09:52
21 – Tally ERP 9 – Voucher Entries – Payment Voucher – 2

14:21
22 – Tally ERP 9 – Voucher Entries – Purchase Voucher

10:59
23 – Tally ERP 9 – Voucher Entries – Sales Voucher

10:35
24 – Tally ERP 9 – Voucher Entries – Purchase, Sales Report

05:31
25 – Tally ERP 9 – Voucher Entries – Journal Voucher

11:27
26 – Tally ERP 9 – Voucher Entries – JV Adjustment Entries

06:05
27 – Tally ERP 9 – Adjustment of Stationery Expenses

04:51
28 – Tally ERP 9 – Adjustment of Purchase Return and Sales Return

08:34
29 – Tally ERP 9 Voucher Entries Practice-1

15:33
30 – Tally ERP 9 – Voucher Entries – Practice -2

09:06
31 – Tally ERP 9 – Voucher Entries – Practice -3

16:42
32 – Tally ERP 9 – What is Accounting Cycle

08:13
33 – Tally ERP – What is Balance Sheet

05:19
34 – Tally ERP – Stock Item Entries in Tally – 1

11:08
35 – Tally ERP – Stock Item Entries in Tally – 2

13:21
36 – Tally ERP – Stock Item Entries in Tally – 3

13:22
37 – Tally ERP 9 – Cost Centre’s in Tally – 1

11:33
38 – Tally ERP 9 – Cost Centre’s in Tally – 2

09:29
39 – Tally ERP 9 – Cost Centre’s in Tally – 3

05:08
40 – Tally ERP 9 – Basic Tally keyboard Shortcuts

09:58
41- Trading Organization Accounting -1

00:00
42- Trading Organization Accounting -2

00:00

CorelDRAW Full Course (38 videos)

1 – CorelDRAW Introduction

04:41
2- Workspace Introduction

12:19
3- Basic Settings

12:41
4- How To Use Pick Tool

07:47
5- How To Use Shape Tool

06:24
6- How To Make Simple Logo

10:29
7- How To Use Knife Tool

09:33
8- Steps To Align Objects

06:01
9- How To Merge Object

11:03
10- Corel Draw Power Clip

09:02
11- How To Use Envelope Tool

11:59
12- Use 3D Text

07:28
13- How To Use Blend Tool

06:05
14- Text Setting Corel Draw

20:38
15- How To Use Shape Tool

09:17
16-How To Use Crop Tool

17:23
17- How To Make Star Logo

10:06
18- Interactive & Smart Fill option

09:51
19- How To Use Clone Tool

07:25
20- How To Use Freehand Tool

18:24
21- How To Use Artistic Tool

10:55
22- Livesketch & Smart Drawing Tool

18:32
23- Rectangle & Ellipse Tool

16:09
24-How To Use Polygon & Sprial Tool

08:37
25-How To Use Impact Tool

11:43

Photoshop Full Course (33 videos)

Introduction – Adobe Photoshop CC 2021

12:44
Layer And Selection – Adobe Photoshop

14:45
More Selections – Adobe Photoshop

16:20
Magic Wand Tool – Adobe Photoshop

10:37
Use Of Feather – Adobe Photoshop

07:55
Use Crop Tool – Adobe Photoshop

06:01
Passport Size Photo Making – Adobe Photoshop

07:05
Brush Tool – Adobe Photoshop

11:49
Clone Stamp Tool – Adobe Photoshop

10:24
Healing Tools – Adobe Photoshop

08:13
Content Aware Fill & Move Tool – Adobe Photoshop

05:08
Eraser Tools – Adobe Photoshop

06:29
Blur, Sharpen & Smudge Tools – Adobe Photoshop

06:47
Layer Mask – Adobe Photoshop

08:12
Black & White With Color – Adobe Photoshop

11:17
History Brush – Adobe Photoshop

08:16
Gradients – Adobe Photoshop

07:30
Pen Tool and Path – Adobe Photoshop

08:30
Define Pattern – Adobe Photoshop

06:01
Use Of Shapes – Adobe Photoshop

13:18
Text Effects – Adobe Photoshop

14:28
Clipping Mask – Adobe Photoshop

08:00
Dodge, Burn, Sponge Tool – Adobe Photoshop

05:50
File Menu – Adobe Photoshop

13:41
Printing Tips – Adobe Photoshop

09:36
Sky Replacement – Adobe Photoshop

07:30
Vanishing Point – Adobe Photoshop

04:51
Face Aware Liquify – Adobe Photoshop

04:39
Puppet Warp – Adobe Photoshop

06:57
Extract Hair – Adobe Photoshop

06:40
Record An Action – Adobe Photoshop

10:53
Create YouTube Thumbnail – Adobe Photoshop

17:41
Create Glow Effect – Adobe Photoshop

08:18

Filmora – Video Editing Full Course (20 videos)

1 – Filmora Introduction

06:27
2 – Filmora – Record Computer Screen

06:09
3 – Filmora – How to Edit Video

12:29
4 – Filmora -How to Merge Two Video Clip

07:55
5 – Filmora – How to Adjust Light and Brightness

05:56
6 – Filmora – Enhance Audio Quality

07:03
7 – Filmora – Save and Edit Porject

07:35
8 – Filmora -How to Add Title and Lower Third

12:20
9 – Filmora – Add Scrolling LIne in Video

08:52
10 – Filmora – Add Layer on Video

10:39
11 – Filmora – Add Background Sound Effect

08:00
12 – Filmora -Add Transition in Video

08:36
13 – Filmora – How to Use Effect Feature

09:55
14 – Filmora – How to use Element Features

08:54
15 – Filmora -How to Use Split Screen Features

04:20
16 – Filmora -How to Use Green Screen and Chroma Key Features

12:10
17 – Filmora – How to Export Video and Settings

13:19
18 – Filmora – How to Stablize A Video

04:51
19 – Filmora – How to Use Crop & PAN and zoom

06:12
20 – Filmora – How to Add Popup Effect

03:33

HTML Full Course (40 videos)

1 – HTML Introduction

10:40
2 – HTML Write first Program in HTML

16:14
3 – HTML Heading Tag in HTML

05:47
4 – HTML Indent and Comment

10:21
5 – HTML Element and Attribute

07:36
6 – HTML Formatting Tag

16:03
7 – HTML Paragraph and Preadmitted Tag

04:55
8 – HTML Font Tag

05:56
9 – HTML Quantitation and Citation

08:08
10 – HTML External Hyperlink

10:12
11 – HTML Internal Hyperlink

12:15
12 – HTML Image Tag

07:34
13 – HTML Hyperlink on Images

05:32
14 – HTML List Tag in HTML

05:46
15 – HTML Nested List Tag

07:21
16 – HTML Marquee Tag

13:10
17 – HTML Marquee on Image

13:52
18 – HTML Color Code

14:31
19 – HTML Table Tag 1

08:24
20 – HTML Table Tag 2

15:52
21 – HTML Video and Audio Tag

07:21
22 – HTML Google Map, YouTube Video Tag

04:37
23 – HTML iFrame Tag

05:19
24 – HTML Add PDF Code

06:24
25 – HTML DIV and Span Tag

08:56
26 – HTML Use of Code Editor

07:08
27 – Html – Entities, Symbol And Emojis

13:04
28 – Html – Semantic And Non-Semantic

05:06
29 – Html – Responsive

06:08
30 – HTML – Learn Image Map In HTML

13:21
31 – HTML- Form In HTML

23:34
32 – HTML – Forms – 2

13:02
33 – HTML – Radio Button – Checkbox

25:03
34 – HTML – Create Data list in Forms

09:12
35 – HTML – Output Elements in Forms

07:18
36 – HTML – Field set and Legend

13:52
37 – HTML – Extra Elements

16:21
38 – HTML – SEO Elements

09:26
39 – HTML – Add Favicon

09:56
40 – HTML – Use of VS Code Editor in Detail

16:34

Excel Power Query Beginner to Advance (26 Videos)

1 – Power Query – Introduction and Installation

15:59
2 – Power Query – Create Connections with Excel Table

07:20
3 – Power Query – Create Connections with Text file and Access Database

09:23
4 – Power Query – Reconnect Data in Power Query

07:14
5 – Power Query – Create Pivot table on Text file data

07:31
6 – Power Query – Merge Multiple sheets using M Language

10:40
7 – Power Query – Create Pivot table on Multiple Sheets

04:27
8 – Power Query – Close and Load to Explain – Home tab – Query Group

07:32
9 – Power Query – Home Tab – Manage Column and Rows Group

11:05
10 – Power Query – Home Tab – Split Column into rows and columns

07:31
11 – Power Query – Home Tab – Group by using Basic and Advance Option

05:56
12 – Power Query – Home Tab – Data type & Replace Values

06:05
13 – Power Query – Transform data Dynamically

08:51
14 – Power Query – Combine 1000+Tables with 1 Function

07:11
15 – Power Query – Alternate options of Vlookup inside Power query

07:54
16 – Power Query – Multiple columns lookup

13:43
17 – Power Query – Remove Weekends and Holidays

10:27
18 – Power Query – Calculate Age with simple Method

04:48
19 – Power Query – Calculate Task Timings

05:00
20 – Power Query – Add Column Date Options in Detail

09:21
21 – Power Query – Time and Duration Options in Details

07:42
22 – Power Query – Transform Raw Data – Real Job Query

12:00
23 – Power Query – Few clicks to get Trim, Propercase and Merge Data

08:13
24 – Power Query – Merge Workbooks and Create Pivot

12:03
25 – PowerQuery – Merge Workbooks with File Name as Column

21:40
26 – PowerQuery – Raw Data to Pivot

13:08
27 – Power Query – Merge Vs Append

10:23
Ye Course me naye naye aur videos aate rahenge

00:00

Excel MIS Beginner to Advance (28 Videos)

1- Pivot Table Introduction

11:06
2 – Pivot Table and Pivot Chart

11:06
3 – Design Tab of Pivot Chart

12:34
4- Slicer in Pivot Table & Slicer Settings

15:59
5 -Time Line in Pivot Table

11:04
6 – Get Pivot Data in Excel

23:29
7 – Pareto Chart in Excel

23:29
8 – INFOGRAPHIC CHART IN EXCEL

13:54
9 – Trend Chart using SumIFS Formula

20:52
10 – Map Chart using XY Scatter Chart

23:59
11- Key Performance Indicator in Excel

13:51
12 – Chart with Hyperlink

12:33
13 – Chart with Conditional Formatting

35:24
14 – Create Bar Charts with Pictures MIS Series

10:02
15 – Speedometer Chart in Excel

16:43
16 – See Saw Comparison Chart

17:20
17 – MIS – Hyperlink with Column and Pie-Chart

14:06
18 – MIS – Male, Female Comparison Chart

13:05
19 – Excel MIS – Create Dynamic Month Dashboard using Offset Formula

27:57
20 – Excel MIS – Create Dashboard on Day Wise Report

12:31
21 – Excel MIS – Sales Ranking Dashboard

21:40
22 – Excel MIS – Create Weekly Sales Dashboard using Listbox

18:29
23- MIS IN EXCEL – Daily Task Reminder Dashboard

22:16
24 – MIS IN EXCEL – Create Year wise report using Vlookup, Match, Index

14:58
25- MIS IN EXCEL- Create Dasboard Using VLOOKUP, INDEX, COUNTIF

19:38
26 – MIS – Amazing Dashboard

15:59
27 – MIS – Time Dashboard Project

23:37
28 – MIS – Gantt Chart with Conditional Formatting

10:46

PCskill

About Course

DCA Computer Course syllabus

Course Content

Computer Fundamental (6 videos)

1 – Computer Parts Introduction

2 – CPU Hardware Parts

3 – Desktop Icon Settings

4 – Keyboard and Mouse Information

5 – Software Installation

6 – Change Computer Password

Microsoft Word (33 videos)

1- Introduction to Microsoft Word

2- Use Clipboard Group Of Home Tab

3- Text Formatting in Microsoft Word

4 – Line and Paragraph Spacing

5 – Sort Paragraph, Bullet and Number Lists

6- Using Find, Replace, and Go To

7- Page Setup And Printing

8- How to Create Custom Cover Pages

9- Hyperlink, Bookmark And Cross Reference

10- Creating and Formatting Tables

11- Insert Pictures in Word

12- Insert ClipArt & Online Image

13- Using Word Text Boxes

14- Create a SmartArt graphic

15- Add or Edit Shapes in Microsoft Word

16- Create or Run a Macro

17- Create Fillable Forms

18- Use Autocorrect in Word

19- How to Insert Watermarks

20- Set Default Hindi Font And Font Size

21- Check Spelling and Grammar

22- Perfect Text Alignment Using Tabs

23- Add Footnote And Endnote

24- Insert Caption in Word

25- Insert Table of Contents

26- Create a Bibliography, Citations, and Referencess son

27- Microsoft Word Best Keyboard Shortcuts

28- Letter Format Example and Writing Tips

29- How to Create a Resume in Word

30- Using Mail Merge in MS Word

31- How to Use Sum Formula in Word

32 – Create Certificate in MS Word

33 – How To Make Visiting Card

Microsoft Excel (90 videos)

1- Microsoft Excel Introduction

2 – How to Work in Excel And Use Basic Formulas

3- Use Clipboard Like Pro Full Explain

4 – Organize Row Column And Worksheet

5 – Data Entry Like Pro

6 – Create Your Own Custom List

7 – How Make Password your Excel File

8 – How To Create a Backup Excel File

9 – How to Use Sum Formula

10 – How to Use Skip Blanks

11 – Subtract, Multiple, Divide And Percentage

12 – Use of Number Format in Excel

13 – Use Conditional Formatting

14 – How to Sort & Filter Data

15 – Using Find and Replace and Using GoTo

16 – How to Use Status Bar

17 – Freeze Panes Option

18 – Split Window

19 – Fill Option

20 – Flesh Fill

21 – Pivot Table

22 – All Table Option

23 – Pictures Option

24 – Use Shape

25 – Use 3D Modal

26 – Smart Art

27 – Advanced Charts & Graph

28 – People Graph

29 – Create Hyperlinks

30 – Header and Footer

31 – Write, Insert, or Change an Equation

32 – Using the Draw Tab

33 – How to Use Themes

34 – Complete Page Setup