
Professional Diploma in computer Application (PDCA) course at Anil Computers , Udaipur.
Join PDCA Course at our Anilcomputers, Udaipur Center. To Get PDCA Course Syllabus, Fee Structure and Complete information you can contact us.
– Fundamentals to Computer
– Software and Hardware Definition
– Input & Output Devices
– Parts of computers and their functions
– Secondary Storage Devices (CD, DVD, Pen Drive etc.)
– Mail Merge
– Macro
– Hyperlink
– Bookmark
– Password
– Macro
– Footnote–Endnote
– Track Changes
– Table Formats
– Document Protection
– PDF Creation
– 5 Types Tabs
– Speed Checking
– Many Short Commands
– Heading Styles
– Letter Paid
– Resume
– Project Report
– Cover Pages
– Introduction to Excel
– Concept of Sheet and Workbook
– Advanced Page Setup
– Print Settings(Advanced)
– Freeze
– Sort & Filter
– Styles
– Basic Formulas and Functions
– Charts (Graphs)
– Office Use Formats
– Photo Album
– Business Presentation
– Animation Show
– Custom Show
– Project Presentation
– Time Table
– Information Board
– Co. Profile
– Training Presentation etc.
– Many Short Keys to work Smartly
– Calculator
– Defragmenter
– Scan disk
– Antivirus Scan
– What is Turn off & Log off
– Character Map
– Disk Cleanup
– Devices Formatting
– Fonts Installation
– Printer Installation
– Software Uninstallation
– Why computer speed go slow & than what will You do etc.
– Theory of Internet
– E-mailing
– Downloading
– You Tube
– Attachments
– On Line Form Filling
– SMS sending
– Result Searching
– Chatting
– E-mail ID creation
– Video Conferencing
– Searching
– Save data on mail Address
– Attachments
– Skype
– Team Viewer
– Face Book
– E Ticketing
– E- Cards
– Password Changing
– Google Earth etc.
– Google Map
– Online Mobile Recharge
– Govt. Sites etc.
Kundli Pro
Windows Explorer
WinZip
Scanning
- Workbooks (File) & Worksheet Handling
Excel Limitation
Excel Shortcut use and benefits
Excel Setting and Custom List Creation
Excel Tamplate and File Location System
Advanced Paste Special
Calulation with Paste Special
Link Data range as Picture Link
Loopkup Picture in Excel Worksheet
- Advanced Formating for Reports and Dashboard
Formatting Triks
Date & Time For Trinks
Advanced Custom Formating (Number Format using Code)
Condtional Formatting
Advanced Conditional Formatting using Formulas
File,Sheets or Cells Protection Method
Benefits of Data Table or Cells Style
- Data Handle and Data Analysis
Data Fill and Selection Method
Advanced Sorting and Filter Trinks
Data Summerization with Pivot Table
Calculation with Pivot table
Extranal Data Pivot Table
Relationship and Slicer in Pivot Table
Power Pivot in Excel 2016
Use SQL Query in Pivot Table
- Page Setting and Form Creation
Drow Form in Excel Sheet
Hyperlink in Excel
Text and Symbol
Page Setup
Manage View
Sheets Option and Arrange
- Calculation (more then 200 Formulas)
Mathameticals Calculation in Excel
Logical Formulas (IF, and, Or, Xor, IfError Formulas)
Nested If Formulas ( Multi Condition in If,and,or )
Text and Advanced Text Formulas
Date and Time Calculation using Data Time Formulas
Ref# Formulas and VLookup
Lookup Method(VLookup,HLookup,Match,Index,Offset)
Advanced VLookup and VLookup Listing
Math & trico. Formulas
Data Summerization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS,LARGE,SMALL and more)
Database and list managment Formulas
Information Formulass
Financial Formulas
- Advanced Formulas
Advanced Array Formulas
Complicated Large Formulas Creation
Advanced Naming Method with Formulas
Report Automation with Formulas
Live Automation Projeact
Use Formulas in Conditional Formatting
New Formulas Creation with VBA Programming
- Databse and Other Application Conectvity
MS Access Database Conectvity
Notepad and Webdata Connectvity
Embed Other Application
SQL or Oracle Connectvity
SQL Query in MS Excel 2016
File & Folder Directory Access
- Dashboard Report Automation
Chart Creation
Chart Triks
use Button on chart
Dynamic Chart with Offset Formulas
Dashboard Example
Live Project
– Basics of Accounting
– About The Tally
– Tally Installation
– Company Creation & Basics Settings of Tally
– Ledger Creation
– Voucher Type (Use of Function Keys)
– Journal Entries
– Multiple Ledger Creation
– Deleting of Ledgers, Groups, Vouchers etc.
– Security System
– Balance Sheet, Trial Balance, Profit & Loss
–Ratio Analysis, Invoice (Bill) Printing all Type Reports
– Voucher Mode/ Invoice Mode
– Single Entry Mode
– Practical Problem Solutions (Tips)
– Backup Cos. / Restore Cos.
– Company Deleting
– Financial Year Changing
– CD/ DVD Writing / Calculator
– Group creation
– Bill By Bill Details
– Control Buttons (F11 & F12)
– Inventory (Stock Control)
– Zero Values Entries
– Units of Measure Simple & Compound
– Godowns / Location
– Stock Journal / Physical Stock
– Bill of Materials (BOM)
– Company Examples
– Payment Advice
– Confirmation Letter
– Reminder Letter
– Split Companies
– Groups of Companies
– Short Cut Keys (To do work Smartly)
– Budget & Credit Limits
– Cost Center & Cost Categories
– Post Dated Entries
–Banking & Auto Bank Reconciliation etc.
– Scenario Management
– Optional & Reversing Journal Entries
– Sales Order & Purchase Order
– Quotation, Performa Invoice
– Reorder Level
– Debit Note & Credit Note
– Batchwise Details
– Stock Ageing Analysis
– Import data Lower version to Higher Version
– Data Export in Excel
-GST (Goods & Services Tax)
– TDS (Tax Deduction at Sources)
– TCS (Tax Collect at Sources)
– Point of Sales
– Service Tax (For Professionals)
– CST (Central Sale Tax)
– Interest Calculator
– Multi Price Level (For Dealers, Retailers etc.)
– Multi Currency
– Scheme Entries Etc.
– Multi Colour Designing
– Office Stationery
– Visiting Cards
– Posters, Brochures
– Wedding Cards, Advertisements
– Letter Heads, Calendar
– Banners, Bill Book
– Multi Layer Designs
– Logo Designs, Greeting Cards
– Tools etc.
– Image Editing
– Photo Mixing
– Multiple Photos Programme
– Boarder Creation
– Marriage Photos
– Karizma Album
– Tools, Special Effects, Cards
– Short Commands
(To do Work Smartly)
– Jewellery Effects, Pagadi, Shuits etc.
– Black & White Photo to Color Photo
– Modeling Photo
– Digital Ball
– Clouds Effects
– Rainbow
– Realistic Water Reflection Fire
– Sparkle Trail
– Realistic Water Drop
– Light Through Blinds,
– Hair Color
– Water Reflection etc.
-Introduction To Adobe Photoshop
-Resizing & Cropping Images
-Masking & Clipping
-Working With Basic Selections
-Getting Started With Layers
-Painting In Photoshop
-Photo Retouching
-Introduction To Color Correction
-Using Quick Mask Mode
-Working With The Pen Tool
-Animation
-Creating Special Effects
-Exporting Your Work
– Book Composition
– Thesis Work
– Project & Other Reports
– Office Stationery
– Bio Data, Posters, Folders, Resume
– Banners, News Papers
– Multi Layer Designs, Tools
– Letter Heads
– Calendar
– All type of DTP Work.
Principles and basics of print media, Designing layouts
with vector and raster graphics using Adobe InDesign
This course offers the following modules:
- Module 1: Getting Started
- Module 2: Creating and Viewing a Document
- Module 3: Managing Pages and Books
- Module 4: Managing Text
- Module 5: Formatting Text
- Module 6: Placing and working with Graphics
- Module 7: Working with Objects
- Module 8: Managing and Transforming Objects
- Module 9: Applying and Managing Color
- Module 10: Working with Tables
- Module 11: Working with Styles
- Module 12: Finalizing Documents
- Module 13: Exporting a Document
- Module 14: Printing and Outputting a Document
- Module 15: Setting Preferences
- 2D:-
- INTRODUCTION
- CREATING DRAWINGS BY DRAW COMMANDS.
- MODIFICATIONS OF DRAWINGS BY USING MODIFY COMMANDS.
- CREATING ARRAY.
- DRAFTING SETTINGS.
- DIFFERENT SELECTION METHODS.
- ADD ANNOTATIONS TO THE DRAWINGS LIKE-(TEXT,DIMENSIONS,MULTILEADER,TABLES)
- STYLING OF TEXT, DIMENSIONS, MULTILEADER, TABLES.
- HOW TO WORK WITH LAYERS.
- AREA CALCULATIONS.
- HOW TO DRAW PROJECTIONS TO CREATE SECTIONS AND ELEVATIONS (FRONT, SIDE VIEW ETC).
PT:-
- ADVANCE SELECTION METHODS.
- CREATING GROUPS.
- DESIGN CENTER
- BLOCKS AND DYNAMIC BLOCKS.
- CREATING REUSABLE CONTENTS.
- CREATING TOOLPALATTES.
- CREATING TEMPLATES.
- CREATING ATTRIBUTES.
- HYPERLINK, DATA EXTRACTIONS, DATA LINKING, OLE OBJECT.
- EXTERNAL REFERENCES.
- HOW TO CREATE 2D PARAMETRIC DESIGN.
- PLOTING AND PUBLISHING.
- PRINTING BY LAYOUT.
- MANAGE SHEETS BY SHEETSET MANAGER.
- SCRIPTING.
- EXPRESS TOOLS.
3D:-
- SOLID PRIMITIVES.
- EXTRUSION OF 2D OBJECTS.
- BOOLEAN OPERATIONS.
- CREATIONS OF 3D SOLIDS BY USING SWEEP AND LOFT.
- SOLID EDITING COMMANDS.
- CREATING 3D ARRAY.
- CREATE 3D OBJECTS BY REVOVLING 2D SHAPES.
- CREATING SURFACES.
- MESH MODELING.
- CREATING 3D SECTIONS.
- APPLY BACKGROUND TO 3D MODELS.
- APPLY LIGHTING EFFECTS.
- APPLY MATERIAL TO 3D OBJECTS.
- RENDER.
- MOTION PATH ANIMATION (WALK THROUGHS).
- Introduction of Keyboard
2. Shortcut Keys for Special Charters
3. Practical Training
4. The Movements of Fingers
5. Instructions of Typewriting
6. Speed Practice
7. Letters Typing
8. Tables Typing
9. Manuscripts Typing Etc.
& Get Free Typing Book.
Career Oportunity for PDCA Students
After the completion of of course Student pursue their careers in various fields like DTP, Acounting, Interior Designing, Computer Operator, Office automation works etc
What is PDCA Course?
The 7 months Professional Diploma in computer Application (PDCA) conducted by Anil Computers, Udaipur has been designed for meeting the demand of the growing needs of experts in the fields of computers, internet, operating systems, office automation, Autocad, Tally,, Adobe Indesign, Corel Draw, Software Intallation etc.