SAP Analysis for Office

Focused View

Tobias Meyer

4:18:51

79 View

1. Installation & Configuration

1. Installation.mp4

03:07

2. Authorizations.mp4

04:28

3. Shortcut Properties.mp4

02:51

2. Customize Analysis for Office

1. Options.mp4

05:49

2. Technical Configuration.mp4

03:58

3. Customize User Interface.mp4

06:30

4. Company and Embedded Profile.mp4

03:10

3. Basic Functionality

1. The Analysis for Office Addin.mp4

10:50

2. The Ribbon menu.mp4

05:42

3. Your first Crosstab.mp4

03:12

4. Open and Save a workbook.mp4

03:08

5. Different context menus.mp4

05:16

6. Sorting your data.mp4

05:13

7. Filter your data by member.mp4

08:56

8. Filter your data within hierarchies.mp4

09:20

9. Filter your data directly on the Crosstab.mp4

03:33

10. Filter your data via background filter.mp4

04:05

11. Filter your data by measure.mp4

04:05

12. Use BEx Conditions in Analysis Office.mp4

01:35

13. Ranking.mp4

02:23

14. Access mode for filtering.mp4

02:44

15. Prompting and Variables.mp4

06:58

16. Allowed and forbidden areas.mp4

03:59

17. Swap Axes.mp4

01:43

18. Charts.mp4

01:21

19. How to use Infofields.mp4

02:59

20. Totals.mp4

04:39

21. How to display Members.mp4

02:56

22. Number FormatCurrency ConversionScaling FactorZeros and Negative Values.mp4

04:07

23. Creating New Cells.mp4

06:37

24. Format Cells.mp4

05:21

25. Crosstab Configuration.mp4

04:13

26. Styles.mp4

04:40

27. How to use Conditional Formatting.mp4

06:20

4. Advanced Functions

1. Hierarchies.mp4

07:04

2. SAP Excel Formulas.mp4

07:38

3. Use Standard Calculations.mp4

02:47

4. How to use Dynamic Calculations.mp4

01:53

5. Create Advanced Calculations.mp4

03:54

6. Create Restrictions.mp4

04:03

7. Work with Query Views.mp4

02:03

8. Use the Filter Panel.mp4

03:43

9. Creating PowerPoint Slides.mp4

04:57

10. Use Excel Formulas in your Crosstab.mp4

05:26

11. Report-Report-Interface.mp4

02:41

12. Prompt Variants.mp4

04:51

13. Contains Pattern.mp4

02:36

14. Convert to formula.mp4

02:51

15. Create a Web Application.mp4

01:33

16. Launch the Query Designer.mp4

03:25

17. Use Smart Copy and Paste.mp4

02:06

18. Group your Crosstab and Link Dimensions.mp4

05:46

19. Build Hierarchies on the fly.mp4

03:00

20. Work with the formula-optimized mode.mp4

05:50

21. Create a default workbook.mp4

02:49

5. Reporting with Analysis Office API and VBA

1. Overview.mp4

01:05

2. Information.mp4

05:40

3. Working.mp4

15:22

Description

Learn Analysis Office from the scratch.

What You'll 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 is this for?

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

More details

Description
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.
Who this course is for:
This course is for employees in companys which have to use the Analysis for Office as reporting tool

User Reviews

Rating

average 0

Total votes0

Focused display

SAP

Tobias Meyer

Instructor's Courses

After training as a computer science businessman, I have educated oneself to a network administrator at the chamber of industry and commerce. Then I completed the training to business computer scientist, which is synonymous with the master craftsman. As further qualification I have completed the advanced training business informatics at the chamber of Crafts. Currently I am studying Business Informatics at the University of Applied Science Wismar.I have very good knowledge in Microsoft Office, as well as in Visual Basic (Application). I also have basic knowledge in ABAP and SAP Business Objects. In SAP Business Warehouse and Analysis Office I know myself well besides, I have extended basic knowledge in SAP ERP.additional skills:- Writen the book SAP BusinessObjects Analysis Office - The Comprehensive Guide- Introduction of SAGE Office Line at the company Padcon GmbH and Jurchen Technology GmbH- Programming a project planning and costing solution in the ERP system Alphaplan including time schedule- Experience in development of process chains, queries and data extraction- Development of an automated reporting for 18 branches- Conception, training and Implementation of own solutions to business warehouse systems- Experience in staff training and programming- Know-how in systems implementation and project management- Development of automated reporting with SAP BusinessObjects Analysis for Office

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.