Analyzing data

You can recalculate worksheets, workbooks and cell ranges, and post data back to your product database using Data Send.

The Data Analysis group consists of:

  • Drilling down: enables you to drill down on any amount to display details of its composition.
  • Breakout: creates dependent worksheets for each item on which the breakout is defined.
  • Expand: allows you to view expanded results using buttons to the left of the worksheet