TIMSR organized a Certification Program on “Advance Excel” for the Students of MMS Semester-III from 31st January 2022 to 13th February 2022. The resource person for the training was Mr. Saraswat Bhattacharyya, Manager at Risk Advisory, Deloitte India and Mr. Sagar Makhija, Deputy Manager at Deloitte India.
The training program was experiential learning for the students. During, the training the students were taught about advanced techniques such as how to find a value with V-LOOKUP, H-LOOKUP, create and format PivotTables, construct formulas and manage a worksheet, Macros, Advanced Excel Visualization, Goal seek and problem solver, Scenario building and analysis. In the advanced excel training, students also learned basic techniques including how to use text functions, organize data by sorting and filtering, analyze complex data, and effectively present data in several chart formats. With the training, students learned how to create scenarios and analyze data.
