Course Objective List
Diploma in Applied Finance and Accounts

Computerized Financial Accounting Using Tally.ERP 9
The financial strength and status of an organization indicate the stability, reliability, and future prospects of the organization. Therefore, every financial transaction, investments, and funds need to be efficiently managed and maintained. A computerized accounting package enables finance and accounting professionals to maintain books and records accurately for all business transactions for an organization. The course briefly covers ‘Generally Accepted Accounting Principles’ and concentrates on applied techniques on a computerized financial accounting package, such as Tally. After completing this course, the learners will be able to:
  1. Understand and apply General Financial Accounting Principles
  2. Use Double entry method of book-keeping
  3. Create and maintain the chart of accounts
  4. Handle different types of vouchers & recording of transactions
  5. Create and maintain inventories
  6. Maintain bills/invoices details and track receivables and payables
  7. Create and maintain cost-centres & budgets
  8. Understand and apply funds flow & cash flow statements
  9. Use ratio analysis & compute commonly used ratios
  10. Analyze financial statements
  11. Maintain data accuracy, consistency & backups

Advanced Excel Tools & Techniques for Analysing Data

>Organizations need accurate and updated information to analyze and to take quick and effective business decisions. This information should be readily available at a unified location in a presentable format. To achieve this, organizations need to gather, organize, and analyze information manually or automatically. A spreadsheet tool such as Microsoft Office Excel enables you to streamline and enhance organizations reporting needs with templates, charts, graphics, and formulas, which will allow the data to be analyzed in a variety of formats. The Advance Excel Tools and Techniques for Analyzing Data course help lays the foundation of a smart office worker, who is good at analysis and utilizing office tools to the best of his/her ability. After completing this course, learner will be able to:

  1. Organize, analyze and present data for operations and reporting purposes
  2. Perform "what-if" & data analysis for developing financial, marketing and plans
  3. Use tools & techniques to process and enhance the usefulness of data
  4. Organize and process statistical, mathematical, financial, and logical data
  5. Employ new approaches such as PowerPivot for tabulating and managing data.
  6. Create management dashboards dynamically using PowerPivot &PowerView
  7. Translate analysis into meaningful charts and graphs for better visual appeal
  8. Analyze, interpret, summarizing, and presenting data using PivotTables and PivotCharts
  9. Automate repetitive tasks to minimize manual labor in data analysis

Advanced Computerized Financial Accounting Using Tally.ERP 9

A finance and accounts executive job not only requires sufficient knowledge and learning of general accounting and book keeping, but also requires strong knowledge, skills, and implementation of various advanced financial accounting modules, such as handling complex transactions, interest calculations, budgeting, and statutory and regulatory compliances, such as TDS, VAT, Service Tax, Excise etc. In addition, financial accounting enables the preparation of financial statements, such as Balance Sheets, P/L, including the reporting requirements of profitability, liquidity, solvency, and stability. Apart from conceptual understanding, this course also covers practical implementation of the preceding area of functions and generation of financial statements. In addition, the course covers applied techniques for conformance of various statutory and regulatory compliances in service as well as in manufacturing organizations. Finally, the course also provides an overview and significance of ‘Accounting Standards.’

  1. Understand Taxation basics
  2. Comprehend TDS, PAN, TAN, and other payment methods
  3. Understand Excise
  4. Comprehend VAT, Service tax, etc.

Using Tally, the learner will be able to:

  1. Understand and use voucher classes
  2. Create and Maintain Budgets and scenarios
  3. Create and maintain multiple currencies
  4. Record Service Tax transactions and generate Service Tax reports and challans
  5. Record TDS/TCS transactions and generate TDS reports and challans
  6. Describe various terms related with excise
  7. Record excise transactions for dealers
  8. Generate excise invoice and related statutory reports
  9. Record excise purchase and sales for manufacturers
  10. Identify the significance of ‘Accounting Standards’

Professional Skills I

