<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

Who is it for

End Users and Developers

Duration

4 hours

Difficulty

Beginner

End User (Planning Analytics for Excel)

Planning Analytics for Excel (PAfE) is an Excel add-in that allows you to display and update values from a TM1 database using cell-based functions. In this course, learn how to use PAfE efficiently to build Excel spreadsheets with the following lessons:

  • 1. How to use the interface
  • 2. How to analyse Cube data
  • 3. How to use the Dimension
  • 4. How to use the Subset
  • 5. How to use each report types
  • 6. How to export data to Excel
  • 7. How to use an Action Button
  • 8. How to publish a report
  • 9. An introduction to TM1 Web
  • 10. An introduction to Data Spreading

Interested in enrolling?