About the Course

Microsoft Excel spreadsheet software has become an integral part of most business organizations across the world. MS Excel is used for various purposes by business establishments. MS Excel offers a grid interface that allows the user to organize any type of information they require. One of the major advantages MS Excel spreadsheet software is its flexibility feature. This feature allows the user to define the structure of information they need to manage with ease, and this spreadsheet software is very easy to use and even a novice user can use this software. For specialized tasks, the user needs to undergo training and gain hands-on experience to use it in a better manner.

This ‘Certification Course in MS Excel for Finance intends to train and up-skilling the participants with the advanced and latest tools in Microsoft Excel. Participants attending this Course will be tremendously benefitted to learn this powerful tool and to apply the same to solve complex business scenario.

Objectives

To create the synergy between university education and Professional education to enhance the employability of the learners of Department of Public Policy and Governance (DPPG), BK School of Professional and Management Studies, Gujarat University.

CONTENT OF CERTIFICATE COURSE IN FINTECH

Part I: Learn Basics

• Data navigation
• Formatting
• Arithmetic
• Shortcut Keys
• Basic math functions
• Rounding
• Counting
• Text functions
• Sort, Filter, Split, Freeze etc.

Part II: Learn Advanced Concepts

• Financial & Statistical function
• Date, time and Logical functions
• Using important ribbon Interface features
• VLOOKUP, Hookup, Index Match
• Pivot tables
• Power Query
• Power Pivot
• Power BI Desktop

Part III: Application of Concepts

• Valuation of Securities - I
• Valuation of Securities-II
• Loan amortization Tables & FD Calculator
• Option Valuation
• Operation Research Decisions
• Create Models for Problems contributed by the participants

Benefits

• Knowledge about foundations of Financial Statement Analysis
• Fundamental knowledge analysis techniques
• Learn about different software’s of statement analysis
• Learn about Interpretation of Financial data
• Preparation of Budget and other risk evaluation techniques

Host Institute: This course will be offered and managed by B.K.School of Professional and Management Studies, Department of Public Policy and Governance , Gujarat University.

The faculty for teaching this course will be experts from different parts of nation.

This Certificate Course will be offered twice in an Academic year.

Duration of the course: This course will be offered for duration of two months of 60 hours 60 Hrs. ( 60 Hrs/1.5 Hrs.) = 40 Sessions (5 Days in a week. Each day 2 Sessions of 1.5 Hrs. each ).

Timing of the course: Between 7.00 p.m. to 10.00 p.m. (Monday to Friday)

Eligibility: This course will be offered to students / scholars/ professionals who have cleared their graduation /Post-graduation programmes of any discipline from recognised universities.

The student intake will be as per the demand of the course.

Admission criteria: On First Come First Served basis and merit basis (if required).

Fees: Rs. 5500/- only per student/per course (excluding final exam fees)