Last version published: 25/02/2019 20:15
Publication number: ELQ-51886-2
View all versions & Certificate
How to change model scenarios or inputs from any worksheet
The attached techniques show how to change inputs and scenarios from any sheet of the financial model without macros.
Andrei Okhlopkov offers you this Best Practice for free!
download for free
Add to bookmarks
Quickly change inputs, assumptions and scenarios in financial models without having to select a specific dedicated sheet
A multi-sheet (i.e. almost any) financial model
The tool has ActiveX controls which do not function on Mac computers. But other controls do.
Write a review
People using this Best Practice also downloaded
Sensitivity Analysis Excel Model - using Data Tables (full version)This is an extended version of my 'Analysing sensitivities with data tables' file with significant enhancements322add_shopping_cart$15.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 model57add_shopping_cart$10.00by Andrei Okhlopkov
Variance Analysis & Portfolio Statistics Calculation Excel TemplateA template to analyse variances between two scenarios (e.g. budget vs. actual) and calculate key portfolio statistics381add_shopping_cart$12.00by Andrei Okhlopkov
Charts and Dashboards in Excel (full version)Explains the basics of designing professional charts in Excel with practical examples (full version)46add_shopping_cart$25.00by Andrei Okhlopkov
Dates and Timelines in Excel Financial ModelsFinancial models use dates and timelines very extensively, so it is important to become familiar with relevant functions1,150add_shopping_cart
Sensitivity Analysis Excel Model - using Data Tables (short version)The model explains how to show models outputs under different scenarios simultaneously.2,412add_shopping_cart
Guiding principles of Financial ModellingThe file explains the general principles of building financial models with a few practical examples.839add_shopping_cart
Monte Carlo Analysis (without macros) Excel ModelThis post explains how to run full Monte Carlo in Excel without macros564add_shopping_cart
Descriptive statistics for grouped (weighted) dataCalculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data77add_shopping_cart
Sensitivity analysis Excel Model with indifference curvesAn Excel utility to draw indifference curves for two inputs in a financial model247add_shopping_cart
Analysing data in ExcelA set of techniques for working with data in Excel1,344add_shopping_cart
How to create a macro state (on/off) indicatorExplains how to add an indicator to Excel VBA files showing whether the file was opened with macros enabled or disabled.48add_shopping_cart
Discussion feed for How To Change Model Scenarios Or Inputs From Any Worksheet
The user community and author are here to help. Go ahead!