course Advance Diploma In Computer Applications
Courses Information
Duration : 12 Months
Elegiable : 10+2
- MS Paint
- Notepad
- Wordpad
- Typing (Hindi + English)
- Introduction of Computer
- Evolution of the Computer
- Computer Generations
- Types of Computer
- Characteristics of Computers
- Classification of Computers
- Basic Applications of Computer
- Components of a Computer System
- Computer Memories System
- Input Device
- Output Devices
- Concept of Hardware & Software
- Binary System, Decimal Number System
- Computer Virus & Vaccines
- Anti-Virus
- Windows 7/10/11
- Word
- Create a workbook
- Import data from a delimited text file
- Add a worksheet to an existing workbook
- Copy and remove a worksheet
- Search for data within a workbook
- Navigate to a named cell, range, workbook element
- Insert headers and footers
- Insert page number
- Insert and remove hyperlinks
- Change worksheet tab color
- Rename a worksheet
- Change worksheet order
- Insert and delete columns or rows
- Change workbook themes
- Adjust row height and column width
- Hide or unhide worksheets
- Hide or unhide columns and rows
- Customize the Quick Access toolbar
- Modify document properties
- Display formulas
- Inspect a workbook for hidden properties or personal information
- Inspect a workbook for accessibility issues
- Inspect a workbook for compatibility issues
- Create custom number formats
- Populate cells by using advanced fill series options
- Configure data validation
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
- Create and modify simple macros
- Insert and configure for controls
- Create and Excel table from a cell range
- Convert a table to a cell range
- Add or remove table rows and columns
- Apply table styles
- Configure cell margins and spacing
- Merge and split cells
- Resize tables, rows, and columns
- Split tables
- Configure a repeating row header
- Insert total rows
- Filter records
- Remove duplicate record
- Sort table data
- Change sort order
- Insert reference
- Perform calculations by using the SUM function
- Perform calculations by using MIN and MAX functions
- Perform calculations by using the COUNT functions
- Perform calculations by using the AVERAGE functions
- Perform logical operations by using the IF function
- Perform logical operations by using the SUMIF function
- Perform logical operations by using the AVERAGEIF function
- Perform statistical operations by using the COUNTIF function
- Format text by using RIGHT, LEFT
- Format text by using UPPER, LOWER, and PROPER functions
- Format text by using the CONCATENATE function
- Create a new chart
- Add additional data series
- Switch between rows and columns in source data
- Analyze data by using Quick Analysis
- Resize charts
- Add and modify chart elements
- Apply chart layouts and styles
- Move charts to a chart sheet
- Insert text boxes and shapes
- Insert images
- Modify object properties
- Add alternative text to objects for accessibility
- Save a workbook as a template
- Enable macros in a workbook
- Display hidden ribbon tabs
- Protect a worksheet
- Encrypt a workbook with a password
- Create custom number formats
- Populate cells by using advanced Fill Serie options
- Configure data validation
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
- Create custom color formats
- Create and modify cell styles
- Create and modify custom themes
- Create and modify simple macros
- Insert and configure form controls
- Display data in multiple international formats
- Apply international currency formats
- Manage multiple options for +Body and +Heading font
- Perform logical operations by using AND, OR and NOT functions
- Perform logical operations by using nested functions
- Perform statistical operations by using SUMIFS, AVERAGEIFS, and COUNTIFS functions
- Look up data by using the VLOOKUP function
- Look data by using the HLOOKUP function
- Reference the date and time by using the NOW and TODAY functions
- Serialize number by using date and time functions
- Import, transform, combine, display, and connect to data
- Consolidate data
- Perform what-if analysis by using Goal Seek and Scenario Manager
- Calculate data by using financial functions
- Trace precedence and dependence
- Monitor cells and formulas by using the Watch Window
- Define Named Ranges and Objects
- Name cells
- Name data ranges
- Name tables
- Manage named ranges and object
- Create and manage PivotTable
- Create PivotTables
- Modify field selections and options
- Create slicers
- Group PivotTable data & etc.
- PowerPoint
- Access
- Introduction
- Types of Accounts
- Accounting Principles or concepts
- Mode of Accounting
- Rules of Accounting
- Double-entry system of bookkeeping
- Select Company
- Shut Company
- Create Company
- Alter Company
- Security Control
- Change tally vault
- Spilt Company Data
- Backup
- Restore
- Tally audit feature
- Accounting Configuration & Features
- Group Creation
- Multiple Group Creation
- Ledger Creation
- Voucher Creation
- Advance Ledger Creation
- Inventory configuration & Features
- Inventory Info Menu
- Stock group
- Stock categories
- Stock item
- Unit of measurement
- Bills of materials
- Locations/ godowns
- Batches & Expiry
- Inventory voucher types
- HSN Code Updates
- Accounting Voucher
- Inventory Voucher
- Optional & non-accounting voucher
- Order Processing
- Advanced voucher entry
- Cost category & cost centers
- Budgets
- Interest calculations
- Credit limits
- Scenario management
- Reorder level & recorder quantity
- Price level & price lists
- Tally net
- Excise for manufactures
- Excise for dealer
- Value Added Tax
- Tax deducted at source
- Tax collected at source
- Goods and Services Tax (GST)
- Excise for manufacture
- Service Tax
- Tax deducted at source
- Tax collected at Source
- Value Added Tax (Vat)
- Central state tax
- Payroll features of Tally
- Backup & Restore
- Split a company, export & Import of data
- E-Capabilities (E-mail a report from tally E.R.P9)
- Uploading the reports generated from tally E.R.P9
- Tally ODBC Inward connectivity
- Security controls
- Tally Audit Feature
- Tally Vault
- Fill online ITR (Income Tax Return) download and filling forms.
- Fill online VAT, CST Return
- Excise Return & Forms
- Online service tax return
- TCS, TDS
- Concept of GST
- Rate of GST
- GST in other countries
- Categories of GST
- Other Concepts
- Corel Draw 2025
- Working With Palettes
- Viewing Pages
- Working With Text and Graphics
- Moving Between Pages
- Adding and Deleting Pages
- Working With Multiple Open Publications
- Naming and Saving a Publication
- Closing a Publication
- Setting Up Pages
- Changing Document Setup Options
- Setting Up Rulers
- Creating Running Headers and Footers
- Character Formatting
- Paragraph Formatting
- Controlling Windows and Orphans
- Controlling Page Breaks
- Tabs and Hyphenation
- Grid Manager
- Printing a Document
- Placing Graphics
- Sizing And Cropping Graphics
- OLE
- Embedding An OLE Object
- Creating a Master Page
- Numbering Pages
- Setting Up Ruler Guides
- Applying Master Page Design
- Using a Table Editor
- Create Keyline
- Bullets And Numbering
- Creating PDF File with Acrobat
- Story Editor
- Spell Checker
- Working With Palettes
- Viewing Pages
- Working With Text and Graphics
- Moving Between Pages
- Adding and Deleting Pages
- Working With Multiple Open Publications
- Raster And Vector Graphics
- Photoshop Environment Elements
- Navigation In Photoshop
- Image Size
- Resolution
- Cropping
- The Rectangular And Elliptical Marquee Tool
- The Lasso Tools
- Saving Selections
- The Magic Wand Tool
- The Magnetic Lasso Tools
- Modifying Selections
- Floating Versus Fixed Selections
- Undoing Previous Step
- Copying Selection
- Creating Layers
- Transforming Layers
- Copying Layers Between Images
- Arranging Layers
- Saving Images In Photoshop Format
- Saving Images In Jpeg Format & Etc.
- De Fringing
- Opacity And Blending Modes
- Color Modes
- Mode Characteristic
- Grayscale And Bitmap Modes
- Color Modes
- Selecting Colors
- Painting Tools
- Clone Stamp Tool
- Text
- Layer Effects
- Filters, Merging
- Flattening Layers
- Brightness
- Contrast
- Levels
- Adjustment Layers
- Toning Tools
- Hue/Saturation
- Photo Impression
Job Roles:
-
Technical Writer
-
Computer Operator
-
Computer Technician
-
Photoshop Designer
-
Graphic Designer
-
System Officer
-
Applications Support Engineer
-
Clerk
-
BPO Executive
-
Data Entry Operator
Salary Packages:
The salary packages may be in between
Rs.20, 000/- to Rs.35, 000/-.
Areas of Recruitment for ADCA
-
Schools/Universities
-
Government Offices
-
Private Organizations
-
Online Tutor, etc.
Why Join SSP Computer Institute ( एसएसपी कंप्यूटर संस्थान से क्यों जुड़ें? )
- Recognized Institute by the Government of India.( भारत सरकार द्वारा मान्यता प्राप्त संस्थान।)
- An ISO 9001-2015 Certified Institution.( ISO 9001-2015 प्रमाणित संस्थान। )
- All the Certificates and Diplomas are valid in Govt. & Pvt. Sector.( सभी सर्टिफिकेट और डिप्लोमा सरकारी और निजी क्षेत्र में मान्य हैं। )
- Fully Animated Smart Classes(by SmartBoard) ( पूर्णतः एनिमेटेड स्मार्ट क्लासेस (स्मार्ट बोर्ड द्वारा) )
- Latest System and Programmes.( नवीनतम सिस्टम और प्रोग्राम। )
- E-Content (हिंदी & अंग्रजी) (by Android App)
- Experienced & skilled faculty.( अनुभवी एवं कुशल शिक्षक। )
- One Computer for one Student.( एक छात्र के लिए एक कंप्यूटर. )
- Extra Theory & Lab Classes.( अतिरिक्त सिद्धांत और प्रयोगशाला कक्षाएं। )
- Extra Care & guidance for weak student.( कमजोर छात्रों के लिए अतिरिक्त देखभाल और मार्गदर्शन। )
- 100% Job Oriented ( 100% जॉब ओरिएंटेड कोर्स )
- Career Counselling.( कैरियर परामर्श। )
- Placement Support.( प्लेसमेंट सहायता. )
- Online Monthly Test ( ऑनलाइन मासिक टेस्ट )
- Daily Quiz ( दैनिक प्रश्नोत्तरी )
- Promotes independent learning in students ( छात्रों में स्वतंत्र शिक्षा को बढ़ावा देते है )
- Has the potential to lower textbook and tuition prices ( इसमें पाठ्यपुस्तक और ट्यूशन की कीमतें कम करने की क्षमता है )
- Allows teachers to create an exciting way to educate students ( शिक्षकों को छात्रों को शिक्षित करने का एक रोमांचक तरीका बनाने की अनुमति देते है )
- Encourages development of new teaching methods ( नई शिक्षण विधियों के विकास को प्रोत्साहित करते है )
- Prepares students for the future ( विद्यार्थियों को भविष्य के लिए तैयार करते है )
- Instant Access to Knowledge ( ज्ञान तक त्वरित पहुंच )
- Improve Workload ( कार्यभार में सुधार करें )
- Save Time ( समय की बचत )
Your Life is Like Dust
Without Study First
