Installation and Configuration
Customize Analysis Office
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
