Training
SAP Analysis for Office
SAP Analysis for Office
This instructor-led custom training has been designed for enterprises that aim to empower their Business & Power Users in SAP Analysis for Office. The program typically lasts 1-2 days, and is offered in two formats:
- Training: A slightly longer format at your own workplace customized to suit your needs
- Workshop: Prescheduled sessions conducted in different cities where you have the option to learn along with industry peers
At the end of this SAP Analysis for Office training / workshop, participants will be able to
- Understand the role of SAP Analysis for Office in the overall SAP BI portfolio
- Create interactive reports & analysis templates by connecting to data sources
- Leverage best pracctices that enhance performance & productivity
Course Outline
BASIC
Creating & Administering Workbooks
Launching Options
Converting BEx Workbooks
Report Refresh
DATA ANALYSIS
Prompts
Filtering data
Hierarchy
Calculations
PROPERTIES
Inserting Components
Conditional Formatting
Design panel
Display Properties
CUSTOMIZATION
Tab in Ribbon
Arrange groups
Company profile
Embedding profile in a workbook
ADVANCED
Grouping and Linking Dimensions
Goto and Smart Copy
Working with Macros
Comments
Scheduling Reports
MISCELLANEOUS
Creating web application
Launch BEx Query Designer
Style set for crosstab
Profiling Statistics
Performance Optimization & Best Practices