5.0 Upto 12 Month
English / हिंदी में सीखें

Advance Diploma in Computer Application (ADCA)

One Year Advance Computer Diploma Course in Dehradun offer Diploma seekers an opportunity to learn the skills, knowledge, and resources necessary to build a successful & lucrative career.

Rs.23300 61% off Rs.60500

Free Advance Courses Demo Class Complimentary class with Certificate

Duration

Advance Diploma in Computer Application (ADCA) is upto 12 Month Course

Instructor Led

Interact with real trainers to clear your doubts

Real Life Assignment

Learn-by-doing model for real-life problem-solving skills

Expert Faculties

Get trained by industry experts for in-depth learning experience

Certification

Get Digital and Physical course completion certificate

SYLLABUS Advance Diploma in Computer Application (ADCA)

Basic Word 26 Topics

  • Introduction to Word

  • Page Setup (Margin, Orientation, Columns, Page size)

  • Save & open a document

  • Create new document

  • Breaks (Page Break & Column Break)

  • Hyphenation & Line Number

  • Document Formatting(Change in font, change in font size, highlighting text and change in text color)

  • Change case

  • Format Painter

  • Strikethrough, Double Strikethrough, Small Caps, All Caps

  • Bold, Italics & Underline

  • Subscript & Superscript

  • Indent & Line spacing options

  • Working with Tables

  • Bulleted and Numbered List

  • Change Text Direction

  • Find and Replace

  • Spell Check

  • Working with Text Box

  • Header and Footer

  • Draw a Shapes

  • Working with images in the document

  • Add a Drop Cap

  • WordArt and Watermark

  • Page Border and Page Color

  • Business Bills, Invoices and Receipts

  • How to insert symbols

  • Multi-level List

  • Step by Step Mail Merge Wizard

  • Select and Edit Recipients List

  • Envelopes and Labels

  • Hyperlink and Bookmark

  • Insert a SmartArt Graphics and Charts

  • Selection Pane

  • Thesaurus, Word Count, Translate and Language

  • How to create a cover page

  • Insert date and Time

  • Take a Screenshot

  • Arrangement of Objects

  • Introduction to Excel

  • Saving Workbook and Adding / Deleting Renaming Worksheets

  • Basic calculations : Sum, Product, Factorial, Square Root, Average, Max, Min, Mode & Median

  • Basic functions like Count, Counta & Count Blank, Upper, Lower, Subtotal

  • Data Sorting

  • Format Painter

  • Text to Column, Text Formatting

  • Filter, Rand Function

  • Average and AverageA

  • Count, Counta and Countblank

  • How to insert and delete a cell, row and column from a worksheet

  • Round, Roundup, Rounddown

  • Date & Time Functions like Date, Day, Month, Year, Today, Hour, Minute, Second

  • Charts

  • Multicategory Chart

  • Static Transpose

  • Find Depreciation of an Asset

  • Logical Functions like IF, IF-Else

  • Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim

  • Lookup

  • Subtotal Function

  • Rank Function

  • Rand and Randbetween

  • Sumproduct

  • Choose

  • Format as table

  • Conditional formatting

  • Page setup & Print

  • Freeze Panes

  • Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,

  • Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions

  • Introduction to PowerPoint

  • Create a presentation

  • Slide Setup

  • Save a presentation

  • Choose a slide design

  • Text Formatting in Slides (Change in font, change in font size and change in text color)

  • Text Alignment in Slides

  • Background formatting in slides

  • Working with Text box

  • Insert Pictures

  • Draw a shapes

  • Add Symbols

  • Working with Tables

  • Change Text Direction

  • Insert a Smartart & Chart

  • Text formatting through WordArt

  • Different types of Slide Layout

  • Create a Photo Album

  • Insert a Screenshot

  • Adding Audio and Video to your Presentation

  • Transitions and Animations

  • Create custom slideshow of slides

  • Date and Time & Slide Number

  • Different views in PowerPoint( Normal, Outline view, Slides Sorter, Notes Pages, Reading View)

  • How to Page Setup

  • Create Basic Shapes

  • Multi-Page Corel document

  • Corel Templates

  • Rulers, Grids and Guidelines

  • Shortcuts of Basic Commands

  • Freehand Tool create custom Shapes & Logos

  • Shape Tool, Connector, Bezier, Pen, Artistic Media, Polyline, Interactive Connector, Dimensions more tools for drawing in Freehand Tool

  • Blend Options Blend, Contour, Distortion, Drop Shadow, Envelope, Extrude, Transparency

  • Color Palette, Effects and Gradient

  • Objects Lock, Unlock, Grouping and Ungrouping

  • Weld, Trim and Intersect, Place inside Container

  • Text, Paragraph, Fix text to Path

  • Images using Powerclip

  • Bitmaps convert color mode

  • Using Layers

  • Layers Panel in Photoshop

  • Layer Blending Modes

  • Lock Layers

  • Brush & Pencil Tool

  • Creating and Resizing Artboards

  • Rectangular & Elliptical Marquee

  • Lasso Tool make Perfect Selection

  • Shapes with Pen Tool

  • Custom Shapes

  • Image filled Shapes

  • Quick Selection and Magic Wand

  • Crop images In Photoshop

  • Eraser, Background Eraser and Magic Eraser

  • History panel

  • Slice tool allows you to divide an image into smaller sections

  • Blur, smudge and sharpen tool in image

  • Dodge, Burn & Sponge tool to brighten darken and Increase the color

  • Clone and Pattern stamp tool

  • History and Art history brush tool

  • Add dust & splatters to an image & text for a grunge effect.

  • ACTIVITIES (change cloth, skin teeth color, website layout, design shapes with pen tool)

  • Introduction to HTML 5

  • HTML Document Structure

  • Best practices of Saving & Naming HTML Document

  • Text styling using heading, paragraph & formatting Tags

  • Insert Images to web page

  • Insert Audio & Video

  • Create Ordered, Unordered & Definition List

  • Create advance HTML Tables

  • Linking web pages together using Anchor Tag

  • Adding Forms to web page using difference input types

  • Using iFrame

  • Getting started with CSS

  • CSS Selectors (Class and ID)

  • Working with Inline, Internal & External CSS

  • CSS Box Model

  • Color & Formatting with CSS

  • Relative vs. Absolute position

  • The Box, Boxes in Boxes

  • Debugging with Chrome Developer Tool

  • Handling spacing & layouts

  • Create Navigation with CSS

  • Formatting Forms, Input

  • Getting Familiar with Tally Prime

  • Fundamentals of Tally Prime

  • How to create company in Tally Prime

  • Working with Ledgers and Groups

  • Recording day to day Entries in Tally Prime

  • Inventory Management in Tally Prime

  • Inventory Masters

  • Inventory Books & Reports

  • How to create Purchase & Sales Voucher

  • Order Processing

  • Reorder Levels

  • Maintain Bill Wise Details in Tally Prime

  • Debit & Credit Notes

  • Delivery, Receipt & Stock Rejection in Tally

  • Cost Center & Cost Categories

  • Create Budget in Tally Prime

  • Payment, Receipt & Contra Voucher

  • TDS Tax Deducted at source

  • TCS Tax Collected at source

  • Setting price list for Wholesalers, Semi-Wholesalers and Retailers

  • Optional or Quotation vouchers in Tally

  • POS (Point of Sales) method for multi-mode payments

  • Payroll management in Tally Prime

  • BOM (Bills of Material) in Tally Prime

  • Cost of a particular project in Tally Prime

  • How to create Company & Set Rate in GST

  • Creating Tax Ledgers

  • Recording GST Local Purchase

  • Recording GST Interstate Purchase

  • Recording GST Local Sales

  • Recording GST Interstate Sales

  • Record Payments and Receipts

  • Recording an Advance Payment to Supplier

  • Purchase from Unregistered Dealers

  • Sale of Composite and Mixed supplies under GST

  • GST Sales Nil Rated, Exempt, SEZ, Deemed Export and Consumer sales

  • Creating GST invoices for E-commerce operators

  • Creating GST Export Taxable invoices with currency change

  • Import of goods & services

  • Creating E-way Bills

  • Exporting GSTR-1, GSTR-2, GSTR-3B data to excel

  • Import data from Tally to Tally

  • GST Offline Tool

  • Why Typing Skills are important

  • Learn Keyboard letters from A to Z

  • 25 Learning Lessons

  • MS WORD- Format documents efficiently in Word using Microsoft Word Styles

  • MS WORD- Create dynamic layouts using various techniques

  • MS WORD- Create Mailing labels and Form Letters by Performing Mail Merge

  • MS EXCEL- Create and manage Spreadsheet Layouts

  • MS EXCEL- Increase your efficiency by creating and using important Excel shortcuts

  • MS POWERPOINT- Make great presentations using the Conditional and Table formatting options

  • COREL DRAW- Create Professional Business Card Designing

  • COREL DRAW- Create Designer Catalogue

  • COREL DRAW- Create Logo

  • COREL DRAW- Create Covers/Packing

  • CORAL DRAW- Design a Pamphlet & Advertisements

  • CORAL DRAW- Change the color of T-SHIRT

  • COREL DRAW- Make a Banner

  • CORAL DRAW- Design Letter Heads

  • CORAL DRAW- Design the shapes with the Pen Tool

  • PHOTOSHOP- Create a creative cinematic effect

  • PHOTOSHOP- Create a Website Layout

