ACSTC (A Complete Software Training Course)

Module 1         Basic Computer

• • • Basic Concept of Computer
    • English Typing
    • Hindi Typing
    • Data Entry

MS Word

• • • Font & Paragraph Formatting
    • Editing, Saving & Printing Text Documents
    • Inserting Table
    • Header & Footer
    • Smart Art
    • Page Breaks
    • Using List & Styles, Spelling & Grammar Check
    • Understanding Document Properties & Tabs
    • Mail Merge
    • Document Views & Macros
    • Saving & Protecting Sheets Documents
    • Project Work

Advanced Excel                           

• • • Introduction (MS Excel Window/Interface Parts, File Extension, How to Open/Exit.)
    • All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
    • Entering and Editing Data.
    • Inserting and Deleting Row or Column.
    • Formatting Data
    • Auto fill Lists ( Default lists & Creating new lists)
    • Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
    • Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis
    • Charts (Working With Charts)
    • Logical Functions (IF, AND, OR, NOT, IFERROR)
    • Financial Functions (PMT, PV, RATE, FV, DB)
    • Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, XLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)
    • Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)
    • Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
    • MIS Report (PIVOT TABLE, PIVOT CHART, V LOOKUP, HLOOKUP, ADV. FILTER, SLICER, SPARKLINES, CONSOLIDATE, CONVERT, ABS, SUMPRODUCT, FIND DUPLICATE, TEXT)
    • Project Work
    • and many more…

MS PowerPoint

• • • Creating & Printing Slides
    • Adding Custom Animation
    • Using Slide Transitions
    • Using Charts, Graphs & Photo Album
    • Creating Professional Presentation
    • Project Work

Internet

• • • Introduction to Internet
    • Browser Basics
    • Downloading, Searching, Surfing and Storing Data
    • Online Forms Submission
    • Online Bill Payment
    • Online Ticket Booking
    • and many more..

Module 2       DTP (Desktop Publishing)

CorelDraw

• • • Introduction to CorelDraw tools
    • Set Bar’s
    • PowerClip
    • Logo Design, Book Cover page design, Pamphlet, Brochures, Banner etc.
    • Tracing ( Logo, Cartoon’s )
    • Text Effect
    • Bevel Effect
    • Transforming Objects
    • Outlining & Filing Objects
    • Working with Bitmaps
    • Project Work
    • and many more….

Adobe Photoshop

• • • Introduction to Adobe Photoshop tools
    • Adjustments
    • Layers, Channels, Paths
    • Layer Mask, Vector Mask, Clipping Mask, Quick Mask
    • Retouching Image
    • Color Correction
    • Background
    • Typography
    • Project Work
    • and many more….

Module 3     Tally (Prime) with GST

• • • Basic Concept of Accounting
    • Computerized Accounting
    • Ledger Posting
    • Multiple Ledger
    • All Voucher Entries
    • Accounting Features
    • Inventory Features
    • Balance Sheet
    • P & L Account
    • Multiple Price Level
    • Bank Reconciliation
    • Interest Calculation
    • Stock Summary
    • Post Dated Voucher
    • GST (IGST, CGST, SGST)
    • Knowledge of Taxation
    • Project Work
    • Interview Preparation
    • Job Skill Concepts
    • And Many More…

Module 4

• • • Personality Development
    • Interview Preparation
    • Job Skill Training
    • Basic concept of Hardware

• We expect students must have basic understanding of windows fundamental. However No academic qualification restriction. Students having little understanding of basic accountancy and economics will help in rapid completion of course.

• This course is targeted for students who are preparing for the jobs in different companies.
• The candidate planning for job in accounting fields.
• The enterprise and small level businessman who want to operate their business themselves.
• The accountants which are based on manual system and want to transform in computerized.

Indian Computer Institute, A Complete Software Training Centre has best in class infrastructure and faculty member to provide you best training. Our all course comes with Free personality development classes and English Speaking training.