NOTE: This module is included in both the "Master of Financial Analysis" and the "Master of Visual Basic" Courses, but also available here as a standalone module.

This module is for business analysts with basic Excel skills, a broad modeling concept and a handle on model layout, who need to progress to the use of highly interactive models to develop and present information.

Microsoft Excel contains many underutilized features that can help to underscore your recommendations and conclusions. This module provides hands-on training in the use of all the controls resident in the Forms Toolbar.

You will learn:

• How to use the forms toolbar to create powerful presentations
• Techniques for adding color and graphics to Excel
• How to insert appropriate controls to manipulate data in real-time
• How to put them all together for high-impact, interactive presentations

The features of this module are:

• An explanation of the purpose and use of Excel Forms Controls
• 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