SAP Analysis for Microsoft Office: Practical Guide SAP PRESS

SAP Analysis for Microsoft Office: Practical Guide (SAP PRESS) Denis Reis
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.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.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
Categories:
Computers – Applications & Software
Year:
2020
Edition:
1
Publisher:
SAP Press
Language:
english
Pages:
65 1352
ISBN 10:
1493220047
ISBN 13:
9781493220045
File:
499 MB