The 20 hours certification program on Advance Excel was conducted for PGDM FMHO students of Batch 2022-2024 on 27th, 28th, 29th January 2023, 24th and 25th February 2023. The program was conducted by Mr. Tarun Bothra, who offers corporate trainings under the brand name EduShots. In this excel training, students learnt basic techniques including how to use math, logic and text functions, organize data by sorting and filtering, effectively presenting data in several chart formats. They were also taught about advanced techniques such as how to find a value with VLOOKUP, HLOOKUP, create and format PivotTables and more. The students were also introduced to various PowerPoint hacks and basics of Power BI.
At the end of the training, the case study based evaluation was conducted to evaluate the students’ excel skill sets.