Diploma in Computer Application (DCA)

One Course to cover all basic and advanced aspects of computer - from Basic Computer Hardware to Microsoft Office Suite, CorelDraw, Photoshop, Advanced Excel, Google Sheets and much more.

Bestseller

4.8

(231)

Sample Certificate

₹2800 ~~₹14000~~ 80% off

Add to Cart More about this course

This course includes

500+ Video Tutorials
Access on mobile & computer
2 Year access to all video lessons
Industry recognised Certification
Lifetime certificate validity
Online verification of your certificate

₹2800 ~~₹14000~~ 80% off

Add to Cart More about this course

This course includes

500+ Video Tutorials
Access on mobile & computer
2 Year access to all video lessons
Industry recognised Certification
Lifetime certificate validity
Online verification of your certificate

What you'll learn

Iss course mai hum ye topics cover karenge:

Computer Fundamentals
All about Computer Hardware
Software Installation
Internet & Email
Learn Computer Assembling
Control Panel Settings
Windows 7/10/11 Installation
Basics of Windows Operating System
How to create a Gmail Account
Google Drive & its Use
Microsoft Office Suite
MS Word
MS PowerPoint
MS Excel
Advanced Excel
Google Sheets Full Course
Adobe Photoshop
Adobe PageMaker
CorelDraw
Smartphone Tips

Requirements

Basic Internet access
Basic Hindi & English understanding
Access to Computer or Smartphone

Topics for this course

Computer Fundamentals

1. Main Parts of a Computer
00:13:39
2. Computer Hardware
00:09:20
3. Computer Desktop & Icons
00:08:45
4. Keyboard Keys & Mouse
00:11:15
5. Installing & Uninstalling softwares
00:09:45
6. Computer Settings
00:09:17

Computer Hardware

1. Computer Introduction
00:12:00
2. Input Devices
00:07:23
3. Back Panel of CPU
00:07:41
4. Open Cabinet
00:06:15
5. Remove Internal Connections of CPU
00:08:28
6. Open Motherboard
00:06:24
7. Remove CPU Fan
00:05:42
8. Remove CPU
00:07:48
9. Remove Ram
00:05:51
10. Remove CPU Fan 2
00:09:46
11. Assemble Front Panel
00:09:25
12. Assemble Power connector
00:05:32
13. Assemble Motherboard
00:05:57
14. Assemble Harddisk Setup
00:05:58
15. Assemble Complete CPU
00:15:00
16. Open Harddisk Drive
00:15:00
17. Troubleshoot SMPS
00:06:48
18. Check SMPS Power with multimeter
00:10:10
19. SMPS Internal Structure
00:15:28
20. Insert and Remove Graphic Card
00:15:28
21. Motherboard All Parts in Depth
00:09:15
22. North Bridge and South Bridge
00:06:43
23. DVD Writer Attach and Detach
00:03:44
24. Hardware Make Bootable Pendrive
00:05:29
25. Install Windows 7
00:15:22
26. Driver Installation
00:05:00
27. Installing Windows 10
00:10:42
28. Software Installation
00:07:38
29. User Account Settings
00:18:29
30. Drive Partition
00:12:21
31. Hide Drive
00:04:45
32. Hide folders using folder lock software
00:09:53
33. Recover Deleted files
00:05:08
34. DOS Commands
00:26:35
35. Troubleshooting
00:14:33
36. Download ISO File & Create Windows 10 Bootable Pendrive
00:07:54
37. Reset Windows 7 Password
00:09:57
38. Reset Windows 10 Password Using Bootable Pendrive
00:11:18
39. BIOS Password Settings
00:10:05
40. BIOS Basic Settings
00:06:14
41. Windows 11 Installation in Virtual Machine
00:08:02
42. Laptop Internal Parts – RAM, HDD & More
00:13:41

Internet & Email

1. Use of Browser
00:12:18
2. Creating Gmail Account
00:11:51
3. Send Email with Attachments
00:11:29
4. Google Drive Use
00:12:49
5. Downloading a video
00:07:38
6. Network Information
00:11:20
7. Download Aadhar card
00:08:01
8. Save Password Settings
00:07:46
9. Google Input tools
00:07:42
10. Hindi Typing on Computer
00:05:21

MS Word

1. Introduction to MS Word
00:25:37
2. Font & Formatting Options
00:18:43
3. Cut, Copy, Paste & Format Painter Options
00:09:46
4. Paragraph Formatting, Find & replace Function
00:16:04
5. Insert Tab - Inserting Tables, photos etc.
00:26:07
6. Design Tab - Page Border, Watermark etc
00:12:03
7. Page Layout Tab Settings
00:13:08
8. Spelling Check & Index Functions
00:15:38
9. Letters & Mailing (Mail Merge)
00:18:08
10. Restrict Editing Function
00:11:34

