BBA(FS) department of the College organized a Certificate Course in ‘MS Excel in Finance’ for
students of SY BBA(FS) from 13th August to 11th September 2018.
The resource person for the certificate course was CA. D. Shravan Swarup, B.Com, ACA, DISA(ICAI),
Partner at Marathe Rao & Swarup, Chartered Accountants. The topics covered were keyboard
shortcuts and navigation in Excel, building flexible formulas in Excel, which included absolute
referencing, preparing financial statements, data management and analysis, data sorting and
filtering. The course also covered creating macros, data validations, trial balance mapping and also
spreadsheet macro creation, other financial functions. The Excel course in Finance was conducted in
two batches for 20 days for three hours a day. The written exam was conducted on 22nd September,
2018. A total of 55 students of SYBBA(FS) completed the certificate course.
