excel training in uk - Financial Models

Resolved · Low Priority · Version Standard

Financial Models

Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course

by - delegate Tim [14 posts] (2007 Sep 5 Wed, 14:24) Reply

I have been sent a fairly large financial model that Im supposed to be familiarising myself with. Im trying to do some sensitivity analysis but changing key inputs to see what effect that has on the IRRs etc. Whilst the formulae are in placing linking all the different cells, teh linked cells are not automatically changing to reflect the new number in the input cell.

What do I need to do to ensure the model responds to new changes of value in the input cells??

Many Thanks,

Tim

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: financial Models

by - trainer Richard platinum contributer [818 posts] (2007 Sep 14 Fri, 09:49) Reply

Tim,

It sounds like Excel is not calculating the fomulae automatically.

To check that that this option is enabled, Click TOOLS > OPTIONS > CALCULATION

Make sure that the first button is selected (automatic calculation).

Let me know if this sorts the problem out.

Regards

Richard

· Benefits of learning about Excel charts
· MS Excel: Excel At Making The Most Of Your Christmas
· VBA Excel 2007
· How to Create Better Excel Spreadsheets: Part Two
· Tools From Advanced Excel Courses: Goal Seek and Solver

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Rate this page: