In this video course you will learn everything about SAP Analysis for Office. You will learn how to install, configure and customize Analysis Office. How to build your own complex reports with SAP Formulas and VBA Coding.
You learn in more than 4 hours tips and tricks about SAP Analysis for Office. For detail explanation check out the curriculum. All videos are in 4K.
Course Curriculum
- The Analysis Office Addin (10:50)
- The Ribbon menu (5:42)
- Your first Crosstab (3:12)
- Open and Save a workbook (3:08)
- Different context menus (5:16)
- Sorting your data (5:13)
- Filter your data by member (8:56)
- Filter your data within hierarchies (9:20)
- Filter your data directly on the Crosstab (3:33)
- Filter your data via background filter (4:05)
- Filter your data by measure (4:05)
- Use BEx Conditions in Analysis Office (1:35)
- Ranking (2:23)
- Access mode for filtering (2:44)
- Prompting and Variables (6:58)
- Allowed and forbidden areas (3:59)
- Swap Axes (1:43)
- Charts (1:21)
- How to use Infofields (2:59)
- Totals (4:39)
- How to display Members (2:56)
- Number Format/Currency Conversion/Scaling Factor/Zeros and Negative Values (4:07)
- Creating New Cells (6:37)
- Format Cells (5:21)
- Crosstab Configuration (4:13)
- Styles (4:40)
- How to use Conditional Formatting (6:20)
- Hierarchies (7:04)
- SAP Excel Formulas (7:38)
- Use Standard Calculations (2:47)
- How to use Dynamic Calculations (1:53)
- Create Advanced Calculations (3:53)
- Create Restrictions (4:03)
- Work with Query Views (2:03)
- Use the Filter Panel (3:43)
- Creating PowerPoint Slides (4:57)
- Use Excel Formulas in your Crosstab (5:25)
- Report-Report-Interface (2:41)
- Prompt Variants (4:51)
- Contains Pattern (2:36)
- Convert to formula (2:51)
- Create a Web Application (1:33)
- Launch the Query Designer (3:25)
- Use Smart Copy and Paste (2:06)
- Group your Crosstab and Link Dimensions (5:46)
- Build Hierarchies on the fly (3:00)
- Work with the formula-optimized mode (5:50)
- Create a default workbook (2:49)
Hi, I’m Tobias Meyer
I work in the SAP Business Warehouse environment since 2012. I worked for several companies in several different projects. Since 2014 I write the blog https://www.reyemsaibot.com about the topics Analysis for Office, SAP Business Warehouse, ABAP and SAP HANA.
I published the first edition of SAP Analysis Office - The Comprehensive Guide in 2016 and since January 2020 you can get the 5th edition of it. I worked as a team lead and also developed an automatic reporting tool for Analysis for Office.