The first step in starting a career is to create a positive impression. Dressing for success is important to create a first impression, but this needs to be substantiated with an articulate and logical verbal style. In this course a learner will practice and develop speaking skills to present themselves to others, apply techniques for active listening, maintain a conversation, and learn to express thoughts and ideas in a logical & sequenced manner. In addition, the learner will be able to overcome public speaking challenges, prepare speeches, and give presentations.After completing the “Professional Skills I” course, a learner will be able to:

  1. Improve communication skills
  2. Improve self-presentation skills
  3. Work effectively in a team environment
  4. Demonstrate critical thinking
  5. Understand concepts of health, safety and security
  6. Understand methods of planning and prioritizing
  7. Understand the need for values and ethics at the workplace
  8. Demonstrate capability in basic aptitude tests – verbal, numerical, and logic

Advanced Business Analysis: Tools & Techniques

In the current scenario, employees at all levels in an organization are contributing towards the growth by taking timely decisions impacting the overall business success. In this complex corporate scenario the financial or advanced information analysis, the organizations, at times, find it difficult to leverage the information efficiently and effectively from the existing systems. Therefore, such organizations always look for an optimum and perpetual use of various important tools and techniques to perform financial and statistical business analysis. This course builds on from the previous semester course and enables the learners to resolve complex financial analysis, such as Ageing of Creditor/Debtors, Expense Analysis, Billing and Collection analysis etc. This course covers various types of ratio analysis using liquid, solvency, leverage, and activity ratios. The course also discusses some common statistical concepts, such as central tendency values and measures of dispersion, such as mean deviation and standard deviation. Finally, the course enables the learners to generate statistical information from a specified set of information. After completing this course, the learners will be able to:

  1. Understand and apply scenario based problem solving
  2. Apply time value of money with different techniques such as discounted techniques
  3. Perform analysis various ratios such as liquidity, solvency, leverage, activity ratios
  4. Perform financial analysis such as Ageing, Creditor/Debtors Analysis, Expense Analysis, Billing & Collection analysis using varied tools & techniques
  5. Perform statistical analysis such as central tendency values, measures of dispersion, such as mean deviation, standard deviation, trend analysis, correlation & regression

Corporate Finance & Management Accounting

In today’s corporate environment, the finance and accounts executive is considered not only as an accountant for keeping books of accounts but also as a custodian of funds for all the stakeholders. The finance portfolio deals in varied areas, such as decisions in raising funds, investment of funds, proper and effective distribution of funds, price of funds etc. Therefore, the finance and accounts executive is also expected to have enough proficiency and capability not only to understand and decide transactions, but also to explore alternative sources of raising funds and be responsive on their utilization. The prime objective of this course is to make the learners understand how efficiently financial statements are prepared and how these financial statements are utilized fordecision making. This course also covers the concepts, such as Working Capital Management, Project Viability, Capital Budgeting Methodology, Credit Management, Operational reports etc.After completing this course, the learners will be able to:

  1. Working Capital Management & Capital Budgeting :
  2. Operational Reports and its importance:
  3. Monthly Performance Report( Bud vs. Actual)
  4. Quarterly P&L Report( Limited Review)
  5. Project Report and Status
  6. Fund Utilisation

Professional Skills – II

Professional skills also include learning every aspect of a job and doing it to the best of one’s ability. Business writing skills and ability to provide data in standard formats is a key skill, employers look for. In addition, organizations recognize the importance and ability of the individual to learn and develop their knowledge, skills, and competence while at work. In an ever-changing workplace, employers seek employees who are interested in keeping up with new developments and knowledge in the field. This course will enable you to; enhance your Interview handling skills, identify and develop knowledge and skills you need for your job, learn to present data/information in relevant business formats. In addition, you will understand the fundamental concepts of sales, accounting, and customer service. Combination of these skills will help you maintain a professional behavior at your workplace. After completing the “Professional Skills II” course, a learner will be able to:

  1. Appreciate the importance of writing in the Business world
  2. Develop and apply business writing skills
  3. Identify and develop knowledge and skills you need for your job
  4. Create effective resume
  5. Handle Interviews effectively and easily
  6. Practice for aptitude tests
  7. Present data/information in relevant business formats
  8. Obtain and apply feedback from appropriate people on your knowledge and skills
  9. Review your knowledge, skills, and competence regularly and take appropriate action
  10. Understand fundamental concepts of sales, accounting, and customer service and enhance your skill set