SAP Analysis for Microsoft Office-Practical Guide

  • 6h 45m
  • Denis Reis
  • Rheinwerk Publishing Inc.
  • 2021

Managing your SAP data in Microsoft Excel? This is your guide to using SAP Analysis for Microsoft Office! Get started with the basics, from creating your first workbook to navigating through reports. Then, follow step-by-step instructions to process data, analyze data, develop planning applications, customize reports, and work with tools such as formulas and macros. Including details on troubleshooting, UI customization, and more, this book is your all-in-one resource!

  • Use SAP Analysis for Microsoft Office for reporting and planning
  • Work with prompts, organize data, apply calculations, and format reports
  • Conduct advanced data analysis with formulas and macros

Reporting and Data Analysis

Learn to work with reports in SAP Analysis for Microsoft Office: define parameters with prompts, adjust formatting and styles, and extend reports with local data. Filter, sort, and display your data using hierarchies, and refine data analysis with simple and advanced calculations.


Use your SAP data to develop planning workbooks. Plan your data both manually and with functions and sequences. Understand key settings for cell locking, the planning model, and more.

Advanced Features

Take your skills to the next level. Write formulas to use in your reports, and create and use macros in your workbooks, including steps to use API methods, callbacks, and design rules.

  • Workbook creation
  • Report navigation
  • Prompts
  • Data processing, organization, and analysis
  • Planning applications
  • Report customization and formatting
  • Formulas
  • Macros
  • Configuration
  • Troubleshooting

About the Author

Denis Reis is a business intelligence consultant at Dahlbeer and, as an author, passes on his knowledge of everyday SAP projects. He has successfully implemented exciting projects at many well-known companies. His areas of expertise include SAP Analysis for Microsoft Office, SAP Business Intelligence, SAP Integrated Business Planning for Supply Chain, and SAP Business Planning and Consolidation. Furthermore, he teaches project management and controlling at the Wiesbaden Business School. Denis is a family man from Düsseldorf, and in his books, he avoids complicated presentations and provides his SAP knowledge in a nutshell.

In this Book

  • Create Your First Workbook
  • Navigating in Reports
  • Working with Prompts
  • Process Data
  • Organize Data
  • Working with Planning Applications
  • Shape Your Reports
  • Format Reports
  • Working with Tools in SAP Analysis for Microsoft Office
  • Working with Formulas
  • Using Macros
  • Configure SAP Analysis for Microsoft Office
  • Troubleshooting


Rating 4.5 of 2861 users Rating 4.5 of 2861 users (2861)
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)