Excel

Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below) Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below)
(2)
4,432
426
Making a waterfall chart is a powerful yet simple, visually attractive and compact way of visualizing the cost structure of…
Guiding Principles of Financial Modelling Guiding Principles of Financial Modelling
(0)
3,131
419
This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…
Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
2,446
331
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)
2,441
332
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Unlocking Full Potential of Excel Data Tables (Part 1) Unlocking Full Potential of Excel Data Tables (Part 1)
(0)
2,495
322
Data tables is a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…
Analysing data in Excel Analysing data in Excel
(0)
3,320
306
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Fruits_Sales_Dashboard... Fruits_Sales_Dashboard...
(0)
442
15
This Sales Dashboard give clear information in a precise way based upon products, months and countries.  
Charts and Dashboards in Excel (full version) Charts and Dashboards in Excel (full version)
(0)
2,199
5
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)
2,976
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)
2,564
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)
2,098
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)
2,551
1
Have you noticed that CRM systems can be expensive? Maybe you want to track some very simple information but don't…
Measuring and Modelling Seasonality Measuring and Modelling Seasonality
(0)
368
0
Many businesses are affected by seasonal demand changes. They cause their revenues, expenses and resource requirements change through the year.…
Real Estate Development Model - Office Real Estate Development Model - Office
(0)
393
0
Projects require detailed financial analysis of construction, operations, and financing to ensure that return targets are met and that there…
List Comparison to Determine New and/or Missing Items List Comparison to Determine New and/or Missing Items
(0)
592
0
Automatically compare and highlight the difference between two sets of data as well as the number of differences in each.…
Index Return in relation with Covid-19 Cases Index Return in relation with Covid-19 Cases
(0)
677
0
This excel file helps investors and professionals to understand the relationship between the index return and the cases of Covid-19…