Andrei OkhlopkovAssociate Director, Private Equity Follow 92
- views 14k
- users 1.0k
- reviews 198
- Best Practices 14
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 92
BioI have recently passed my 20-year milestone in financial modelling and analysis. Being passionate about building all sorts of models, analytics and VBA applications, I also enjoy sharing my knowledge (a part of which is presented here, in the attached files).If you need more help than what you found here, I can:- advise you on specific aspects of financial modelling- build models, forecasts or analytics for you from scratch- coach you on various modelling, Excel and VBA matters
Tags
Social
Unlocking Full Potential of Excel Data Tables (Part 1)
The model explains how to show models outputs under different scenarios simultaneously.4,612Discussadd_shopping_cartfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data408Discussadd_shopping_cartfreeGuiding principles of Financial Modelling
The file explains the general principles of building financial models with a few practical examples.923Discussadd_shopping_cartfreeAnalysing data in Excel
A set of techniques for working with data in Excel1,621Discussadd_shopping_cartfreeMonte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo analysis in Excel without macros9672add_shopping_cartfreePortfolio Analysis and Sales Forecasting
A set of templates to describe the current sales performance and to make predictions and sensitivities for the future472Discussadd_shopping_cart$12.00Sensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model1,1151add_shopping_cartfreeForm Controls and Other Interactive Tools in Excel
An overview of form controls, ActiveX controls and hyperlinks used in financial models.1,1452add_shopping_cartfreeDates and Timelines in Excel Financial Models
Financial models use dates and timelines very extensively, so it is important to become familiar with relevant functions1,404Discussadd_shopping_cartfreeCharts and Dashboards in Excel (short version)
Explains the basics of building professional quality charts in Excel587Discussadd_shopping_cartfreeUnlocking Full Potential of Excel Data Tables (Part 2)
This is an enhanced version of my 'Unlocking Full Potential of Excel Data Tables (Part 1)' post577Discussadd_shopping_cart$15.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model128Discussadd_shopping_cart$10.00How to create a macro state (on/off) indicator
Explains how to add an indicator to Excel VBA files showing whether the file was opened with macros enabled or disabled.64Discussadd_shopping_cartfreeCharts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)212Discussadd_shopping_cart$20.00
Eloquens Member