Login Try Free
Series

Cell Reports

Available on ProPremium

Build reports cell by cell from the group’s data, with formulas, parameters, charts and exports, and keep them maintainable.

2 tracks · 18 tutorials

1

Cell Reports in depth

Cell Reports built cell by cell from your group’s data, with formulas, parameters, charts and exports.

For whoever produces the reporting · 12 tutorials

  1. Know when to use a Cell Report
  2. Lay out a Cell Report: sheets, cells and formats
  3. Bind cells to financial data
  4. Write formulas and use the formula helper
  5. Let readers choose the entity, period and currency
  6. Bring NCI, CTA, associates and eliminations into cells
  7. Let rows grow with the chart of accounts
  8. Format and highlight with conditional formatting
  9. Sort, filter and chart a Cell Report
  10. Replace a built-in statement with a Cell Report
  11. Drill, comment and export from a Cell Report
  12. Use a Cell Report in dashboards and packs
2

Keep Cell Reports maintainable

Cell Reports that keep working, month after month, as the group and its chart of accounts change.

For whoever produces the reporting · 6 tutorials

  1. Drive every period from one reporting-month cell
  2. Bind to types, totals and tags, not single accounts
  3. Separate parameters, data and presentation across sheets
  4. Insert, move and delete rows without breaking references
  5. Check a Cell Report after month-end and chart changes
  6. Name, share and control who can change a Cell Report
All series