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, 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, Bank Of America, Colgate-Palmolive, Airbus,Hindustan Unilever Ltd,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, 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 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 Inter company 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.
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: firstname.lastname@example.org, email@example.com
Phone: 9871076667, 8750676667.
Web: www.advancedexcel.net, www.vbamacrosexcel.com