EXCEL VBA ADVANCED COURSE 4 IN INDIA

Course Contents: Unit 1: Introduction 1. Understanding Concepts of Formulas and Usage 2. Understanding Excel Files Unit 2: Spreadsheet Application Development 3. Concept of Spreadsheet Application 4. Steps in Spreadsheet Application Development Unit 3: Programming In VBA 5. What is VBA (Visual Basic for Applications)? 6. Programming Essentials of VBA 7. VBA Sub Procedures and Function Procedures Unit 4: UserForms 8. Alternatives of Custom Dialog Box 9. UserForms: Introduction to Advanced Techniques Unit 5: VBA Advanced Programming 10. Developing Excel Utilities 11. Working with Pivot Tables and Charts 12. Excel’s Event Handling 13. Interacting with Other Applications 14. In-Depth Add-Ins Unit 6: Application Development 15. Modifying the Ribbon Interface 16. Modifying Shortcut Menus 17. Providing online Help for Your Applications 18. Developing User-Oriented Applications Unit 7: Miscellaneous 19. Information about Compatibility 20. Working and Manipulating Files 21. Manipulating Visual Basic Components 22. Understanding Class Modules 23. Working with Colors Explained