Financial Analysis Using MS-Excel
Purpose:
The course is designed to sharpen the financial skills of Government
Officers to adopt analytical approaches in Financial Matters at their work-space
for ensuring proper compliance of Financial Rules.
Who participated in the course?
The course
built up the capacity of 31 Officers
including Principals, Assistant Professors, District Statistical Officers, Sub-Divisional
Officers, Head of Offices, and Accounts Officers.
What has been covered in this course:
At the end of the course, the participants
became able to (i) describe the financial functions which can be simplified
through financial analysis, (ii) use Spreadsheets (MS-Excel) for preparing
spreadsheet for Tax Deduction at Source, (iii) use Spreadsheets (MS-Excel) for
computation of Medical Reimbursement, Retirement Benefits etc, (iv) use Date
and If Functions to simplifying the financial operations, (v) analyse the financial
information through Filtering and Graphical presentations.
