- Create and format charts.
- Work effectively with multiple sheets in workbooks.
- Use productivity tools.
- Quick analysis tools and work with the Excel list/database features.
VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. Excel, along with the other members of Microsoft Office, includes the VBA language. In a nutshell, VBA is the tool that people use to develop programs that control Excel.This Excel 2013 VBA course is meant to for experienced Excel users who would like to gain expertise in creating procedures with respect to different events, understanding control structures, creating user forms, validating the data, and debugging and handling errors.
- Bussiness Users.
- Students who are interested in Excel.
- Introduction to Excel.
- Introduction to Programming.
- VBA Overview and the IDE.
- Quick Review of Macros.
- Working with Macros.
- How to use Visual Basic Editor (Programming Environment).
- An easy-to-use and versatile language.
- Integrated with off-the-shelf products.
- The Visual Basic Editor.
- Parts of the VBA Editor.
- Modules and Macros.
- About VBA Forms, Sub Procedures & Modules.
- Creating Forms.
- Using Controls and their Properties.
- Running VBA Forms in Excel.
- Objects – The Grammar.
- Using Properties and Methods.
- Understanding Parameters.
- The Object Browser.
- Understanding object hierarchy.
- Tools for better coding.
- Moving to Other Cells.
- Editing Specific Cells.
- Using the Immediate Window.
- Gaining greater control through the immediate window.
- Formatting Cells.
- Using Variables.
- Constants.
- Object Variables.
- Dimensioning and usage of variables.
- Displaying data and obtaining data from the user.
- How and when to declare variables.
- Selecting data types.
- Fixed and dynamic arrays.
- Constants.
- IF (ElseIf, Else).
- Select Case().
- For Next Loop.
- For Each Loop().
- Do Until Loop and Do While Loop.
- With, End With.
- Nesting Code.
- Creating Sub and Function procedures.
- Calling procedures.
- Passing arguments to procedures.
- Communicating with the user through the message box.
- Gathering user information with the input box.
- PUtilizing the File Dialog object and Dialogs collections.
- Command buttons.
- List and Combo boxes.
- Labels.
- Option buttons.
- Check boxes.
- Text boxes.
