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…
-
There are no reviews yet.