/
Browse
/
Courses
/
Creating Workbooks Using the SAP Analytics Cloud, Add-in for Microsoft Excel
/
Using the SAP Analytics Cloud, Add-in for Microsoft Excel Planning Functionality
Introducing SAP Analytics Cloud, Add-in for Microsoft Excel
Exploring Key Functionality and Data Sources
4 min
Exploring the Business Scenario
2 min
Launching the SAP Analytics Cloud, Add-in for Microsoft Excel and Connecting it to an SAP Analytics Cloud Tenant
4 min
Inserting Data Sources to the Workbook
10 min
Quiz
Getting Started with SAP Analytics Cloud, Add-in for Microsoft Excel
Displaying Data and Setting Up the Initial Table in the SAP Analytics Cloud, Add-in for Microsoft Excel
19 min
Sorting and Filtering Data in the SAP Analytics Cloud, Add-in for Microsoft Excel
10 min
Working with Variables and Prompts in the SAP Analytics Cloud, Add-in for Microsoft Excel
3 min
Working with Tables
8 min
Using SAP Formula Functions
9 min
Setting Analysis Preferences
4 min
Quiz
Using the SAP Analytics Cloud, Add-in for Microsoft Excel Planning Functionality
Performing Planning Activities Using the SAP Analytics Cloud, Add-in for Microsoft Excel
11 min
Adding Data Actions to a Worksheet
3 min
Quiz
Creating Reports by Combining Microsoft Excel and SAP Functions
Creating a Rolling Forecast Report
5 min
Quiz
Introducing SAP Analytics Cloud, Add-in for Microsoft Excel
Exploring Key Functionality and Data Sources
4 min
Exploring the Business Scenario
2 min
Launching the SAP Analytics Cloud, Add-in for Microsoft Excel and Connecting it to an SAP Analytics Cloud Tenant
4 min
Inserting Data Sources to the Workbook
10 min
Quiz
Getting Started with SAP Analytics Cloud, Add-in for Microsoft Excel
Displaying Data and Setting Up the Initial Table in the SAP Analytics Cloud, Add-in for Microsoft Excel
19 min
Sorting and Filtering Data in the SAP Analytics Cloud, Add-in for Microsoft Excel
10 min
Working with Variables and Prompts in the SAP Analytics Cloud, Add-in for Microsoft Excel
3 min
Working with Tables
8 min
Using SAP Formula Functions
9 min
Setting Analysis Preferences
4 min
Quiz
Using the SAP Analytics Cloud, Add-in for Microsoft Excel Planning Functionality
Performing Planning Activities Using the SAP Analytics Cloud, Add-in for Microsoft Excel
11 min
Adding Data Actions to a Worksheet
3 min
Quiz
Creating Reports by Combining Microsoft Excel and SAP Functions
Creating a Rolling Forecast Report
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.
You can plan on multiple models.
Choose the correct answer.
True
False
2.
Which option allows you to save data to the workbook?
Choose the correct answer.
Process Data
Publish Data
Revert Data
3.
What happens if you enter and process data for a parent node of a hierarchy?
Choose the correct answer.
An error message appears informing you that only base-level members can process data.
The planning value for the parent node is written to the workbook, but you must update the base-level values manually.
The planning value for the parent node will be applied proportionally to all unchanged elements of the hierarchy.