Spreadsheet QualitySpreadsheet Design Concepts Series
Pivot Tables- Probably the most important feature in spreadsheets
- A superb way to manage complexity
- Most users can't access them because their data is already half pivoted.
- Repeated blocks are a strong hint to use pivots
- Pivot source data should generally have 1 one column with numbers in (slightly simplified)
- Allows Excel to work effectively with data with many more than 2 dimensions
|
|
|
Products for sale:
AltFileSearch
New information about the missing FileSearch feature in Office 2007 and details of our pragmatic solution (Current price GBP 25.00 + Vat)
wsUnprotector
Instant Excel worksheet protection remover and password recovery (Current price GBP 15.00 + Vat)
Classic Ribbon Tab
Add Excel 97/2000/2002/2003 compatible menu structure to Excel 2007
(Current Price GBP 10.00 + Vat)
Products coming soon:
XLAnalyst Pro
(Excel VBA based spreadsheet auditing tool)
Due before the end of 2009. |
