Category: Excel
Christmas Special: The Temperature at the North Pole
Posted by financial-modelling.net under Excel, Tutorials |
Christmas is coming up, and millions of children around the world want to know: How cold is it really at the North Pole, where Santa Claus reportedly resides? First off, where do we get the temperature from? The North Pole Environmental Observatory (NPEO) is operating floating bouys in the Arctic region and publishes temperature data […]
Countdown in Excel
Posted by financial-modelling.net under Excel, Tutorials |
You want your Excel spreadsheet to count down the days, hours, minutes and even seconds up to a special point in time? All it takes is one formula, one short VBA macro and a button.
Excel for Gaming? Why not!
Posted by financial-modelling.net under Excel, Tutorials |
To most people, Excel is the work tool that it is supposed to be. But not to everyone. Cary Walkin, a Chartered Accountant and Excel power-user, has built an Excel-based role-playing game: Arena.Xlsm. It is an impressive demonstration that entertainment is indeed possible with spreadsheets.
Common Size Financial Statements
Posted by paramdeepsingh under Accounting, Excel, Finance, Tutorials |
It is often hard to compare the financials of companies that are different in size. Common size financial statements are one way to make them comparable. This guest article explains how to common-size a P&L statement.
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.
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.
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.
Recent Comments