=> We will cover Visual Basic for Applications for MS Excel from basics and covert all the topics to make you an expert in writing Macros for real time use=> You will be able to learn all the topics in a simple and easy method

Topics Covered

* Quick revision of MS Excel 2007 application * Why Excel is Great for Developers * Thinking in terms of Objects * Cell and Range References * About R1C1 notation * Working with Name Manager * Excel Error Values * Recording a simple Macro * Setting Macro Security Levels * Running a Recorded Macro * Relative and Absolute recordings * Viewing a Macro Module * Modifying a Recorded Macro * Creating objects to Run Macros * Introduction to Visual Basic for Applications * Visual Basic Grammar=> Objects=> Methods=> Properties=> Variables=> Using Dim=> Constants=> Using Set=> Referencing Cells and Ranges=> A1 referencing style=> Index Numbers=> Rows and Columns=> Named Ranges=> Multiple Ranges=> Offset Cells=> R1C1 reference style * Working with Visual Basic Editor * Working with the Project Explorer * Working with the Properties Window * Working with the Code Module * Running Procedures from the Editor * Stepping through a Procedure * Using the Object Browser * VBA Programming Fundamentals * Writing a sample VBA procedure * Working with comments * Using various Data Types * Working with Variables * Determining Data type * Scoping Variables * Working with Arrays * Creating User-Defined data types * Using VBA built-in functions * Programming Techniques * Using MsgBox Function * Using the InputBox Function * Using the InputBox Method * Manipulation of Objects and Collections * Using GOTO * Using IF statement * Using Nested IF * Using AND and OR * Using FOR…NEXT statement * Using EXIT * Using DO…LOOP Statement * Using DO…WHILE statement * Using Select…Case * Manipulating Objects and Collections * With – End With constructs * For Each-Next constructs * Error Handling * Trapping Errors * Ignoring Errors * To continue with the next line when Macro encounters an error * Working with Sub-Procedures * Declaring sub procedures * Executing sub procedures * Passing arguments to procedures * A realistic example that uses sub procedures * VBA programming tips

Who should attend

* All MS Excel Users who would like to go to the next level and automate work in Excel

Pre-requisites

* Interested people should have minimum knowledge in MS Excel

What you need to bring

* It would be a online training program. Hence, no need to bring any documents. We will email the required documents for reference

Key Takeaways

* VBA Programming Skill * Ability to automate repeated tasks in MS Excel