Over the years, the denizens of AccountingWEB.co.uk’s ExcelZone have been enlightened and entertained by the Excel-related posts on the Chan

Could there be something in the personality profile of individuals who use Excel a lot that predisposes them to enjoy statistically complicated sports such as cricket and baseball?

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. 


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


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


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


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.


I am new to this, so apologies in advance.

I can retrieve transaction details using the following code:


Is there an off the shelf practice managment excel database?


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  ??