Saturday, February 26, 2011

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!

Monday, January 3, 2011

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!