Sap Analytics Cloud Add-In For Microsoft Office

Unlock the Full Power of SAP Analytics Cloud with Microsoft Office

What you'll learn

Understand the Role of the SAP Analytics Cloud Add-In

Install and Configure the SAC Add-In for Microsoft Office

Build and Customize Data Tables in Excel

Apply Advanced Display and Calculation Features

Leverage SAP Functions for Dynamic Reporting

Execute Planning and Forecasting in Excel

Automate Planning Tasks with Data Action Starters

Create Insightful, Data-Driven Presentations in PowerPoint

Requirements

Foundational knowledge of SAP Analytics Cloud

Foundational knowledge of how stories and input templates are created in SAP Analytics Cloud

Intermediate knowledge of working with Microsoft Office products (Excel and PowerPoint)

Intermediate knowledge of working with Microsoft Excel formulas and functions

Description

Take your reporting and planning capabilities to the next level with our comprehensive SAP Analytics Cloud Add-In for Microsoft Office course. Designed for business users, analysts, and finance professionals, this course empowers you to seamlessly integrate the robust features of SAP Analytics Cloud (SAC) directly within the familiar environments of Excel and PowerPoint.You’ll start by learning how to install and configure the SAC add-in for Office, ensuring a smooth setup process. From there, you’ll dive into real-world applications—connecting to live SAC data, performing in-depth analysis, and creating dynamic, interactive reports directly in Excel using SAP-specific functions. Whether you're building dashboards or conducting data-driven forecasting, this course provides the tools and knowledge you need to streamline your workflows and make smarter business decisions.Beyond Excel, you'll discover how to embed SAC Stories into PowerPoint presentations, enabling you to deliver compelling, data-rich narratives that resonate with your audience. Perfect for executive briefings and stakeholder meetings, these skills help you transform raw data into actionable insights with style and precision.By the end of this course, you'll be fully equipped to harness the power of SAP Analytics Cloud within Microsoft Office—boosting your productivity, enhancing collaboration, and driving strategic outcomes across your organization.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Model Build for Exercises

Section 2: Getting Started with the SAC Add-in for Microsoft Office

Lecture 3 Overview of the SAC Add-in for Microsoft Office

Lecture 4 SAC Add-in for Microsoft Excel

Lecture 5 SAC Add-in for Microsoft PowerPoint

Lecture 6 Activating the Add-in and Signing In

Section 3: Using Tables

Lecture 7 Adding a Table

Lecture 8 Modifying Rows and Columns

Lecture 9 Using the Table Options

Lecture 10 Using Filters

Lecture 11 Sorting and Ranking

Lecture 12 Exercise: Adding and Filtering a Table

Lecture 13 More Dimension Settings

Lecture 14 Number Formatting

Lecture 15 Styling Thresholds

Lecture 16 Exercise: Styling and Thresholds

Lecture 17 Calculated Ad-Hoc Rows and Columns

Lecture 18 Applying a Formula

Lecture 19 Exercise: Add Variance Calculation

Section 4: SAP Functions

Lecture 20 Defining SAP Functions

Lecture 21 Adding a Data Source

Lecture 22 Workbook Set-Up

Lecture 23 SAP.GETTABLENAME

Lecture 24 SAP.GETTABLESTATUS

Lecture 25 SAP.GETDATA

Lecture 26 SAP.GETDIMENSIONS

Lecture 27 SAP.GETDIMENSIONFILTER

Lecture 28 SAP.GETMEMBERPROPERTY

Lecture 29 SAP.TIMEOFFSET

Lecture 30 SAP.OVERWRITEDIMENSIONFILTER

Lecture 31 SAP.SETDATA

Lecture 32 Exercise: Set-Up ID's with Functions

Lecture 33 Exercise: Set-Up IDs with Functions

Lecture 34 Exercise: Set-Up Date Sequence

Section 5: Planning with SAC Add-in for Microsoft Excel

Lecture 35 Planning Overview

Lecture 36 Aggregation and Disaggregation

Lecture 37 Data Actions

Lecture 38 Exercise: Creating Versions

Lecture 39 Exercise: Planning on an Excel Table

Lecture 40 Process, Refresh, Revert, and Publish

Lecture 41 Using Functions to Add Calculated Planning Input

Lecture 42 Limitations

Lecture 43 Exercise: Planning without a Table

Lecture 44 Adding a Data Action Starter

Lecture 45 Configuring a Planning Trigger

Section 6: SAC Add-in for Microsoft PowerPoint

Lecture 46 Overview of the SAC Add-in for PowerPoint

Lecture 47 Adding a Widget

Lecture 48 Refreshing Widgets

Lecture 49 Limitations

Lecture 50 Exercise: Add and Update Widgets

Business Analysts and Power Users seeking to enhance their data analysis and reporting skills within Excel and PowerPoint.,Application and Developer Consultants aiming to integrate SAC functionalities into Microsoft Office tools.,Business Process Owners and Team Leads focused on streamlining planning and decision-making processes.,Data Scientists and System Administrators interested in leveraging SAC's capabilities within a familiar Office environment.