Andrei OkhlopkovAssociate Director, Private Equity Follow 123
- views 18k
- users 1.3k
- reviews 244
- Downloadable Tools 15
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 123
BioHello and thank you for stopping by my Channel!Having recently passed my 20-year milestone in financial modeling, analytics and VBA programming, I am sharing part of what I know in the following areas:- Financial models- Sensitivity Analysis- Statistics in Excel- Charts and Dashboards- VBA Interactive ToolsIf you need more help than what you found here, I can:- advise you on financial modeling- help you build models from scratch- coach you on various modeling, Excel and VBA matters
Tags
Social
VBA Interface Collection (demo version)
A set of Excel VBA macros aimed at enhancing user interface468Discussadd_shopping_cartfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data886Discussadd_shopping_cartfreeUnlocking Full Potential of Excel Data Tables (Part 1)
This publication explains an advanced method of using data tables for sensitivity analysis in financial models5,310Discussadd_shopping_cartfreeGuiding principles of Financial Modelling
The file explains the general principles of building financial models with a few practical examples.1,012Discussadd_shopping_cartfreeMonte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo analysis in Excel without macros2,5374add_shopping_cartfreeAnalysing data in Excel
A set of techniques for working with data in Excel1,842Discussadd_shopping_cartfreePortfolio Analysis and Sales Forecasting
A set of templates to describe the current sales performance and to make predictions and sensitivities for the future594Discussadd_shopping_cart$12.00Sensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model1,3341add_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,482Discussadd_shopping_cartfreeForm Controls and Other Interactive Tools in Excel
An overview of form controls, ActiveX controls and hyperlinks used in financial models.1,2162add_shopping_cartfreeCharts and Dashboards in Excel (short version)
Explains the basics of building professional quality charts in Excel604Discussadd_shopping_cartfreeUnlocking Full Potential of Excel Data Tables (Part 2)
This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication693Discussadd_shopping_cart$15.00VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface74Discussadd_shopping_cart$20.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model188Discussadd_shopping_cart$10.00Charts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)240Discussadd_shopping_cart$20.00
Eloquens Member