Overview

This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form Controls. They make working with models more convenient and efficient, and the models themselves – look more professional.

The publication demonstrates what types of controls there are available and shows the differences between Form Controls and ActiveX control. A step-by-step explanations are provided on how to create the controls, set them up, link to worksheet cells and apply formatting.

The file gives several practical tips and formula examples. In particular, using form controls one can change some model assumptions or scenarios from any worksheet quickly. You might have experienced a situation when you had switched you model to e.g. the Upside scenario, started walking through the worksheets, and on some worksheet decided you wanted to look at it un e.g. the Base scenario. You wished there was a way to switch to it immediately, without having to go back to the input sheet, and the file explains how you can do that.

A special example of drop-down lists is the use of data validation functionality. Detailed instructions are given on this as well.

The file also talks about dynamic hyperlinks. It explains how to create them with the HYPERLINK function to jump between the sheets or sections.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Travel Budget
144
0
Travel expenses make up an important and material part of a company’s budget. This template built on the highest professional financial modeling…
HR Analytics and Dashboard
867
0
This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and…
Startup Cap Table
1,518
136
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cap Table with Investor Returns, Derivative Instruments and Charts
1,615
3
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cost-Volume-Profit (Breakeven) Analysis
1,836
142
Cost-Volume-Profit analysis is one of the fundamental types of analysis which deals with product profitability. It classifies the costs into…
“Budget-versus-Actual” Charts
1,553
10
This file contains magazine-quality charts in Excel to illustrate variances between budgeted and actual figures.  Professionally designed charts in business…
See All