Treewiz MS Excel Addin
Outlining for Excel ® data
Excel ® users set up hierarchical data in many different ways, but mostly it is just for visual layout. In current spreadsheets, setting up true hierarchies is a pain, and Excel itself provides little, if any, support for hierarchical data, other than manual “group/ungroup” functions, which have to be redone every time you change the outline structure – not really viable.
The full benefits of outline data can only be obtained when you’re able to analyse this structure for valid hierarchies and use the built-in outline controls for all data at all levels. TreeWiz enables you to bring the benefits of structured outlining to your existing data.
- Capture outline structures from 6 common data / layout combinations
- Apply tree structures to excel tables and tabular ranges on both columns and rows
- Apply the Outline grouping controls on Excel ® worksheets, enabling expand and collapse via multiple controls and functions
- Analyse tree structure completeness and distribution