Excel

Guiding Principles of Financial Modelling Guiding Principles of Financial Modelling
(0)
5,354
653
This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…
Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below) Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below)
(2)
6,672
600
Making a waterfall chart is a powerful yet simple, visually attractive and compact way of visualizing the cost structure of…
Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
4,547
532
A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
4,538
529
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Analysing data in Excel Analysing data in Excel
(0)
5,470
520
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Unlocking Full Potential of Excel Data Tables (Part 1) Unlocking Full Potential of Excel Data Tables (Part 1)
(0)
4,379
480
Data tables is a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…
Array Formulas in Excel Array Formulas in Excel
(0)
1,518
184
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
Charts and Dashboards in Excel (full version) Charts and Dashboards in Excel (full version)
(0)
4,153
7
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Excel Dashboard Template Excel Dashboard Template
(0)
5,161
4
This is a comprehensive Dashboard Template for typical kinds of Analysis including Sales Analysis, Variance Analysis, etc.
Unlocking Full Potential of Excel Data Tables (Part 2) Unlocking Full Potential of Excel Data Tables (Part 2)
(0)
4,477
3
This is the second part of my publication explaining an advanced and little-known method of using data tables for sensitivity…
Analysing sensitivities with indifference curves (unlocked) Analysing sensitivities with indifference curves (unlocked)
(0)
4,024
1
This is an unlocked version of the same utility published on my page. In this version you can access and…
Customer Relationship Manager (CRM) Customer Relationship Manager (CRM)
(0)
4,672
1
Have you noticed that CRM systems can be expensive? Maybe you want to track some very simple information but don't…
Event Table Allocator Event Table Allocator
(0)
152
0
In the modern work environment to benefit the most from the events (Christmas Dinner, team-building sessions, client conferences), organizers are…
Project Finance Model - Dynamic Excel Visualization Project Finance Model - Dynamic Excel Visualization
(0)
224
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ It…
Project Finance Model - Scenarios & Ratios Project Finance Model - Scenarios & Ratios
(0)
317
0
This project finance model is an advance version of the model you can find under the following link: https://www.eloquens.com/tool/XvxKFxl5/finance/project-finance-models/project-finance-model-unlimited-scenarios It…
Simple Sales Orders Solution Simple Sales Orders Solution
(0)
1,070
0
This is an an Excel template designed to provide sales order management. The template has all the features required to…