SAP Analysis for Microsoft Office - Official Product Tutorials

As you may be aware, SAP has taken a Cloud first strategy, which means SAP Analysis for office, as on-premise solution and mature product, will receive only limited investments from 2022 onwards.

The following tutorials have been developed to help you get started using the Business Intelligence Suite products.

Looking for eLearning for the rest of the Business Intelligence Suite? Go to sap.com/LearnBI.

2.6 Mark Rules Based on Crosstab Selection (0:50) video
2.6 Edit Formula Definition (3:14) video
2.6 Show Formulas In Crosstab (1:04) video
2.6 Copy All Rules To Clipboard (3:43) video
2.6 Fill Handling (autocomplete functionality) (1:33) video
2.6 Insert VLOOKUP with Table Design (4:13) video

2.5 Integration of SAP Analytics Cloud models (2:06) video
2.5 Table Design - Enhancements (2:51) video
2.5 Grouping - Enhancements (3:33) video
2.4 Workbook Protection (3:41) video
2.4 Group Members / Custom Hierarchy (2:51) video
2.4 Shared Axis (5:11) video
2.4 Linking Dimensions (3:30) video
2.4 Table Design Rules Tab: Enhancements (2:40) video
2.4 How to Customize User Interface Areas (5:41) video

2.3 Upload Filter Values Via File (1:36) video
2.3 Renaming Dimensions Attributes Measures (1:36) video
2.3 Explicit Selection (1:48) video
2.3 Design Rules Tab (5:21) video
2.3 RRI Enhancements (RRI as target) (3:13) video
2.3 How to Work with Activities? (2:31) video

2.2 Search By Attribute (1:03) video
2.2 Insert Excel Formula With TD (Vlookup) (2:23) video
2.2 Extend Style Sets (4:01) video
2.2 Open Workbook From EPM Repository (0:55) video
2.2 Search Improvements For Data Sources (0:52) video
2.2 HANA: Search Improvements For Data Sources (1:12) video
2.2 HANA: Filter By Measure (2:25) video

2.0 What’s new in Analysis, edition for Microsoft Office 2.0 (1:02) video
2.0 Set properties with the Enhanced Display Panel (0:54) video
2.0 Apply formats to crosstabs with Table Design (1:59) video
2.0 Insert lines into crosstabs with Table Design (1:00) video
2.0 Export a data source to Design Studio using Smart Copy (1:09) video
2.0 Export a data source to PowerPoint using Smart Copy (1:05) video
2.0 Connect to SAP HANA via HTTP (1:10) video
1.4 What’s new in Analysis, edition for Microsoft Office 1.4 (1:53) video
1.3 What’s new in Analysis, edition for Microsoft Office 1.3 (3:38) video
Navigate the interface in Microsoft Excel 2007 (12:06) video
Navigate the interface in Microsoft PowerPoint 2007 (5:31) video
1.2 Navigate the interface in Microsoft Excel 2010 (6:52) video
1.2 Navigate the interface in Microsoft PowerPoint 2010 (3:56) video
Enable the Add-In (1:59) video
Insert a data source directly from BW (3:01) video
Insert a data source using an OLAP Connection (2:40) video
1.1 Insert a data source using a local connection to SAP HANA (3:08) video

Add data to a crosstab (2:07) video
Set a value for a prompt (2:30) video
Create a calculation (1:17) video
Insert a dynamic calculation (1:16) video
Insert a dynamic chart (1:58) video
Insert a filter component (1:31) video
Insert an information field (2:08) video
Apply a style set (1:22) video
Create a style set (1:43) video
Export a style set (1:50) video
Delete a style set (0:59) video
Create a formula (1:44) video
Convert a crosstab to formulas (2:22) video

1.1 Display the planning features (1:17) video
1.1 Set the planning system (3:36) video
1.1 Add empty rows for planning (1:22) video
1.1 Add new planning data manually (4:31) video
1.1 Add data using a planning function (3:12) video

Sort data by measure (1:27) video
Sort data by dimension (1:56) video
Define a conditional format (3:02) video
Edit a conditional format (1:38) video
Create a background filter (1:22) video
Filter data by measure (1:38) video
Filter data by member (2:21) video
Filter data by member in a hierarchy (2:06) video

Create a PowerPoint slide (1:33) video
Save a workbook to the BI platform (1:51) video
Open a workbook from the BI platform (2:36) video
Insert a hyperlink to open a document in the BI platform (2:15) video
1.1 Save an Analysis View (1:57) video
1.1 Insert an Analysis View (2:53) video

1.3 Upload local data to an SAP BW Workspace (4:18) video
1.3 Reload local data to an SAP BW Workspace (1:58) video
1.3 Enrich an existing query with local data from an SAP BW Workspace (1:59) video
1.3 Define your preferred platform (1:22) video
1.3 Store a document in the SAP BW NetWeaver repository (1:29) video
1.3 Store prompt values as a variant (1:32) video
1.3 Navigate to another query or transaction using the Report-to-Report Interface (1:17) video