/
Browse
/
Courses
/
Discovering SAP Analysis for Microsoft Office
/
Setting Preferences
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 2 right to pass this unit.
1.
You can change User settings for Analysis only if your system administrator has enabled it.
Choose the correct answer.
True
False
2.
For what components can you set properties? There are three correct responses.
There are three correct answers.
Workbook
Worksheet
Crosstab
Data Source
Analysis View