How to Build an Auto-Updating Excel Report Without Macros or Pivot Tables

Stop updating Excel manually. Discover how to use dynamic array formulas to create self-updating reports and dropdown lists ...
Yahoo

Creating an Excel Report: Charts, Tables, and Printing Tips

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...
Geeky Gadgets

Excel Tables: Structured References Work Better by Name

Structured references in Excel often get a bad reputation for being overly complex, but this perception usually stems from misunderstanding their purpose and functionality. Unlike traditional cell ...
MUO on MSN

Your pivot tables are okay, but rebuilding them this way takes 5 minutes and saves hours

Pivot Tables, but without the pain.