Skip to content
Financial-Modelling.net

Financial-Modelling.net

Tutorials, Courses, Trainings, Jobs and more

  • Home
  • Tutorials
    • Excel
    • Accounting
    • Finance
  • Books
  • Links
  • Imprint
Scroll down to content

Posts

Posted on February 1, 2012February 1, 2012

Excel: Control Accounts

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.

Continue reading "Excel: Control Accounts"

Posted on January 17, 2012November 20, 2015

The Financial Modelling Industry

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.

Continue reading "The Financial Modelling Industry"

Posted on December 13, 2011June 14, 2015

Excel: Retrieve Stock Quotes with a Spreadsheet Formula

Yahoo! Finance

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.

Continue reading "Excel: Retrieve Stock Quotes with a Spreadsheet Formula"

Posted on November 16, 2011June 14, 2015

Using Maps and Geographical Coordinates in Excel

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. Continue reading "Using Maps and Geographical Coordinates in Excel"

Posted on November 16, 2011November 18, 2011

Creating a Financial Model Step by Step

The Financial Modelling Process

Successfully building a financial model can be a complex process. This article shows you the main steps you should follow.

Continue reading "Creating a Financial Model Step by Step"

Posted on September 19, 2011October 25, 2011

Custom Number Formats in Excel

Excel: Number Formats

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.

Continue reading "Custom Number Formats in Excel"

Posted on September 4, 2011December 13, 2011

Speed Up Your VBA Macro

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.

Continue reading "Speed Up Your VBA Macro"

Posted on September 2, 2011December 12, 2011

Modelling Asset Utilisation Plans

Excel: Asset Utilisation Plan (1)

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.

Continue reading "Modelling Asset Utilisation Plans"

Posted on September 1, 2011October 25, 2011

Working with Flags

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.

Continue reading "Working with Flags"

Posted on September 1, 2011October 26, 2011

Using Colours and Formats

Financial models are complex constructs with sometimes gigantic sheets. Using cell formatting within Excel helps you to keep an overview.

Continue reading "Using Colours and Formats"

Posts navigation

Previous page Page 1 Page 2 Page 3 Page 4 Next page
Proudly powered by WordPress
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.OK Read More
Privacy & Cookies Policy