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 4
-
-
- English Speaking
- Personality Development
- Interview Preparation
- Job Skill Training
- Basic concept of Hardware
-
