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

This module if for analysts that need model accounting or financial functions beyond Excel’s offerings.

In this module you will walk through the Excel and VBA set up of solutions to many common analytic calculation problems, such as:

• Multiple depreciation or loan methods
• Complex NPV or IRR calculations
• Consolidation of mismatched data
• Seasonal business planning
• Price or cost sensitivity analysis

Most of the Excel and VBA forms and code can be copied and carefully linked directly into your models.

The features of this module are:

• An explanation of the use of complex modeling solutions
• A guide to concepts
• Specific examples
• Access to “Help” at all times: extensive help for working with Excel and financial and accounting concepts