Trainers Profile

My Self

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 14 years 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
• Trained 4000+ working professionals from more than 100+ Big Corporates like: WNS, E&Y, KPMG, Copal Partners, Samsung, BhartiAirtel, 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, CANARA HSBC, Capgemini India, Cvent India, Lufthansa Airlines India, AirIndia Sats, Kohler India, RSSB(Rwanda Social Security Board, Central Africa ), Bank Of America, Bharti Airtel India, Tower Vision India, Colgate Palmolive, Louis Vuitton India, Genpact, Whirlpool India Ltd. , Airbus India, Pernod Ricard India, Ranstad India, Azure Power, Tilda Hain India, Maruti Suzuki India, Hero Motocorps India, ACME Cleantech Solutions Pvt. Ltd., Cairn Oil & Gas, Vedanta Limited, Grey Orange Robotics India, FMC Corporation India Ltd, IDP Education Pvt. Ltd., Hindustan Unilever Ltd, Eli Lilly India Pvt. Ltd. ,R1RCM India Healthcare, DDB MUDRA INDIA, Prione India Pvt. Ltd., Paras Healthcare, Fortis Hospitals, Medtronic India Ltd., Resurgent India Pvt. Ltd., Seagram India, Suez India Pvt. Ltd., Chegg In-dia, National Dairy Development Board Of India, Advanced India Projects Limited (AIPL), M3M India Ltd., Riding House Infotech Pvt. Ltd., Magneti Marelli, Mahindra Comviva, Giesecke+Devrient India, GenNX360 India, Quality Council Of India, Arvato India, TreuBlue India LLP, 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 Sys-tems India Pvt. Ltd., People Scout India, Mosaic India Pvt. Ltd. V-Mart India, Apparel Training & Design India, Hi-Tech Gears Ltd, Victora Group Of Industries, Sharda Motor India Ltd., Shriram Pistons, SKF India Ltd, Eastern Bearings India, Sakhi Milk Production, Musashi Auto India, Shigan Quantum Technologies Pvt. Ltd. , Sujan Group Of Industries, Mega Rubber Tech India, SCCI India Pvt. Ltd, Williams Sonoma, MSM Media, Lexis Nexis India and HK Joon& Compa-ny and many more for which I have been bestowed many corporate awards and recommenda-tions.
• Visiting Faculty at ICAI (Institute of Chartered Accountant of India) for Advanced Excel & VBA Macros. Trained 1000+ ICAI members and students till date.
• Guest Faculty At Aligarh Muslim University (AMU) For Advanced Excel & VBA Macros
• 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 Reg-ister, 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 Busi-ness Planning Systems like SAP, Oracle11i, Cognos and OBIS.

Contact Me

You can reach me on below mentioned details :

Pankaj Kumar Gupta
Advanced Excel (Institute of Advanced Excel and VBA Macros).

Address : 177, Gopal Nagar Near City Mark Hotel, Bus Stand Gurgaon - 122001.

Email : info@advancedexcel.net, advancedexcel07@gmail.com

Phone : +91-8750676667, +91-9871076667

Website : www.advancedexcel.net, www.vbamacrosexcel.com