This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
Group your Crosstab and Link Dimensions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock