Analysis for Office

Part of:

Tobias Meyer

Language

English

Duration

04:19:23

Level

Beginner

Flat rate

$19 per month

Single license
1000+ eBooks and video tutorials
Instant access
12 months($228per year)
Automatic renewal

More options

Already have an account? Sign in here!

More Details

Installation and Configuration

Installation and Checks
Authorizations
Shortcut Properties

Customize Analysis Office

Options
Technical Configuration
Customize User Interface
Company and Embedded Profile

Basic Functionality

The Analysis Office Addin
The Ribbon menu
Your first Crosstab
Open and Save a workbook
Different context menus
Sorting your data
Filter your data by member
Filter your data within hierarchies
Filter your data directly on the Crosstab
Filter your data via background filter
Filter your data by measure
Use BEx Conditions in Analysis Office
Ranking
Access mode for filtering
Prompting and Variables
Allowed and forbidden areas
Swap Axes
Charts
How to use Infofields
Totals
How to display Members
Number Format/Currency Conversion/Scaling Factor/Zeros and Negative Values
Creating New Cells
Format Cells
Crosstab Configuration
Styles
How to use Conditional Formatting

Advanced Functions

Hierarchies
SAP Excel Formulas
Use Standard Calculations
How to use Dynamic Calculations
Create Advanced Calculations
Create Restrictions
Work with Query Views
Use the Filter Panel
Creating PowerPoint Slides
Use Excel Formulas in your Crosstab
Report-Report-Interface
Prompt Variants
Contains Pattern
Convert to formula
Create a Web Application
Launch the Query Designer
Use Smart Copy and Paste
Group your Crosstab and Link Dimensions
Build Hierarchies on the fly
Work with the formula-optimized mode
Create a default workbook

Reporting with Analysis Office API and VBA

Overview
Information
Working

Preview

Authors

Tobias Meyer More about the author

Ratings

D. Gallego
28.12.2021

Frequentlyasked questions

General questions and answers about our learning content.

Who is the learning content suitable for?

The learning content is designed for anyone who wants to gain SAP knowledge in a simple, compact, and practical way. Our learning platform offers content for beginners, advanced learners, and experts. This enables you to expand your knowledge step by step and continuously develop your skills toward becoming an SAP expert.

What makes the learning content special?

Our products—whether books, videos, or online training—deliver SAP knowledge concisely and practically, so you can apply it directly in your daily work, even if you have limited time. You benefit from a broad coverage of relevant SAP topics, high-quality content in four languages, and learning formats designed to fit your individual needs. This ensures that you can stay up to date and continuously develop your expertise.

What distinguishes our books from those of other providers?

Our books are characterized by a clear practical focus and a compact, easy-to-understand presentation. We explain complex SAP topics concisely—without unnecessary marketing buzzwords—so readers can quickly grasp the essentials and apply the new knowledge directly.

Can the product be exchanged?

Our print books can be returned within 14 days, in original condition. Return shipping is at your own cost.

How can I order a book outside of Germany?

We currently only ship books directly within Germany. If you are ordering from outside Germany, we recommend purchasing via Amazon. You can find the link by selecting “Buy eBook” on any product in our webshop and Amazon will then show you both the eBook and print versions available for purchase.

Alternatively, you can access all our content with a digital subscription, starting at $19 per month.

Who can I contact if I have questions?

Our team is always happy to help and will respond to your questions as quickly as possible (usually within 1–2 days). You can also contact us if you have questions for one of the authors. Email: contact@espresso-tutorials.com