About Pankaj Kumar Gupta

Trainer`s 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   complex 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.
Visit at:  www.vbamacrosexcel.com

» Trained 1500+ 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, Cvent India, Bank Of America, Colgate-Palmolive, Airbus India, Hindustan Unilever Ltd,  Paras Healthcare, Fortis Hospitals, Magneti Marelli, Mahindra Comviva, Bertelsmann India Pvt. Ltd,  India Shelter, Cheil India Pvt. Ltd, 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, Williams Sonoma, MSM Media, Lexis Nexis 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 Reportswith the Help of Excel &VBA Macros.
  • Automated Templates ForIncome Tax Calculations, TDS& Service Tax Returns Submissions with the help of VBA Macros.
  • Automated Templates forGeneral Ledger Upload, Reserve Reconciliations, Fixed Assets Reg-ister, and IntercompanyReconciliations 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.