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)' publication1,258add_shopping_cart$15.00by Andrei Okhlopkov
Van Westendorp’s Pricing MethodDetermines optimal and acceptable price points, plots demand curves, estimates revenue maximisation points365add_shopping_cart$12.00by Andrei Okhlopkov
Price-Volume-Mix AnalysisA comprehensive full-scope model to analyse revenue and profit changes1,588add_shopping_cart$50.00by Andrei Okhlopkov
Inventory Analysis and ManagementInventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders665add_shopping_cart
Profit Distribution and Carried Interest WaterfallA template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall1,250add_shopping_cart$30.00by Andrei Okhlopkov
Due Diligence Tools and MethodsA suite of best practices to perform financial and commercial due diligence652add_shopping_cart$150.00by Andrei Okhlopkov
Measuring and Modeling SeasonalityA set of very practical tools to analyse seasonal fluctuations343add_shopping_cart
Cap Table with Derivative Instruments, Investor Returns and ChartsAdvanced multiple round startup cap table99add_shopping_cart$35.00by Andrei Okhlopkov
Capex BudgetA professional template to budget investing cashflow, fixed asset book values and depreciation321add_shopping_cart$20.00by Andrei Okhlopkov
Analyzing Sales and Product PerformanceTools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors1,133add_shopping_cart$19.00by Andrei Okhlopkov
Loan ScheduleA flexible tool to calculate loan balances and accrued interest276add_shopping_cart$10.00by Andrei Okhlopkov
Stacking PlanStacking plan of an office building242add_shopping_cart$9.00by Andrei Okhlopkov
Discussion feed for Form Controls And Other Interactive Tools In Excel
The user community and author are here to help. Go ahead!