Last version published: 01/03/2020 18:40
Publication number: ELQ-51886-6
View all versions & Certificate
Form Controls and Other Interactive Tools in Excel
An overview of form controls, ActiveX controls and hyperlinks used in financial models.
Andrei Okhlopkov offers you this Best Practice for free!
download for free
Add to bookmarks
Quickly change inputs, assumptions and scenarios in financial models or jump between the sheets and sections
Almost any financial model using scenarios and sensitivities
The tool has ActiveX controls which do not function on Mac computers. But other controls do.
4.4 / 5 (15 votes)
Write a review
People using this Best Practice also downloaded
Unlocking Full Potential of Excel Data Tables (Part 2)This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication678add_shopping_cart$15.00by Andrei Okhlopkov
VBA Interface Collection (full version)A set of Excel VBA macros aimed at enhancing user interface70add_shopping_cart
Portfolio Analysis and Sales ForecastingA set of templates to describe the current sales performance and to make predictions and sensitivities for the future581add_shopping_cart$12.00by Andrei Okhlopkov
Sensitivity analysis Excel Model with indifference curves (unlocked)An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model183add_shopping_cart$10.00by Andrei Okhlopkov
Charts and Dashboards in Excel (full version)Explains the basics of designing professional charts in Excel with practical examples (full version)237add_shopping_cart
Descriptive statistics for grouped (weighted) dataCalculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data860add_shopping_cart
Dates and Timelines in Excel Financial ModelsFinancial models use dates and timelines very extensively, so it is important to become familiar with relevant functions1,473add_shopping_cart
Unlocking Full Potential of Excel Data Tables (Part 1)This publication explains an advanced method of using data tables for sensitivity analysis in financial models5,286add_shopping_cart
Guiding principles of Financial ModellingThe file explains the general principles of building financial models with a few practical examples.1,001add_shopping_cart
Monte Carlo Analysis (without macros) Excel ModelThis post explains how to run full Monte Carlo analysis in Excel without macros2,456add_shopping_cart
Sensitivity analysis Excel Model with indifference curvesAn Excel utility to draw indifference curves for two inputs in a financial model1,315add_shopping_cart
Analysing data in ExcelA set of techniques for working with data in Excel1,825add_shopping_cart
Discussion feed for Form Controls And Other Interactive Tools In Excel
The user community and author are here to help. Go ahead!