FCA (Financial Computer Accounting)

FCA (Financial Computer Accounting) package all about tools and techniques required to keeping records of different commercial transactions. This course include different data analyzing tools, data entry tools, Tax form filling and fundamental of banking system.

Module 1

• • • Basic Concept of Computer
    • Fundamentals of Computer
    • English Typing
    • Printing
    • Scanning

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 Marge
    • Document Views & Macros
    • Saving & Protecting Sheets Documents
    • Project Work

Advance 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, 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

Tally (Prime) with GST

• • • Basic Concept of Accounting
    • Computrized 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…

• We expect some basic understanding of English.
• No age restriction.
• Basic writing and reading skills.

• 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.