MS Excel

1. Introduction to MS Excel
00:24:59
2. Basic Formatting in Excel
00:25:26
3. Filter, Sort Functions
00:15:00
4. Charts & Tables in Excel
00:20:16
5. Pivot Tables & Charts
00:13:05
6. V Lookup and H Lookup
00:12:06
7. Use of Macros in Excel
00:06:50
8. Hyperlink in Excel
00:08:11
9. Print Settings
00:06:20
10. Conditional Formatting
00:11:51

MS PowerPoint

1. Introduction to MS PowerPoint
00:10:45
2. Adding content to Slides
00:15:38
3. Slide Designing
00:09:03
4. Transitions & Footer options in Slides
00:09:32
5. Adding Animations & Sound Effects
00:13:54
6. How to make Photo Albums in PowerPoint
00:11:48

Google Sheets

1. Google Sheets Introduction
00:13:15
2. Use of Functions
00:09:25
3. Inserting and Deleting Sheets, Navigating Sheets
00:11:48
4. Paint Format, Currency Format, %Age Formula
00:12:23
5. Enable Keyboard Shortcuts, Format Sheet
00:08:19
6. Hyperlink and Insert Comment
00:08:40
7. Share sheets with multiple people and word together
00:08:24
8. Insert Chart & Format Chart 1
00:10:31
9. Insert Chart & Format Chart 2
00:11:30
10. Sort and Filter Options
00:12:22
11. Save Filter, Create Filter
00:07:29
12. Filter formula
00:07:15
13. File Menu – Save Version History, Open Excel file
00:10:00
14. File Menu – Publish file to web
00:06:09
15. Printing Tips
00:08:20
16. Edit Menu – Paste Special
00:10:16
17. Edit Menu – Find and Replace
00:08:45
18. View Menu – Freeze Panes
00:08:45
19. Insert Menu 1 – Image, Rows, columns
00:12:03
20. Insert Menu 2 – Google Forms Link to Google sheets
00:11:13
21. Insert Menu 3 – Check Boxes, Create To do List
00:06:02
22. Format Tab – Conditional formatting, Number formatting
00:11:36
23. Data Menu – use of Slicers
00:07:10
24. Data Menu – Data Validation
00:17:18
25. Pivot Table – Create summerize reports
00:12:22
26. Add Named Ranges and apply formula
00:07:15
27. Google Protect Worksheet and Range
00:09:07
28. Split Text to Columns, Remove Duplicates
00:08:41
29. Macro Recordings
00:10:06
30. Accessibility Options
00:06:36
31. Mail Merge – Send Bulk Emails
00:09:14
32. IFS formula use
00:04:44
33. Text Join and Concatenate formula
00:07:38
34. Google Translate formula
00:04:38
35. Vlookup and Hlookup in Google Sheet
00:12:13
36. Countif, Countifs, Sumif, Sumifs
00:12:30
37. Sumif, Sumifs Formula in Google sheet
00:05:04
38. Count Unique IFS new formula
00:05:31
39. Sparklines Formula Bar, Columnline Chart
00:09:32
40. All IsFormula – Isemail, IsNumber, Istext
00:07:30
41. Create QR Code using Formula
00:05:57
42. All useful Text Formulas
00:11:43
43. All useful Number Formulas
00:09:35
44. Get Unique Record
00:03:27
45. Use of Query Formula – Remove Blanks
00:06:36
46. Import Data from Web
00:04:19
47. Merge Sheets Data
00:07:15
48. Merge Workbooks
00:12:54
49. Remove Blank rows tricks
00:06:12
50. Offset Formula Introduction
00:09:15
51. Real Use of Offset Formula
00:09:20
52. Create Monthly report dashboard
00:11:13
53. Sequence and Rand Formulas
00:05:45
54. Unique Rank Formula
00:07:20
55. Send Auto Email – Add On
00:14:31
56. Copy Down Formula Add On
00:11:58
57. Query Formula 1
00:08:21
58. Query Formula 2
00:07:38
59. Query Formula 3
00:07:42
60. Project On Query Formula
00:20:23

Adobe Photoshop CC 2019

