Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

cashflows

ResolvedVersion 2007

Greg has attended:
Excel Intermediate course
Excel Advanced course

Cashflows

i want to show on the first row the amount of funds committed to a project. the next row below will show the funds being spent. so there is alage between the two. how do i arrange for the lag to be made automatically ?

RE: cashflows

Hi Greg,

Thanks for your question

Could you elaborate on your requirements for me? You say you have two values funds committed and funds spent and that there will be a difference between the two (Lag). You wish to be able to set the lag automatically to a predetermined value. This can be done by altering the projected funds or the actual spend.

Which one do you wish to vary?

Thanks

Stephen

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.