This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
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.
Customize Analysis for Office
Basic Functionality
Advanced Functions
-
8The Analysis for Office Addin
-
9The Ribbon menu
-
10Your first Crosstab
-
11Open and Save a workbook
-
12Different context menus
-
13Sorting your data
-
14Filter your data by member
-
15Filter your data within hierarchies
-
16Filter your data directly on the Crosstab
-
17Filter your data via background filter
-
18Filter your data by measure
-
19Use BEx Conditions in Analysis Office
-
20Ranking
-
21Access mode for filtering
-
22Prompting and Variables
-
23Allowed and forbidden areas
-
24Swap Axes
-
25Charts
-
26How to use Infofields
-
27Totals
-
28How to display Members
-
29Number Format/Currency Conversion/Scaling Factor/Zeros and Negative Values
-
30Creating New Cells
-
31Format Cells
-
32Crosstab Configuration
-
33Styles
-
34How to use Conditional Formatting
Reporting with Analysis Office API and VBA
-
35Hierarchies
-
36SAP Excel Formulas
-
37Use Standard Calculations
-
38How to use Dynamic Calculations
-
39Create Advanced Calculations
-
40Create Restrictions
-
41Work with Query Views
-
42Use the Filter Panel
-
43Creating PowerPoint Slides
-
44Use Excel Formulas in your Crosstab
-
45Report-Report-Interface
-
46Prompt Variants
-
47Contains Pattern
-
48Convert to formula
-
49Create a Web Application
-
50Launch the Query Designer
-
51Use Smart Copy and Paste
-
52Group your Crosstab and Link Dimensions
-
53Build Hierarchies on the fly
-
54Work with the formula-optimized mode
-
55Create a default workbook