1. Photoshop Introduction
00:24:44
2. Eyes Effect – Elliptical Marquee Tool
00:19:18
3. Change Lips Color Using Polygonal Lasso tool
00:15:30
4. Mirror Effect – use of Transform Tool
00:15:13
5. Selection Tools and Feather Effects
00:12:23
6. Use Lasso Selection Tools
00:10:28
7. Fit Image into Object using Transform
00:12:29
8. Create Passport Size Photos
00:09:50
9. Use of Quick Selection and Magic Wand tool
00:11:22
10. Use of Pen Tool – Blur Image Background
00:10:38
11. Change Image Background
00:09:32
12. Use of Shapes
00:16:07
13. Apply Effects on Shapes
00:06:31
14. Text Fire Effects
00:13:44
15. Text Tools and Options
00:13:35
16. Download Design Fonts & Hindi Typing
00:10:00
17. Text Effects
00:11:15
18. Create PNG Image
00:05:38
19. Create Pattern
00:09:55
20. Clone Stamp Tool
00:09:23
21. Remove Black spot from Face
00:06:21
22. Create GIF Image
00:10:59
23. Create Animated Advertise
00:10:48
24. Layer Panel Options
00:13:17
25. Advance Crop
00:12:04
26. Create advertising Template
00:14:29
27. Healing Brush Tool Content Aware Tool
00:19:57
28. Brush Tools
00:15:42
29. Pattern Stamp Tool
00:09:26
30. Art History Brush tool
00:08:25
31. Eraser Tools
00:12:30
32. Gradient Tool
00:11:26
33. Blur Tool, Smudge Tool
00:06:47
34. Dodge, Burn, Sponge Tool
00:08:00
35. Pen Tools in Details
00:22:27
36. Create Your Custom Shape
00:19:19
37. Create Layer Mask
00:07:13
38. Create Layer Mask
00:07:28
39. Actions – Reduce 1000 Image size with one click
00:14:01
40. Create Poster
00:18:46
41. Remove Fences Effect
00:08:12
42. Image Menu – Color Tones, Replace Color
00:14:38
43. Convert to Smart Object
00:09:54
44. Cliping Mask – Add Image into Mobile cover and Text
00:13:08
45. 3D POP Out Effect in Photoshop
00:11:23
46. Select Menu in Detail
00:15:58
47. 50 Shortcut keys to Boost working Speed
00:21:12

Adobe PageMaker 7.0 Lessons

1. PageMaker Introduction
00:03:07
2. Page basic
00:01:41
3. Shapes
00:01:45
4. Frames
00:03:21
5. Line, Crop Tools
00:02:02
6. Text Tools
00:02:11
7. Master Page
00:02:00
8. Saving The Publication
00:01:55
9. Closing The Publication And Quitting PageMaker
00:01:27
10. Importing text and picture
00:00:50
11. Column master Guide
00:02:45
12. Insert Object
00:02:04
13. Mask and unmask
00:02:57
14. Text wrap
00:03:02
15. Align Text
00:01:36
16. Bullets and Numbering
00:01:25
17. Index And Table of Contents
00:04:29
18. Colour Palette
00:03:41
19. View option
00:01:43
20. Edit Layout
00:01:20
21. Group and Ungroup
00:02:03
22. Lock & Unlock
00:01:48

CorelDRAW X5 Lessons

1. CorelDRAW Introduction
00:24:34
2. Practical use of knife tool
00:18:50
3. Practical use of shape tool
00:18:27
4. Practical use of power clip
00:14:50
5. Practical use of envelope tool and more
00:11:56
6. Practical use of eraser tool
00:11:03
7. Practical use of star shape
00:05:00
8. Practical use of weld option
00:08:38
9. Practical use of round corners option
00:07:39
10. Use of blend tool in Logo
00:10:57
11. Import image in Corel and create film strip
00:10:59
12. Add perspective effect on text
00:04:59
13. Rotate object and create design
00:14:09
14. Use of all pick tools and shape tools
00:20:37
15. Use of Eraser, knife and crop tools
00:09:17
16. Use of pen tool and other line tools
00:17:23
17. Use of artistic media brush tools
00:11:39
18. Use of rectangle and ellipse tools with weld options
00:09:51
19. Use of poylgon, star, spiral, graph tools
00:24:09
20. Use of text tool and hindi typing, free font installation
00:13:24
21. Draw table, use of dimensions tool
00:15:59
22. Drop shadow and contour tool
00:18:32
23. Use of blend, envelope, extrude tool
00:16:09
24. Use of transparency, interactive fill, smart fill tool
00:16:44
25. Create alphabet logo
00:08:26
26. Create professional business card
00:27:10
27. Modern business card
00:08:13
28. Design Certificate in Corel
00:20:41
29. Create professional employee ID card
00:11:02
30. Design Poster in CorelDraw
00:12:55
31. Design T-shirt
00:09:33
32. Design banner using Corel tools
00:12:56
33. Double exposure effect in Corel
00:09:09
34. Design Stamp in Corel
00:08:40
35. 40+ keyboard shortcuts
00:35:48
36. Symbol manager
00:11:58
37. Create logo using tools
00:10:42
38. Design menu card
00:18:25

Smartphone Tips

