Become A Partner
Advanced Excel MIS Training Center

Advanced Excel MIS Training Center

Online Live Training Any Ware, India
Last Updated : Apr 23, 2014
3674 views

Related Categories : Educational Materials

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 Fee Individual Level - Complete Course 65 Hours : - 15000/- Corporate Training (2 days 9:00 X 2) - Complete Course 18 Hours : - 30000/- 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: - Benefited of Our Training * 100% Live and Practical\'s Training * Received Every Classes Video Recording For Practice * Job Helping Nature * Working Professional Trainer 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 Skype ID - advexcel1

No review posted
Please login to post your review. Click here to go to login page.

Recent Blogs

Manaslu Trek Compelte Guide

Manaslu Trek Compelte Guide

Manaslu trekking circuit is among the best trekking routes in Nepal. Nevertheless, due to the popularity of the other trekking routes like Annapurna Base Camp trekking and Mount Ev...

read more
Foreign Investment in Nepal step by step guide

Foreign Investment in Nepal step by step guide

Foreign investment springs growth, progress, change in a positive way and brings the progress of physical, economic, environmental, social and demographic components.  Foreign...

read more
Kathmandu to Everest basecamp Complete Guide

Kathmandu to Everest basecamp Complete Guide

Mark Twain, a famous poet and writer once quoted and said, “Travel is fatal to prejudice, bigotry, and narrow mindedness., and many of our people need it sorely on these acco...

read more
x