Advanced Excel VBA Macros Training Center

Advanced Excel Training Center

About the CoursernToday, many individuals and working professionals related to accounts, MBAs wish to learn Advance Microsoft Excel, VBA, Macro, Reporting, Access and many more advanced commands to get familiar with Excel and also to develop desired reports from the data. Also, there are various other advantages of Advance Excel that can be enjoyed by people who know how to make use of MS-Excel and excel formulas.
Topics Covered
1. Excel All Option and Commandrn2. Advance Formattingrn3. Pivot Data Reporting and Advance Pivot Conceptrn4. More than 200 Excel formulasrn5. Array Formulasrn6. Array with VLookup, HLookup and more Formulasrn7. Formulas Nestingrn8. Other Data Connection (MS Access & SQL Server)
9. Dynamic Chart and Graphrn10. Report Automationrn11. Dashboard Reportingrn12. Excel VBA Editor Conceptrn13. Coding object Modelrn14. Data type , LOOP, IF Elsern15. Excel VBA Event and Formulas Makingrn16. User formrn17. User form Connectionrn18. Outlook Mail Connectionrn19. CDO Gmail connectionrn20. Web Form Connection (VBA to Internet Explorer Connection)
21. Pivot and Chart VBA Eventrn22. Other Application and PowerPoint Connectionrn23. Menu bars and Add ins Creationrn24. And More in Excel 2013
Level-1, - Official Excel TrainingrnLevel – 2 – Excel Advanced Formulas and Other Data Conectvity for AutomationrnLevel – 3 – Excel Dashboard and Report Automation for MIS
Level – 4 – Excel VBA Macros Programming for Report AutomationrnAdd on – MS Access with SQL Statement and VBA ProgrammingrnFee
Individual Level - Complete Course 65 Hours : - 15000/-
Corporate Training (2 days 9:00 X 2) - Complete Course 18 Hours : - 30000/-

Who should attendrnAnyone who wish to make career in data analysis and MIS, Finance Professionals, Students from B.Com / Commercial Background, Administration Section, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments
Pre-requisitesrnBasic Excel Knowledge is mandatory to attend the course
Fee Details: -
Benefited of Our Training

* 100% Live and Practical's Trainingrn* Received Every Classes Video Recording For Practicern* Job Helping Naturern* Working Professional TrainerrnWatch Sample Video Recording of Live ClassrnAdvance Excel and MIS Training with VBA MacrosrnRegardsrnSujeet Kumar SinghrnTel - 011-29967604, 8802579388
www.iptindia.com