Excel

I am calculating the XIRR on a set of cash flows over a lengthy period of time.  The XIRR formula gives me a 0% result, even though the XNPV formula works ok; the IRR formula gives a DIV/0 error. 

2

PwC senior manager Keith Power offers  insights into the most common Excel errors he encounters - and how to avoid them.

17

I am thinking of a new laptop, and using openoffice.org.   Wondering what others experiences are. Does it work with VTaccounts by any chance?

7

We have a new Excel spreadsheet to produce charity accounts that were previously on Lotus and Word.

15

I'm looking at putting together an expense sheet for my employees, (some of who travel around Europe), and want to keep it as simple and easy to use as possible for them.

4

I am new to this, so apologies in advance.

I can retrieve transaction details using the following code:

2

Is there an off the shelf practice managment excel database?

2

have setup data/filter  so that they are on

is there a maximum excel limit to the number of rows which this data sort  works on  ??

4

 

have an excel sheet containing a summary of a lot of word file, tables data which has been cut and pasted into excel

3

I am working with timesheets and want to turn time worked into a decimal number of hours to calculate the amount to be paid; eg 08.15 start, 17.45 finish = 9.5 hours worked.

Many Thanks

7

Pages