Last version published: 09/12/2019 23:09
Publication number: ELQ-46892-4
View all versions & Certificate
Unlocking Full Potential of Excel Data Tables (Part 1)
The model explains how to show models outputs under different scenarios simultaneously.
Andrei Okhlopkov offers you this Best Practice for free!
download for free
Add to bookmarks
The tool allows to see the outcomes of a financial models simultaneously under several scenarios
Financial models with multiple scenarios
4.8 / 5 (40 votes)
Write a review
- Very simplified and precise version. useful
People using this Best Practice also downloaded
Unlocking Full Potential of Excel Data Tables (Part 2)This is an enhanced version of my 'Unlocking Full Potential of Excel Data Tables (Part 1)' post569add_shopping_cart$15.00by Andrei Okhlopkov
Portfolio Analysis and Sales ForecastingA set of templates to describe the current sales performance and to make predictions and sensitivities for the future465add_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 model124add_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)209add_shopping_cart$20.00by Andrei Okhlopkov
Form Controls and Other Interactive Tools in ExcelAn overview of form controls, ActiveX controls and hyperlinks used in financial models.1,134add_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,391add_shopping_cart
Guiding principles of Financial ModellingThe file explains the general principles of building financial models with a few practical examples.907add_shopping_cart
Monte Carlo Analysis (without macros) Excel ModelThis post explains how to run full Monte Carlo analysis in Excel without macros919add_shopping_cart
Descriptive statistics for grouped (weighted) dataCalculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data397add_shopping_cart
Sensitivity analysis Excel Model with indifference curvesAn Excel utility to draw indifference curves for two inputs in a financial model1,073add_shopping_cart
Analysing data in ExcelA set of techniques for working with data in Excel1,611add_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.64add_shopping_cart
Any questions on Unlocking Full Potential Of Excel Data Tables (Part 1)?
The user community and author are here to help. Go ahead!