This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can edited to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins.

Topics Covered

1. Introduction to Visual Basic 2. Object Orient Programming concepts and Illustration 3. Excel Object Model 4. VBA Data Types 5. Operators :- a. Arithmetic Operators b. Comparison Operators c. Logical Operators d. Concatenation Operator 6. Basic Excel Operations a. Dialogs in VBA screen b. Defining Constants c. Defining variables d. Defining Global variables e. Defining Static variables 7. Working with Functions a. Creating Functions using Optional Arguments b. Creating Private Functions c. Creating Public Functions 8. Working with Subroutines a. Creating Subroutine using Arguments b. Creating Subroutine using optional Arguments c. Creating Private Subroutines d. Creating Public Subroutines 9. Handling errors 10. Working with Message Box 11. Decision Statements 12. Looping Statements 13. Working with User Forms 14. Developing different Consolidation Tools using VBA programming 15. Database Connectivity using VBA 16. Introduction to SQL Server 17. Making connections in SQL Server through VBA 18. Concept of Recordset 19. Retrieving records from database 20. Updating records to database 21. Adding records to database 22. Deleting records from database 23. Creating Excel based application 24. Creating Time saving tools 25. Creating Add-Ins

Who should attend

Executives and managers who have already been using Microsoft Excel, but now want to automate Dashboard and Reporting.

Pre-requisites

Participants attending this training should be familiar with the operations in Microsoft Excel.

What you need to bring

Notepad and Pen Drive

Key Takeaways

• Write macros to automate routine work. • Create functions and procedures • Design and use forms for database connectivity • Create add-ins to deploy at client machines • Create automated reports