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.
No comments:
Post a Comment
I will be happy to hear from you. Please give your comments...