SAP Analysis for Microsoft Office
Practical Guide
Seiten
2021
SAP Press (Verlag)
978-1-4932-2004-5 (ISBN)
SAP Press (Verlag)
978-1-4932-2004-5 (ISBN)
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 reports. Then, follow step-by-step instructions to process and analyse data, develop planning applications, customize reports, and work with formulas and macros.
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, you’ll learn about:
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.
Highlights include:
Workbook creation
Report navigation
Prompts
Data processing, organization, and analysis
Planning applications
Report customization and formatting
Formulas
Macros
Configuration
Troubleshooting
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, you’ll learn about:
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.
Highlights include:
Workbook creation
Report navigation
Prompts
Data processing, organization, and analysis
Planning applications
Report customization and formatting
Formulas
Macros
Configuration
Troubleshooting
Reis, Denis Denis Reis is a business intelligence consultant at Dahlbeer. His areas of expertise include business intelligence, SAP Integrated Business Planning for Supply Chain, SAP Business Planning and Consolidation, and SAP Analysis for Microsoft Office. Denis also teaches project management and controlling at the Wiesbaden Business School.
Erscheinungsdatum | 18.01.2021 |
---|---|
Reihe/Serie | SAP PRESS Englisch |
Verlagsort | Maryland |
Sprache | englisch |
Themenwelt | Mathematik / Informatik ► Informatik ► Netzwerke |
Mathematik / Informatik ► Informatik ► Office Programme | |
Informatik ► Weitere Themen ► SAP | |
Schlagworte | BEx Analyzer • SAP Analysis for MS • SAP Analysis for Office • SAP BusinessObjects Analysis for Microsoft Office |
ISBN-10 | 1-4932-2004-7 / 1493220047 |
ISBN-13 | 978-1-4932-2004-5 / 9781493220045 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
das Praxishandbuch
Buch | Hardcover (2023)
Rheinwerk (Verlag)
79,90 €