Last version published: 08/04/2020 07:22
Publication number: ELQ-51886-7
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.5 / 5 (30 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)' publication974add_shopping_cart
Horizontal Waterfall ChartA smart and efficient chart with detailed step-by-step instructions65add_shopping_cart$7.00by Andrei Okhlopkov
Profit Distribution and Carried Interest WaterfallA template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall418add_shopping_cart$30.00by Andrei Okhlopkov
Interim Budgeting (Reforecasting)Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts143add_shopping_cart
Inventory Analysis and ManagementInventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders150add_shopping_cart
Controlling Outlook from Excel (full version)Explains how to programmatically link Excel to Outlook166add_shopping_cart
Analyzing Sales and Product PerformanceTools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors934add_shopping_cart$19.00by Andrei Okhlopkov
A Chart Showing Three Dimensions of DataA professionally-designed chart which can show data in three measurements31add_shopping_cart$5.00by Andrei Okhlopkov
Price-Volume-Mix AnalysisTools and methods to calculate and depict price, volume and mix effects325add_shopping_cart$39.00by Andrei Okhlopkov
VBA Interface Collection (full version)A set of Excel VBA macros aimed at enhancing user interface186add_shopping_cart$25.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 model266add_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)278add_shopping_cart
Discussion feed for Form Controls And Other Interactive Tools In Excel
The user community and author are here to help. Go ahead!