Excel

Guiding Principles of Financial Modelling Guiding Principles of Financial Modelling
(0)
6,352
778
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)
7,561
678
Making a waterfall chart is a powerful yet simple, visually attractive and compact way of visualizing the cost structure of…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
5,492
604
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
5,495
588
A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…
Analysing data in Excel Analysing data in Excel
(0)
6,328
589
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)
5,038
538
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)
2,273
302
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
CryptoCurrency Portfolio Dashboard in Microsoft Excel CryptoCurrency Portfolio Dashboard in Microsoft Excel
(0)
847
164
 CryptoCurrency Portfolio Dashboard in Microsoft Excel
Sales Analytics Dashboard in Microsoft Excel Sales Analytics Dashboard in Microsoft Excel
(0)
813
158
A sales dashboard is a tool that enables c-level executives and managers to effectively control sales KPIs and monitor them…
Financial Planning Calculators in Excel & What IF Analysis Financial Planning Calculators in Excel & What IF Analysis
(0)
577
47
 Financial Planning Calculators in Excel & What IF Analysis. CREDIT CARD INSTALLMENTS | CAR LOAN | PERSONAL LOAN. Example of…
Loan Amortization Schedule in Microsoft Excel Loan Amortization Schedule in Microsoft Excel
(0)
621
39
 Loan Amortization Schedule in Microsoft Excel
Charts and Dashboards in Excel (full version) Charts and Dashboards in Excel (full version)
(0)
5,055
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)
6,133
6
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)
5,341
4
This is the second part of my publication explaining an advanced and little-known method of using data tables for sensitivity…
Discounted Cash Flow (DCF) Model Discounted Cash Flow (DCF) Model
(0)
32
2
The Macabacus DCF template implements key concepts and best practices related to DCF modeling. It computes the perpetuity growth rate…