In terms of general tips, have a look at #3 in this post.
Also, if you're having trouble defining POVs, an alternative approach is to build a Quick View, then use the function "Convert to XFGetCells", which will do all the work for you; you can then copypaste that formula where you need it.
Look into Navigator under Full Catalog; if you search for Excel, there are a lot of resources including demos. We also cover Excel functions as part of our Application Build for Administrators and Building Basic Reports courses - see the Training section of the main site.
If you think functions don't show the expected behaviour, by all means open a case with Support.
