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 Excel Macro Trainer & Consultant.

I am working as an Individual and Corporate Trainer for Advanced Excel and VBA Excel Macro Training. 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 Programming Language 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 6000+ 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, Capgemini India, Cvent India, AirIndia Sats, Bank Of America, Bharti Airtel India, Tower Vision India, Colgate Palmolive, Louis Vuitton India, Genpact, Whirlpool India Ltd. , Airbus India, Cairn Oil & Gas, Vedanta Limited, 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, Resurgent India Pvt. Ltd., Suez India Pvt. Ltd., Chegg India, National Dairy Development Board Of India, Advanced India Projects Limited (AIPL), M3M India Ltd., Riding House Infotech Pvt. Ltd., Magneti Marelli, Mahindra Comviva, Arvato India, 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 Reg-ister, and Intercompany Reconciliations Process with the help of VBA Macros.

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