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

This module is intended for those with strong Excel modeling skills who are experiencing some difficulty controlling data in complex analysis situations, or those who need a more professional look to manage inputs or presentations.

Visual Basic offers a significant improvement over simple Excel operations in data management, computations, and appearance.

You will learn:

• How to create powerful pop-up forms to simplify data input
• Simplified workbook navigation
• How to set parameters for computations
• Techniques for properly formatting output

You will practice creating all VBA form controls and coding some algorithms in VBA.

The features of this module are:

• An explanation of creation of Visual Basic for Applications forms
• 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