Dynamic Report / Active Forms

Version: Planning Analytics 2.0.9.20 and IBM Planning Analytics for Excel 2.1.11

In this class, students learn:

• How to build a report from scratch in Excel
• How to manipulate the key features
• How to apply filtering
• How to include Excel graphs
• How to use the advanced features in an Action Button
• How to set up columns that can dynamically expand and collapse on consolidations
• TM1 Functions for Excel you need to know
• Best practice principles for building an Excel report

At the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessment.