SAP Analysis for Microsoft Office—Practical Guide

In this book, you’ll learn about:

1. 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.

2. Planning

   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.

3. 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.