/
Browse
/
Courses
/
Discovering SAP Analysis for Microsoft Office
/
Getting Started with SAP Analysis for Excel
Getting Started with SAP Analysis for Excel
Listing Analysis for Office Data Sources
4 min
Launching Analysis for Excel
3 min
Connecting to an SAP System
5 min
Inserting a Data Source
9 min
Quiz
Analyzing Data in Analysis for Excel
Analyzing Data
13 min
Saving a Workbook
10 min
Changing Data Displays
16 min
Sorting Data
8 min
Filtering Data
35 min
Creating Measure Calculations
16 min
Working with Hierarchies
12 min
Working with Variables/Prompts
14 min
Adding Comments
3 min
Quiz
Setting Preferences
Setting Analysis Preferences
11 min
Using the Design Panel Components Tab to Set Properties
12 min
Quiz
Enhancing a Worksheet
Using SAP Formula Functions
15 min
Linking Dimensions
10 min
Grouping Crosstabs
9 min
Quiz
Formatting a Worksheet
Adding Design Components to a Worksheet
16 min
Defining and Using Conditional Formatting
11 min
Adding New Rows/Columns to a Crosstab
4 min
Customizing Crosstab Formatting Styles
19 min
Creating a Default Workbook
5 min
Quiz
Getting Started with SAP Analysis for Excel
Listing Analysis for Office Data Sources
4 min
Launching Analysis for Excel
3 min
Connecting to an SAP System
5 min
Inserting a Data Source
9 min
Quiz
Analyzing Data in Analysis for Excel
Analyzing Data
13 min
Saving a Workbook
10 min
Changing Data Displays
16 min
Sorting Data
8 min
Filtering Data
35 min
Creating Measure Calculations
16 min
Working with Hierarchies
12 min
Working with Variables/Prompts
14 min
Adding Comments
3 min
Quiz
Setting Preferences
Setting Analysis Preferences
11 min
Using the Design Panel Components Tab to Set Properties
12 min
Quiz
Enhancing a Worksheet
Using SAP Formula Functions
15 min
Linking Dimensions
10 min
Grouping Crosstabs
9 min
Quiz
Formatting a Worksheet
Adding Design Components to a Worksheet
16 min
Defining and Using Conditional Formatting
11 min
Adding New Rows/Columns to a Crosstab
4 min
Customizing Crosstab Formatting Styles
19 min
Creating a Default Workbook
5 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 3 right to pass this unit.
1.
Where can you save an Analysis View? There is one correct response.
Choose the correct answer.
SAP BusinessObjects BI Platform
SAP BW
SAP Analytics Cloud
2.
What are the supported data sources for SAP Analysis for Microsoft Office? There are four correct responses.
There are four correct answers.
SAP Business Warehouse
SAP HANA
SAP BusinessObjects BI Platform
SAP S/4HANA Cloud
SAP Analytics Cloud
3.
Which systems can you connect to save workbooks and access data sources? There are three correct responses.
There are three correct answers.
SAP BusinessObjects BI Platform
SAP Business Warehouse
SAP HANA
SAP Analytics Cloud
4.
What is the correct transaction code used to launch Analysis for PowerPoint from a SAP BW Application Server?
Choose the correct answer.
RAAOE
RAAOP
RAAFF
RAAMD