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 explains what types of controls there are available, how to set them up, gives practical tips and examples.

 

The file also talks about dynamic hyperlinks to jump between the sheets or sections.

Share
Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Descriptive statistics for grouped (weighted) data
82
5
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
Dates and Timelines in Excel
1,016
70
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
Charts and Dashboards in Excel (full version)
1,183
3
The attached file: - defines key chart elements and explains how to edit them - demonstrates how to deal with…
Charts and Dashboards in Excel (short version)
1,300
139
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…
Analysing sensitivities with indifference curves (unlocked)
1,051
1
This is an unlocked version of the same utility published on my page. In this version you can access and…
Analysing sensitivities with indifference curves
1,043
112
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
See All