Course announcements

  • In this course you will learn about features and recent enhancements in the SAP Integrated Business Planning, add-in for Microsoft Excel. SAP IBP add-in for Microsoft Excel is a technically independent software that delivers significant benefits in performance and provides a foundation for future developments.

Course information

  • How to use the SAP sample planning views and how to adapt them 
  • How to create your own templates from scratch
  • Overview around the important options and functions in the report editor.  
  • Key figures editability and key figure groups
  • Advanced Formatting with the formatting sheet including Protection and Data Validation options and conditional formatting
  • Local Members  
  • Simple and complex use cases 
  • Extensibility capabilities
  • VBA Hooks and how they can be used to develop custom VBA code with an example 
  • How to trace and analyze performance logs and what are the important recommendations during implementation 
  • This course will prepare you to:
    • Adapt SAP sample planning views and create your own templates from scratch 
    • Describe in detail: Important functions and options in the report editor 
    • Perform tracing and analyze performance logs 
    • Use advance formatting in formatting sheet and utilize local members 
    • Learn about extensibility using VBA and test the implementation of the VBA hooks 
  • Application Consultant 
  • Business Analyst 
  • Business Process Architect 
  • Business Process Owner / Team Lead / Power User


  • * Essential: 
  • IBP100 - SAP IBP for Supply Chain, Overview  * Recommended: 
  • None 

Find a course date

Can't find a suitable date?

Booking for 1-2 people?

Make a request for us to schedule training around what works for you? We will do our best to consider your request.

Request a training date

Booking for 3+ people?

Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. You need at least three confirmed participants to register and SAP will add it to your schedule.

Find out more