相關主題
商品描述
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:
a. 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.
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 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:
1) Workbook creation
2) Report navigation
3) Prompts
4) Data processing, organization, and analysis
5) Planning applications
6) Report customization and formatting
7) Formulas
8) Macros
9) Configuration
10) Troubleshooting
商品描述(中文翻譯)
管理您的 SAP 數據於 Microsoft Excel？這是您使用 SAP Analysis for Microsoft Office 的指南。從創建您的第一個工作簿到瀏覽報告，從基本開始。然後，按照逐步指示處理數據、分析數據、開發規劃應用程序、自訂報告，並使用公式和宏等工具。包括故障排除、用戶介面自訂等詳細資訊，這本書是您的一站式資源。
在這本書中，您將學習到：
a. 報告與數據分析
學習如何在 SAP Analysis for Microsoft Office 中處理報告：定義帶提示的參數、調整格式和樣式，並使用本地數據擴展報告。使用層級過濾、排序和顯示您的數據，並通過簡單和高級計算來精煉數據分析。
b. 規劃
使用您的 SAP 數據開發規劃工作簿。手動和使用函數及序列規劃您的數據。了解單元格鎖定、規劃模型等的關鍵設置。
c. 高級功能
提升您的技能到下一個層次。編寫公式以在報告中使用，並在工作簿中創建和使用宏，包括使用 API 方法、回調和設計規則的步驟。
重點包括：
1) 工作簿創建
2) 報告導航
3) 提示
4) 數據處理、組織和分析
5) 規劃應用程序
6) 報告自訂和格式化
7) 公式
8) 宏
9) 配置
10) 故障排除