What you'll learn Advance Diploma in Computer Application (ADCA)

  • Improve ability and skills by doing work in lesser time
  • How to create a mail merge in Microsoft Word
  • Using columns, indents, Headers & footers, borders and watermarks
  • Format documents effectively using Microsoft Word
  • Create Pivot Table and Charts in MS Excel
  • Expertise in Lookup and Reference Function
  • Animations and Transitions in MS-Power Point
  • You will be able to design specific logos with basic shapes
  • Distort and apply drop shadow and 3D effects to objects
  • You will combine 2 photographs to create amazing compositions
  • Accounting with every type of transaction such as payment, receipt, sale, purchase
  • Create GST reports,adjust input tax credit and make GST payments
  • How to build a custom website with HTML, CSS
  • Learn how to create forms and to choose great fonts for your website

Get Free Participation Certificate

Take a demo class & get the FREE Certificate

Upcoming Batches

  • JOIN NOW And Get 61% Scholarship

  • Friday 01-Nov-2024

    Upto 12 Month

    Classroom / Online

    Weekday & Weekend

  • Monday 04-Nov-2024

    Upto 12 Month

    Classroom / Online

    Weekday & Weekend

  • Tuesday 05-Nov-2024

    Upto 12 Month

    Classroom / Online

    Weekday & Weekend

  • Friday 08-Nov-2024

    Upto 12 Month

    Classroom / Online

    Weekday & Weekend

