Andrei OkhlopkovAssociate Director, Private Equity Follow 177
- views 26k
- users 1.9k
- reviews 373
- Downloadable Tools 24
Andrei Okhlopkov
Associate Director, Private Equity
Discuss with Andrei Okhlopkov!
Follow 177
BioHello and thank you for stopping by my Channel!I am sharing tips and advice in the areas of:- Financial modeling- Business Analytics- Sensitivity Analysis- Statistics in Excel- Charts and Dashboards- VBA programming- General Excel mattersContact me if you need more help than what you found here.
Tags
Social
Descriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data1,016Discussadd_shopping_cartfreeMonte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo analysis in Excel without macros3,0834add_shopping_cartfreeControlling Outlook from Excel (short version)
Explains how to programmatically link Excel to Outlook884Discussadd_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,554Discussadd_shopping_cartfreeAnalysing data in Excel
A set of techniques for working with data in Excel1,933Discussadd_shopping_cartfreeAnalyzing Sales and Product Performance
Tools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors803Discussadd_shopping_cart$19.00Guiding principles of Financial Modelling
The publication explains the general principles of building financial models with practical examples3,636Discussadd_shopping_cartfreeCharts and Dashboards in Excel (short version)
Explains the basics of building professional quality charts in Excel648Discussadd_shopping_cartfreeForm Controls and Other Interactive Tools in Excel
An overview of form controls, ActiveX controls and hyperlinks used in financial models.1,9052add_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,613Discussadd_shopping_cartfreeSensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model1,5831add_shopping_cartfreeVBA Interface Collection (demo version)
A set of Excel VBA macros aimed at enhancing user interface571Discussadd_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)' publication834Discussadd_shopping_cart$15.00Profit Distribution and Carried Interest Waterfall
A template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall214Discussadd_shopping_cart$30.00Horizontal Waterfall Chart
A smart and efficient chart with detailed step-by-step instructions48Discussadd_shopping_cart$7.00Controlling Outlook from Excel (full version)
Explains how to programmatically link Excel to Outlook148Discussadd_shopping_cart$15.00Interim Budgeting (Reforecasting)
Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts109Discussadd_shopping_cart$20.00Price-Volume-Mix Analysis
Tools and methods to calculate and depict price, volume and mix effects223Discussadd_shopping_cart$39.00VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface125Discussadd_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 model251Discussadd_shopping_cart$10.00Charts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)265Discussadd_shopping_cart$20.00A Chart Showing Three Dimensions of Data
A professionally-designed chart which can show data in three measurements26Discussadd_shopping_cart$5.00Measuring and Modeling Seasonality
A set of very practical tools to analyse seasonal fluctuations62Discussadd_shopping_cart$19.00Inventory Analysis and Management
Inventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders64Discussadd_shopping_cart$20.00
Eloquens Member