Download ebook: Essential guide to financial modelling

By Carly / 15 August 2012 / 2 comments

Financial modelling plays a vital role in all businesses and understanding how to use Excel to design efficient financial models can help to improve overall productivity and revenue.

If you need to get up to speed with Excel, we’ve put together a free ebook on the essentials of financial modelling.

In this free ebook, you will:

Learn how to design a financial model so that it’s efficient and correct
Discover how to write a user-defined function
Review different types of analysis and how these are used for forecasting

> Download the ebook now

And if you’d like to get more in-depth information on financial modelling, we also offer a comprehensive online training course, the 12 Hour MBA in Financial Modelling.

Tags: business skills, download, financial modelling, learning and development, skill acquisition, skills development, training

discuss this post

Sophie Marchand

on Sep 22, 2012
at 4:28 pm

Hi there,

I downloaded your ebook: The essential guide to financial modelling. Being an expert in financial modelling myself, I wanted to see what others were doing.

Let’s be honest, the guide is less from essential. You only point out a few tricks without even explaining them completely.

Also, you have some wrong information in there. For example, when you use “data tables”, you can place the data in one sheet and the “data tables” in another sheet, as long as you use “named ranges”.

Also, the rand() formula only gives numbers between 0 and 1. That’s right. But you can use randbetween() instead and put any numbers you want.

Hope this comment will help you improve your ebook.

Thanks,

Sophie

Reply
- Carly
  
  on Sep 25, 2012
  at 10:36 am
  
  Hi Sophie,
  
  Many thanks for your comments. The essential guide to financial modelling ebook is designed to give beginners an introduction to some of the key concepts in financial modelling; it is not intended to be a comprehensive guide to financial modelling. As such we were unable to go into detail about each concept, but instead aimed to give readers a useful insight.
  
  We do, however, run an online training course in financial modelling (see http://www.12hourmba.com for more details) which will explain the concepts fully, or a five-day course for anyone looking for a more comprehensive discussion.
  
  Thanks also for your additional tips – I’m sure readers will find them useful and your help is much appreciated!
  
  Thanks again,
  Carly
  
  Reply

Add a comment