SAP Analysis for Office

SAP Analysis for Office, available at $44.99, has an average rating of 4.35, with 58 lectures, based on 214 reviews, and has 1466 subscribers.

You will learn about Use Analysis for Office and create reports with it. How to use filters and display data How to use VBA in Analysis for Office workbooks Display Information and data in your reports This course is ideal for individuals who are This course is for employees in companys which have to use the Analysis for Office as reporting tool It is particularly useful for This course is for employees in companys which have to use the Analysis for Office as reporting tool.

Enroll now: SAP Analysis for Office

Summary

Title: SAP Analysis for Office

Price: $44.99

Average Rating: 4.35

Number of Lectures: 58

Number of Published Lectures: 58

Number of Curriculum Items: 58

Number of Published Curriculum Objects: 58

Original Price: €199.99

Quality Status: approved

Status: Live

What You Will Learn

Use Analysis for Office and create reports with it.
How to use filters and display data
How to use VBA in Analysis for Office workbooks
Display Information and data in your reports

Who Should Attend

This course is for employees in companys which have to use the Analysis for Office as reporting tool

Target Audiences

This course is for employees in companys which have to use the Analysis for Office as reporting tool

In this course, you will learn SAP Analysis for Office from scratch. I explain every single function of Analysis for Office to you. So you can start with no knowledge about Analysis for Office. And if you have already some knowledge about Analysis for Office, you can look into the advanced section and see what you can do with Analysis for Office.

You will learn how to filter data in different ways like in hierarchies, by members or via the background filter. How to customize the user interface and use the Analysis for Office options and technical settings to configure the behavior of Analysis for Office. If three is a setting to change the behavior, I will point it out to you.

I show you the different context menus you get on each function and how you can use it. You learn about the variable prompt and also about variables in Analysis for Office.

If you want to rank your data or display information about your data in your reports, you find information how to do so.

You will create hierarchies on the fly and create own calculated and restricted key figures. Furthermore, you will learn how to create a Microsoft PowerPoint presentation with your data and how to use Excel formulas in your report.

I teach you how to format and display your data in your report with conditional formatting, Microsoft Excel styles and charts which are linked to your data.

You also get an overview about the Analysis for Office API and Microsoft VBA.

Course Curriculum

Chapter 1: Installation & Configuration

Lecture 1: Installation

Lecture 2: Authorizations

Lecture 3: Shortcut Properties

Chapter 2: Customize Analysis for Office

Lecture 1: Options

Lecture 2: Technical Configuration

Lecture 3: Customize User Interface

Lecture 4: Company and Embedded Profile

Chapter 3: Basic Functionality

Lecture 1: The Analysis for Office Addin

Lecture 2: The Ribbon menu

Lecture 3: Your first Crosstab

Lecture 4: Open and Save a workbook

Lecture 5: Different context menus

Lecture 6: Sorting your data

Lecture 7: Filter your data by member

Lecture 8: Filter your data within hierarchies

Lecture 9: Filter your data directly on the Crosstab

Lecture 10: Filter your data via background filter

Lecture 11: Filter your data by measure

Lecture 12: Use BEx Conditions in Analysis Office

Lecture 13: Ranking

Lecture 14: Access mode for filtering

Lecture 15: Prompting and Variables

Lecture 16: Allowed and forbidden areas

Lecture 17: Swap Axes

Lecture 18: Charts

Lecture 19: How to use Infofields

Lecture 20: Totals

Lecture 21: How to display Members

Lecture 22: Number Format/Currency Conversion/Scaling Factor/Zeros and Negative Values

Lecture 23: Creating New Cells

Lecture 24: Format Cells

Lecture 25: Crosstab Configuration

Lecture 26: Styles

Lecture 27: How to use Conditional Formatting

Chapter 4: Advanced Functions

Lecture 1: Hierarchies

Lecture 2: SAP Excel Formulas

Lecture 3: Use Standard Calculations

Lecture 4: How to use Dynamic Calculations

Lecture 5: Create Advanced Calculations

Lecture 6: Create Restrictions

Lecture 7: Work with Query Views

Lecture 8: Use the Filter Panel

Lecture 9: Creating PowerPoint Slides

Lecture 10: Use Excel Formulas in your Crosstab

Lecture 11: Report-Report-Interface

Lecture 12: Prompt Variants

Lecture 13: Contains Pattern

Lecture 14: Convert to formula

Lecture 15: Create a Web Application

Lecture 16: Launch the Query Designer

Lecture 17: Use Smart Copy and Paste

Lecture 18: Group your Crosstab and Link Dimensions

Lecture 19: Build Hierarchies on the fly

Lecture 20: Work with the formula-optimized mode

Lecture 21: Create a default workbook

Chapter 5: Reporting with Analysis Office API and VBA

Lecture 1: Overview

Lecture 2: Information

Lecture 3: Working

Instructors

Tobias Meyer
Senior SAP Business Intelligence Consultant

Rating Distribution

1 stars: 2 votes
2 stars: 11 votes
3 stars: 37 votes
4 stars: 87 votes
5 stars: 77 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu