Event Title :
I.T.S UG campus, Finance club organised two days workshop on the topic of “Use of Excel in Finance – Advanced Module” on 26th -27th March 2019Event Time :
10.30AM-03.30PMEvent Date:
27 Mar 2019Event Description:
The objective behind this workshop was to enhance the hands on skills of students in application of MS Excel in Financial Accounting and Financial Management.The guest of the session was Mr. H.N Tiwari from SRCC, University of Delhi. Total 50 students participated in the workshop from all the years of BBA. Topics covered were - Analyzing Data Using Pivot Table and pivot charts, EMI Computation and loan repayment schedule, using dashboard for data interactivity, Summarizing data using Data Analysis toolpak: Descriptive statistics, Moving averages, correlation/covariance tables, regression analysis, Financial Statement Analysis and Forecasting by using excel. All the students were awarded with certificate of participation.
