Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Excel VBA: Switch Column Headings to Numbers

It’s Friday, and your brain is almost full, but let’s try to cram a little bit of Excel VBA in there before the weekend.
We’ve talked about the Excel Column Headings before, and seen how to change the Reference Style setting from R1C1 (Numbers) to A1 (Letters). That setting is pretty well hidden, and it’s a [...]