Excel

Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below) Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below)
(2)
1,828
161
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
(0)
788
106
The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…
Sensitivity analysis - advanced methods of using data tables
(0)
754
104
A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various…
Analysing data in Excel Analysing data in Excel
(0)
884
84
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Monte Carlo analysis without macros
(0)
603
79
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
324
32
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…
Unlocking Full Potential of Excel Data Tables (Part 2) Unlocking Full Potential of Excel Data Tables (Part 2)
(0)
782
1
This is a full version of my data table publication which explains how to:   - link several data tables…
Excel Dashboard Template Excel Dashboard Template
(0)
762
1
This is a comprehensive Dashboard Template for typical kinds of Analysis including Sales Analysis, Variance Analysis, etc.
Charts and Dashboards in Excel (full version) Charts and Dashboards in Excel (full version)
(0)
292
0
The attached file: - defines key chart elements and explains how to edit them - demonstrates how to deal with…
Analysing sensitivities with indifference curves (unlocked) Analysing sensitivities with indifference curves (unlocked)
(0)
301
0
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)
632
0
Have you noticed that CRM systems can be expensive? Maybe you want to track some very simple information but don't…