Excel Advanced Vlookup Formulas in Hindi скачать в хорошем качестве

Excel Advanced Vlookup Formulas in Hindi

Watch Sample Video Recording of Live Class About the Course Today, 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 Command 2. Advance Formatting 3. Pivot Data Reporting and Advance Pivot Concept 4. More than 200 Excel formulas 5. Array Formulas 6. Array with VLookup, HLookup and more Formulas 7. Formulas Nesting 8. Other Data Connection (MS Access & SQL Server) 9. Dynamic Chart and Graph 10. Report Automation 11. Dashboard Reporting 12. Excel VBA Editor Concept 13. Coding object Model 14. Data type , LOOP, IF Else 15. Excel VBA Event and Formulas Making 16. User form 17. User form Connection 18. Outlook Mail Connection 19. CDO Gmail connection 20. Web Form Connection (VBA to Internet Explorer Connection) 21. Pivot and Chart VBA Event 22. Other Application and PowerPoint Connection 23. Menu bars and Add ins Creation 24. And More in Excel 2013 Level-1, - Official Excel Training Level -- 2 -- Excel Advanced Formulas and Other Data Conectvity for Automation Level -- 3 -- Excel Dashboard and Report Automation for MIS Level -- 4 -- Excel VBA Macros Programming for Report Automation Add on -- MS Access with SQL Statement and VBA Programming Who should attend Anyone 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-requisites Basic Excel Knowledge is mandatory to attend the course Fee Details: - • 1.Level 1 to 4 (Advanced Excel & MIS Reporting with VBA Macros) - 12,000/- INR • 2.Level 1 to 3 (Advanced Excel & MIS Reporting) - 65,00/- INR • 3.Level 4 (Excel VBA Macros Programming) - 6500/- INR • 4.Complete(1 to 4 level) with MS Access15,000/- INR Benefited of Our Training *Get the 4 Days Demo Training Free *Our Training is Personal Training only 3-5 Person in one Batch 100% Live and Practical's Training Received Every Classes Video Recording For Practice Job Helping Nature Help for Interview Preparation Watch Sample Video Recording of Live Class Advance Excel and MIS Training with VBA Macros Regards Sujeet Kumar Singh Tel - 011-29967604, 8802579388 www.iptindia.com