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 Merge
    • 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
    • Manual Accounting
    • Theoretical Framework
    • Introduction to Accounting
    • Accounting Concepts
    • Meaning Objectives
    • Advantages
    • Basic Accounting
    • Terms Accounting Process
    •  Recording of Business Transaction
    • Rules of Debit and credit
    • Recording Transaction
    • Books of Original Entry-Journal
    • Special Books
    • Sales Registers
    • Purchase Registers
    • Allow invoice
    • Accounting Information
    • Inventory Information
    • Ledger Posting
    • Multiple Ledger
    • All Voucher Entries
    • Balance Sheet
    • P & L Account
    • Bank Reconciliation
    • Cost Centre and Cost Category
    • Reversing Journal
    • POS(Point of Sale)
    • Bill Wise Details
    • Billing Software
    • Price Level
    • Export and Import of Data in Excel and other Formats
    • GST
    • TDS
    • E-way Bill Generating Reporting and printing of Invoice

Module 3

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

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