Analysis for Office

Installation and Configuration

• Installation and Checks
• Authorizations
• Shortcut Properties

Customize Analysis Office

• Options
• Technical Configuration
• Customize User Interface
• Company and Embedded Profile

Basic Functionality

• The Analysis Office Addin
• The Ribbon menu
• Your first Crosstab
• Open and Save a workbook
• Different context menus
• Sorting your data
• Filter your data by member
• Filter your data within hierarchies
• Filter your data directly on the Crosstab
• Filter your data via background filter
• Filter your data by measure
• Use BEx Conditions in Analysis Office
• Ranking
• Access mode for filtering
• Prompting and Variables
• Allowed and forbidden areas
• Swap Axes
• Charts
• How to use Infofields
• Totals
• How to display Members
• Number Format/Currency Conversion/Scaling Factor/Zeros and Negative Values
• Creating New Cells
• Format Cells
• Crosstab Configuration
• Styles
• How to use Conditional Formatting

Advanced Functions

• Hierarchies
• SAP Excel Formulas
• Use Standard Calculations
• How to use Dynamic Calculations
• Create Advanced Calculations
• Create Restrictions
• Work with Query Views
• Use the Filter Panel
• Creating PowerPoint Slides
• Use Excel Formulas in your Crosstab
• Report-Report-Interface
• Prompt Variants
• Contains Pattern
• Convert to formula
• Create a Web Application
• Launch the Query Designer
• Use Smart Copy and Paste
• Group your Crosstab and Link Dimensions
• Build Hierarchies on the fly
• Work with the formula-optimized mode
• Create a default workbook

Reporting with Analysis Office API and VBA

• Overview
• Information
• Working