Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SAP Analysis for Office
Installation and Configuration
Installation and Checks (3:07)
Authorizations (4:28)
Shortcut Properties (2:51)
Customize Analysis Office
Options (5:49)
Technical Configuration (3:58)
Customize User Interface (6:30)
Company and Embedded Profile (3:09)
Basic Functionality
The Analysis Office Addin (10:50)
The Ribbon menu (5:42)
Your first Crosstab (3:12)
Open and Save a workbook (3:08)
Different context menus (5:16)
Sorting your data (5:13)
Filter your data by member (8:56)
Filter your data within hierarchies (9:20)
Filter your data directly on the Crosstab (3:33)
Filter your data via background filter (4:05)
Filter your data by measure (4:05)
Use BEx Conditions in Analysis Office (1:35)
Ranking (2:23)
Access mode for filtering (2:44)
Prompting and Variables (6:58)
Allowed and forbidden areas (3:59)
Swap Axes (1:43)
Charts (1:21)
How to use Infofields (2:59)
Totals (4:39)
How to display Members (2:56)
Number Format/Currency Conversion/Scaling Factor/Zeros and Negative Values (4:07)
Creating New Cells (6:37)
Format Cells (5:21)
Crosstab Configuration (4:13)
Styles (4:40)
How to use Conditional Formatting (6:20)
Advanced Functions
Hierarchies (7:04)
SAP Excel Formulas (7:38)
Use Standard Calculations (2:47)
How to use Dynamic Calculations (1:53)
Create Advanced Calculations (3:53)
Create Restrictions (4:03)
Work with Query Views (2:03)
Use the Filter Panel (3:43)
Creating PowerPoint Slides (4:57)
Use Excel Formulas in your Crosstab (5:25)
Report-Report-Interface (2:41)
Prompt Variants (4:51)
Contains Pattern (2:36)
Convert to formula (2:51)
Create a Web Application (1:33)
Launch the Query Designer (3:25)
Use Smart Copy and Paste (2:06)
Group your Crosstab and Link Dimensions (5:46)
Build Hierarchies on the fly (3:00)
Work with the formula-optimized mode (5:50)
Create a default workbook (2:49)
Reporting with Analysis Office API and VBA
Overview (1:05)
Information (5:40)
Working (15:22)
Teach online with
Use Smart Copy and Paste
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock