Templates by Andrei Okhlopkov

1 to 13 of 13 Results
Guiding Principles of Financial Modelling
(0)
1,982
225
The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…
Unlocking Full Potential of Excel Data Table (Part 1) Unlocking Full Potential of Excel Data Table (Part 1)
(0)
1,609
195
A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various…
Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
1,451
188
A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…
Analysing data in Excel Analysing data in Excel
(0)
2,135
174
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
1,355
154
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…
Form Controls and Other Interactive Tools Form Controls and Other Interactive Tools
(0)
1,561
147
This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form…
Analysing sensitivities with indifference curves Analysing sensitivities with indifference curves
(0)
1,088
121
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Dates and Timelines in Excel Dates and Timelines in Excel
(0)
1,061
76
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
Descriptive statistics for grouped (weighted) data Descriptive statistics for grouped (weighted) data
(0)
155
10
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
Charts and Dashboards in Excel (full version) Charts and Dashboards in Excel (full version)
(0)
1,231
3
The attached file: - defines key chart elements and explains how to edit them - demonstrates how to deal with…
Portfolio Analysis and Sales Forecasting Portfolio Analysis and Sales Forecasting
(0)
1,648
2
The attached template provides the basis for product portfolio analysis as follows: - key statistics: total, average, median, standard deviation (total…
Unlocking Full Potential of Excel Data Tables (Part 2) Unlocking Full Potential of Excel Data Tables (Part 2)
(0)
1,551
2
This is a full version of my data table publication which explains how to:   - link several data tables…
Analysing sensitivities with indifference curves (unlocked) Analysing sensitivities with indifference curves (unlocked)
(0)
1,104
1
This is an unlocked version of the same utility published on my page. In this version you can access and…