Pankaj Kumar Gupta

I am Pankaj Kumar Gupta, Working as an Individual and Corporate Trainer for Advanced Excel and VBA Macros. For me Excel is a new learning every day and pairing my knowledge with others. I like to face com-plex situations related to Excel& Macros and find out solutions for them. This is what I have always been very passionate about and that's what I am doing very religiously.

 

Experience as a Trainer & Consultant:

I am working as an Individual and Corporate Trainer for Advanced Excel and VBA Macros. My total working experience is 14years in different sections of Data Analysis/Management and MIS & Reporting domain. I am teaching Advanced Excel & VBA Macros from last 8 years and trained 6000+ working professionals till date.

​

My Key Accomplishments are:

• Founder of Advanced Excel (Institute of Advanced Excel And VBA Macros) Gurgaon. Visit at: www.advancedexcel.net

• Trained 4000+ working professionals from more than 100+ Big Corporates like: WNS, E&Y, KPMG, Copal Partners, Samsung, Bharti Airtel, Global Logic, Cheil India, Arvato, Genpact, AMEX and many more on different platforms like Individual and Corporate Trainings.

 

• Conducted Corporate Sessions In Companies like : Ernst & Young (EY), WNS, Sapient, Capgemini India, Cvent India, AirIndia Sats, Bank Of America, Bharti Airtel India, Tower Vision India, Colgate Palmolive, Genpact, Whirlpool India Ltd., Airbus India, IDP Education Pvt. Ltd., Hindustan Unilever Ltd, Eli Lilly India Pvt. Ltd. , Paras Healthcare, Fortis Hospitals, Medtronic India, National Dairy Development Board Of India, Advanced India Projects Limited (AIPL), Riding House Infotech Pvt. Ltd., Magneti Marelli, Mahindra Comviva, Bertelsmann India Pvt. Ltd, India Shelter Finance Corporation, Online 24X7 India Pvt. Ltd. , Cheil India Pvt. Ltd, Crystal Travels India, Samsung India Ltd, Doosan Power Systems India Pvt. Ltd., V-Mart India, Apparel Training & Design India, Hi-Tech Gears Ltd, Victora Group Of Industries, Shriram Pistons, SKF India Ltd, Musashi Auto India, Shigan Quantum Technologies Pvt. Ltd. , SCCI India Pvt. Ltd, Williams Sonoma, MSM Media, Lexis Nexis India and HK Joon& Company and many more for which I have been bestowed many corporate awards and recommendations.

 

• Visiting Faculty at ICAI (Institute of Chartered Accountant of India) for Advanced Excel & VBA Macros. Trained 1000+ ICAI members and students till date.

 

• Worked on various projects for Automation with the help of Excel & VBA Macros. My Major Automated Projects includes:

• Automated the Financials Consolidation Process, Payroll Process, Expense Recharges, Actual & Budget Analysis and Various MIS and Reports with the Help of Excel &VBA Macros.

• Automated Templates for Income Tax Calculations, TDS& Service Tax Returns Submissions with the help of VBA Macros.

• Automated Templates for General Ledger Upload, Reserve Reconciliations, Fixed Assets Register, and Intercompany Reconciliations Process with the help of VBA Macros.

• Automated Dashboard designing and Employees Time Sheets for various clients.

​

Past Working Experience:

I have total 13 years of experience in Corporates. Worked with companies like (Nestle India Limited, Bechtel India Pvt. Ltd and Torus Business Solutions Pvt. Ltd.), in total of my career I contributed in different areas of Data Analysis, Business Planning and MIS & Reporting profiles. Well versed with different ERP and Business Planning Systems like SAP, Oracle11i, Cognos and OBIS.