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 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 13 years in different sections of Data Analysis/Management and MIS & Reporting domain. I am teachingAdvanced Excel & VBA Macrosfrom last 7 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, www.vbamacrosexcel.com

  • 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 CorporateSessions In Companies like:Ernst & Young (EY),WNS, Sa-pient,Capgemini, Bank Of America, Colgate-Palmolive, Airbus,Hindustan Unilever Ltd,MagnetiMarelli, 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, 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 AutomatedProjects 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 Business 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: 9871076667, 8750676667.
       Web: www.advancedexcel.net, www.vbamacrosexcel.com