The PGDM–International Business Department of Jagan Institute of Management Studies (JIMS), Rohini organised a comprehensive 3-day workshop in the month of September 2025 for the students of the batch 2025–27. The sessions were conducted by Mr. Jatin Kalra, Assistant Manager, KPMG Global Services (KGS).
With extensive experience in financial consulting at one of the Big Four consulting firms, Mr. Kalra emphasized advanced Excel proficiency for data-driven business environments. The workshop covered practical applications through real-world scenarios from KPMG's client engagements.
Key Takeaways:
Text & Lookup Functions
- LENGTH, FIND, LEFT, RIGHT, TRIM functions for data processing and cleaning.
- VLOOKUP, HLOOKUP, XLOOKUP for database retrieval and cross-referencing.
Logical Functions & Data Management
- IF, NESTED IF, OR, AND functions for conditional analysis and decision-making.
- Data validation, sorting, and filter techniques for organized data management.
Professional Applications
- Integration of functions for comprehensive business analysis and client deliverables.
- Error handling and documentation standards for consulting environments.
An evaluation was conducted on the last day to assess students' understanding of the advanced Excel functions and practical applications covered during the workshop.
The sessions concluded with heartfelt thanks to Mr. Jatin Kalra for sharing his consulting expertise. Students of batch 2025–27 gained enhanced Excel proficiency and industry-standard practices for their future careers.