NOTE: This module is included in the "Master of Visual Basic" Course, but also available here as a standalone module.

This module is for analysts who need to go beyond the VBA basics to create models for multiple users or with more complex operations.

Because this is a modeling, not a Visual Basic course, you will learn only selected VBA capabilities such as:

• Workbook navigation techniques
• Cell, worksheet, and workbook protection techniques
• Creating, opening, and saving workbooks and worksheets
• Importing data
• Managing ranges
• And other selected skills

The features of this module are:

• An explanation of the use of increasingly complex VBA constructs and features
• Step-by-step user instruction: as you navigate, the correct Excel worksheet is displayed
• Paced examples and use cases
• Access to “Help” at all times: extensive help for working with Excel and VBA and dealing with financial and accounting concepts