Pivot tables

I was going to post a pivot table how-to but then I found this excellent blog post: http://chenected.aiche.org/tools-techniques/excelling-with-excel-2-pivot-tables/

Recommended!

Illustrating you're point with a qualitative graph

This is a good post on using excel to make a portfolio graph: http://johanlouwers.blogspot.com/2011/02/excel-magic-quadrant_18.html

How to hide dropdown arrows in Excel 2007 tables

I searched the internet in vain for this before reverting to the fool-proof strategy of clicking at random things in Excel. To turn the arrows off, go to the "Data" tab. The "Filter" button is highlighted. Click it and the arrows disappear. Click it again to reactivate the arrows on column headers. That's what I've learned today :-)

Happy new year!