About Advance Diploma in Computer Application (ADCA) Course in

In today’s competitive job market, having digital skills is a must. Proficiency in computers is one of the most sought-after skills by hiring managers. Advance Diploma in Computer Application Program offers instruction in the following applications: Essential MS Word, Essential MS Excel, Essential MS PowerPoint, Corel Draw, Photoshop, HTML, CSS, Tally Prime with GST (Goods & Services Tax) and Computer Typing.
ISPL Academy bring you the most comprehensive Diploma Program in Advance Computer Application. Whether you are a professional or a beginner, ADCA (Advance Diploma in Computer Application) course will give you the expertise you need to excel in your career or your day to day digital activities. Our expert trainers and real-life assignments will make sure that you learn accurate, complete and up-to-date skills. This course is especially useful for students who want to start their career but lack the skills required in the job market. This course makes you job-ready. ADCA coure is also useful for Housewives, teachers, professionals who could not get a chance to learn computer earlier and are now feeling themselves left behind because of no computer knowledge and are totally dependent on others for their simple computer tasks. ISPL Academy invites all of you to become computer literate and start afresh.

Exam & Certification Advance Diploma in Computer Application (ADCA)

An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.

Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.

ISPL Academy Certificate Sample

Advance Courses Alumni

Frequently Asked Questions

The duration of the course Advance Diploma in Computer Application is 12 months.

The fee of the course Advance Diploma in Computer Application is Rs.23300/-

This course covers MS Word, MS Excel, Power Point, Corel Draw, Adobe Photoshop, HTML, CSS, Computer Typing, Accounting in Tally and GST (Goods & Services Tax).

In today’s competitive job market, having digital skills is a must. Proficiency in computers is one of the most sought-after skills. This course is especially useful for students who want to start their career but lack the skills required in the job market.

Bulk Training for Corporates, Government and Institutions

Classroom Learning

GMS Road Dehradun 99974-11884

Tilak RoadDehradun 99974-11885

Start your own centre Become a Partner