Beschreibung
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!In this book, youll learn about:a. Reporting and Data AnalysisLearn 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. b. 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.c. Advanced FeaturesTake 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. Highlights include: 1) Workbook creation2) Report navigation3) Prompts4) Data processing, organization, and analysis5) Planning applications6) Report customization and formatting7) Formulas8) Macros9) Configuration10) Troubleshooting
Autorenporträt
Denis Reis is a business intelligence consultant at Deloitte. As an author, this family man from Düsseldorf hopes to pass on his knowledge of everyday SAP projects in a concise, approachable manner. He has successfully implemented exciting projects at many well-known companies. His areas of expertise include SAP BusinessObjects Business Intelligence, SAP BW Integrated Planning (SAP BW-IP), SAP Business Planning and Consolidation (SAP BPC), and SAP Analysis for Microsoft Office. Denis also teaches project management and controlling at the Wiesbaden Business School.
Herstellerkennzeichnung:
Rheinwerk Publishing, Inc.
2 Heritage Drive
02171 Quincy
US
E-Mail: info@rheinwerk-publishing.com
Produktverantwortlicher / Importeur:
Rheinwerk Verlag GmbH
Rheinwerk Verlag GmbH
Rheinwerkallee 4
53227 Bonn
DE
E-Mail: service@rheinwerk-verlag.de
Internet: www.rheinwerk-verlag.de
