The Department of Commerce and Management organised a 30-hour Online Certificate Course in Advanced Excel for Second Year B.Com students from April 5 – May 6, 2021. 21 students enrolled, and 14 students completed the course. The resource person was Mr. William Vaz, Manager at Infotech Computer Education, Margao.
The main objective of the course was to enable the students to create and edit basic worksheets and workbooks. The course was designed for students who wanted to gain the necessary skills to create, edit, format the worksheets and get certified in using Advanced Excel. The topics that Mr. William Vaz covered during the course were:
1. Auto-fills, common formulas, formatting sheets, fractions etc.
2. Sales forecast, employee database, Advanced filters, What-if Analysis, Goal seek etc.
3. Profit and Loss statement, Common size Statement Balance Sheet, Text Formatting with Stock Statements, Statement of Budget, Depreciation Methods, Compound Interest Calculations, Common-size cash flow statement,
4. Data handling of Departmental Stores, Working with Student Database, Manufacturing Wage Sheet, GST Calculation Sheet etc.
Asst. Prof. Ms. Anupama Gaonkar coordinated the course.
