CERTIFICATE IN COMPUTERISED FINANCIAL MANAGEMENT
SYLLABUS
INTRODUCTION TO PROFESSIONAL ACCOUNTING
TALLY PRIME
- Enterprise structure
- Vouchers
- Inventory management
- Payroll
- Order processing
- Gst& tds application
- Budgeting
- Price list
- Banking
- Cost centers
MS EXCEL
- Computer Basics – Hardware & Software – Generalized software.
- Introduction to MS Excel – Work books – Work sheets/Spreadsheets (Adding sheets, deleting & Renaming sheets) – Datatypes in Excel – Spreadsheet Analysis – Calculations using MS Excel – Accounting related analysis – Comparison tests – generating reports using MS Excel.
- Formatting the sheet – Explaining groups in Home Tab – Font – Clipboard – Alignment – Number – Wrap Text – Merge & Center.
- Using formulas in MS Excel.
- Excel Functions – Basic functions in Excel.
- Assignment 1- Preparing Mark list of 5 students.
- Filling series – sorting the list (Using Filter & Sort Button and using Data-sort).
- Conditional formatting.
- Inserting Headers and Footers, Text boxes, Word Art and Comments.
- Assignment 3 – Preparation of Data table (What if Analysis).
- Preparing charts using the Data table prepared.
- Page Layout tab – Margins, size, Orientation and Print Area.
- Formulas tab – Logical functions.
- Mathematical and Lookup functions
- Data Validation
- Practical’s
ELIGIBILITY
+2/Degree
DURATION
140 hrs (Approx. 3 months)
COURSE COVERS
- Introduction to professional Accounting
- Tally prime
- Advanced excel
FAQ'S
Frequently Asked Questions
Training plays a very important role in understanding the concept better. However, the students must be able to put into practice what they have learned during the training so as to get placed in a good organization.
Students who have completed the course successfully are eligible for placement assistance.
We have a dedicated team that is responsible for the placement activities of all the programs we provide.
You must practice all the topics discussed in the class and obtain clarifications from the faculty wherever required. The faculty can guide you on the preparation that needs to be taken before attending interviews.
Placement depends on the vacancies available and the extent to which the candidates perform in the interview.
We have a very good track record when it comes to placement. Since its inception, we had made it a point to deliver the best to all our students thus helping the students have a bright future ahead. All our students have received the best placement.