1. Using GMAIL on your Smartphone
00:07:14
2. Using Google Drive on Smartphone
00:05:44
3. Use of Google Maps
00:04:55
4. Using Google Pay
00:04:24
5. Mobile Settings
00:05:37

Tally Prime Introduction

1. Download and Install Tally Prime
00:09:53
2. Create Company in Tally Prime
00:12:53
3. Alter Company Data
00:10:16
4. Tally Vault Password
00:09:35
5. Tally Company
00:08:15
6. Tally Create Users & Security
00:12:25
7. View Tally Reports in Mobile / Browser
00:05:52
8. What is Accounting Explain in Hindi
00:09:45
9. What is Financial year
00:07:58
10. Create, Alter and Delete Group
00:16:52
11. Create Ledgers in Tally Prime
00:10:02
12. Create Multiple Ledgers in Tally Prime
00:05:18
13. Different Ledgers and Their Meanings in Tally
00:10:48
14. Business First Voucher entry in Tally
00:18:03
15. Receipt Voucher – Goods sold on cash
00:05:40
16. Receipt Voucher – Amount received in cash
00:08:31
17. Receipt Voucher – Amount received in cheque
00:05:27
18. Contra Voucher – 1
00:11:40
19. Contra Voucher – 2
00:07:30
20. Payment Voucher
00:07:09
21. Payment Voucher
00:11:25
22. Purchase Voucher
00:12:34
23. Sales Voucher
00:07:19
24. After Purchase Sales
00:08:05
25. Journal Voucher
00:09:42
26. Adjustment Entries – 1
00:09:49
27. Adjustment Entries – 2
00:05:20
28. Purchase Return And Sales Return
00:11:11
29. Assignment on Voucher Entries – 1
00:13:58
30. Assignment on Voucher Entries – 2
00:15:29
31. Assignment on Voucher Entries – 3
00:15:42
32. What Is Accounting Cycle
00:08:13
33. What Is Balance Sheet
00:05:19
34. Stock Entries – 1
00:06:06
35. Stock Entries – 2
00:11:00
36. Stock Entries – 3
00:08:30
37. Stock Entries – 4
00:05:30
38. Cost Centers Introduction – 1
00:16:53
39. Cost Centers Hide Details
00:04:28
40. Cost Centers Example – 1
00:06:35
41. Cost Centers Example – 2
00:07:59
42. Keyboard Shortcuts
00:16:23
43. Multiple Stock Item Entries
00:09:57
44. Stock Transfer – Stock Journal Vouchers
00:08:08
45. Physical Stock Voucher
00:05:05

Trading Organization Accounting in Tally Prime

1. Organization Types
00:05:26
2. Trading Organization Accounting
00:07:30
3. Purchase Order
00:15:57
4. Receipt Note Voucher
00:07:05
5. Rejection Out Voucher
00:06:54
6. Purchase Invoice
00:09:41
7. Debit Note – Purchase Return
00:09:41
8. Sales Order
00:13:18
9. Delivery Note-1
00:07:31
10. Rejection In-1
00:04:57
11. Create Sales Bill-1
00:08:12
12. Credit Note – Sales Return-1
00:08:27

TDS In Tally Prime

1. TDS Introduction 1
00:14:41
2. TDS Introduction 2
00:10:25
3. TDS on Interest
00:07:07
4. Frequently Asked Questions
00:05:14
5. TDS Entry in Tally
00:11:31
6. TDS Adjustment Entries
00:10:37
7. TDS Certificate 1
00:11:40
8. TDS Related Questions
00:09:20
9. TDS Entry as a Deductor 1
00:13:47
10. TDS Entry As A Deductor 2
00:12:53
11. TDS Entry As A Deductor 3
00:13:08
12. TDS Entry As A Deductor 4
00:04:17
13. TDS Payment 1
00:10:38

GST In Tally Prime

1. GST Introduction
00:11:09
2. SGST, CGST and IGST Terms
00:05:55
3. GST – What is HSN and SAC
00:07:36
4. What is Regular Dealer and Composition
00:09:00
5. Create Purchase Invoice Intrastate GST
00:27:44
6. Create Purchase Invoice Interstate GST
00:10:20
7. Check Stock and Purchase Register
00:04:59
8. Create Sales Invoice Intrastate GST
00:13:11
9. Create Sales Invoice Interstate GST
00:05:40
10. Check Sales Register and Stock Summary
00:07:08
11. GSTR1, GSTR2, GSTR3B
00:09:47
12. What is E-Way Bill
00:09:02
13. Genterate JSON of E-Way Bill
00:15:03

Start your Second Innings with us.

Private & Government Jobs | Veteran News | Courses | Veteran Seva Kendra

Free Download Google Play Store