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​.
  • Do not attempt to take this course without first completing IBP100 – SAP IBP for Supply Chain, Overview. If you attempt IBP110 without first completing the mandatory prerequisite, you will not achieve the maximum benefits and some concepts will be difficult to comprehend.
  • A self-paced e-learning version of this course is available with an active subscription to the SAP Learning Hub (Professional, or solution edition for Supply Chain Management).

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


  • IBP100 - SAP IBP for Supply Chain, Overview 


  • 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