Excel: Control Accounts
| Posted by financial-modelling.net under Excel, Tutorials |
The concept of "control accounts" is to break down multiple changes to a model variable instead of including every change in one huge and incomprehensible formula.
The Financial Modelling Industry
| Posted by financial-modelling.net under Finance, Tutorials |
In recent years, "Financial Modelling" in the sense of developing an integrated business plan has evolved into a thriving field for specialised consultants. This article portraits the main players.
Excel: Retrieve Stock Quotes with a Spreadsheet Formula
| Posted by financial-modelling.net under Excel |
Some financial models need to reference stock quotes at certain dates. Instead of using those as hard-coded input data, you can create an Excel formula that will retrieve stock prices for a given date.
Using Maps and Geographical Coordinates in Excel
| Posted by financial-modelling.net under Excel, Tutorials |
Sometimes, you will need to work with geographical coordinates in Excel and/or PowerPoint. This article shows you how to use Excel to work with coordinates and calculate the distances between locations for advanced mapping problems - it is pretty easy with only a handful of formulas.
Creating a Financial Model Step by Step
| Posted by financial-modelling.net under Tutorials |
Successfully building a financial model can be a complex process. This article shows you the main steps you should follow.
Custom Number Formats in Excel
| Posted by financial-modelling.net under Excel |
It is essential to define number formats in Excel in order to improve the usability of your model and the readability of its reports. This article explains how to do that.
Speed Up Your VBA Macro
| Posted by financial-modelling.net under Excel |
For more complex financial models, macro can become an integral part of the calculations. Letting them operate can slow down the work - in extreme cases up to hours. This article explains ways to speed up your macros.
Modelling Asset Utilisation Plans
| Posted by financial-modelling.net under Excel |
Asset utilisation plans are a simple way of presenting clearly the use of assets over a projected period. They are particularly important in industries with high variability or flexibility when it comes to renting and using assets.
Working with Flags
| Posted by financial-modelling.net under Excel |
One practice established among Excel power-users is to use "1" and "0" within data tables to indicate a "yes" or "no" or similar two-way attributes. The usage of such "binary" flags will be explained in this article.
Using Colours and Formats
| Posted by financial-modelling.net under Excel |
Financial models are complex constructs with sometimes gigantic sheets. Using cell formatting within Excel helps you to keep an overview.
Recent Comments