Analysis Services and Excel Tips and Tricks

I was speaking with a Business Analyst the other day and I couldn't remember exactly how to do a cool trick I'd learned years ago working with Excel and Analysis Services. It got me thinking about some other cool techniques that I suspect many do not know about. If you've got a cool trick to share, please let us know in the comments.