Course Code: PAXUSE

Duration: 1 day


Basic knowledge of Planning Analytics Cubes and Microsoft Excel.


This course is designed for users who will be responsible for analysing data, creating reports, templates and applications. It provides users with the skills to create new reports, update existing reports, publish reports, work with cube viewer and modify data in a familiar Microsoft Excel spreadsheet environment.

Target Audience:

Client Model Builders, Client Project Manager, Client Support Manager, Client PA Application Administrator, Interface Architect, Key System Users, Model Builder, Support Model Designer, Model Lead Architect, Project Manager, Subject Matter Experts, Technical Architect, Test Lead, Trainer.


  1. Planning Analytics for Excel Analytics Overview
  2. Terminology
  3. Getting Started.
  4. Browsing Data.
  5. Working with Subsets.
  6. Working with Cubes and Views.
  7. Updating Data.
  8. Data Spreading.
  9. Worksheets.
  10. Reports.
  11. Calculations
  12. Conditional Formatting