Home > Excel Business Solutions > Excel Productivity > Data Management > Hierarchical Data Analysis Share

Hierarchical Data Analysis

Excel hierarchical data analysis for data management

Excel Hierarchical Data Analysis

Rate this solution:
(3.7/5 from 3 votes)
Hierarchical Data Analysis screenshot
Hierarchical Data Analysis for Excel (Excel +++) is a powerful Excel add-in designed to to simplify the analysis of complex data. The add-in allows to select rows of data to assign groups and/or subgroups for which respective totals are calculated for analysis.

Hierarchical Data Analysis for Excel saves time as the structures totals are calculated as data is updated and there is no requirement to enter formulas. It also allows to drag blocks of rows within the structure together with the data to redefine the hierarchy whilst preserving integrity of calculations.

Key features of Hierarchical Data Analysis for Excel include:
  • Hierarchical levels can be created and modified with drag and drop as well as keyboard combination (Alt + Ins, Del and directional arrows).
  • Automatic recalculation of new structure and underlying data updates.
  • Operation mode can be changed with the menu.
  • Rows are automatically colored to match the structure node.
  • Rows can be hidden and revealed using plus and minus icons provided.
  • Structures can be minimized to a certain level depth.

Hierarchical Data Analysis for Excel is compatible with Excel 2000 or higher.

Try It  Get It

Price: USD 24.00
(Updated on 2016-11-01)

Related Excel Solutions for Hierarchical Data Analysis

Index Numbering and LoggingNavigation and Auditing  Data ConsolidationData Management  Categorizing DataData Management  Reorganize DataData Management  Treemap Add-inPresentation and Reporting  Interactive DashboardsPresentation and Reporting  Organizational Chart TemplateHuman Resources

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.