Description

Vocational Skills in Accounting and Finance Paper – I

(Introduction to Financial Functions)

 

VSC/SEC – (VSEC) Vocational / Skill Enhancement Courses

 

FYBAF Semester I

 

Syllabus (As per NEP 2020) w.e.f. the Academic year 2024-2025

 

Module I : Excel Basics 15 Hours
♦ Introduction to Excel
♦ Understanding the Excel Interface : Tabs and Its Function
♦ Basic Excel Functions and Formulas : Arithmetic Operations, SUM Function, Average Function, MAX/MIN Function, Count Function
♦ Use of Artificial Intelligence Tool for Generating Formulas and Custom Formatting
♦ Formatting in Excel : Table, Rows and Layout

Module II : Financial Functions in Excel 15 Hours
♦ Understanding Financial Functions : Present Value, Future Value, Net Present Value and Internal Rate of Return and Its Calculation Manual and Using Excel
♦ Depreciation Functions : Straight Line Depreciation and Reducing Balance Method and Its Calculation Manual and Using Excel

(Note: The module/s are to be taught with the help of the computer wherever practical exposure is required.)
Information: Model question paper for external exam will be provided during the workshops.