SAP Analysis for Office

Learn Analysis Office from the scratch.

4.21 (162 reviews)

Udemy

platform

English

language

SAP

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

Why take this course?

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.

Reviews

December 19, 2023

Quality is not that great. However, I have to say that I have indeed learnt some stuff there. Thus thanks to the instructor.

Alex

November 22, 2023

Personally, I didn't find this course all that helpful but that's, in part, because you evidently need at least an intermediate understanding of SAP even though that is not listed in the Course Requirements section (but should be). It also seemed as though the course was more so a compilation of tips and tricks rather than an instructional course because many of the features were covered but lacked any meaningful context. Including some relevant business use cases for enhanced understanding is what separates great courses from the rest. Also, I think the instructor could have benefitted from having scripted the VBA portion of the course seeing as how a good portion of that section was troubleshooting/debugging which just confuses new users. And it just seemed like an odd conclusion to the lesson in general, especially when the lesson ends with "see you in the next video" followed by a message that says you've completed the course.

Rahul

October 13, 2023

Wow such a detailed explanation and a demo, insightful and delightful experience Tobias. Please record videos on other SAP Analytics Topics I would say, awaiting :)

Prince

September 10, 2023

its a really great presentation. The only problem I have is with the audio. I'm getting this whistling sound in the audio during speech , making it uncomfortable to hear in headphones.

Mohd

August 25, 2023

The overall information of this course is definitely useful but if you can reduce the resolution of the video or zoom in. I would be better to visual the data as well.

Roger

August 9, 2023

Good overall coverage of AO and its capabilities. Really liked the flow from each video and the way the functions were broken down and explained.

Benjamin

April 13, 2023

Its a great course all together, ill definitely be looking into other course to better my understanding of SAP

Charts

Price

Rating

Enrollment distribution

SAP Analysis for Office - Distribution chart