Analysis for Office

Analysis for Office

Part of our online library flat rate.

  • By
  • Tobias Meyer

Flatrate 12 month

19 USD per month

  • 12 Months
  • Single License
  • 19 USD 228 USD per year
  • 850+ eBooks and video tutorials
  • Tips and tricks from experts
  • Instant access
  • Renews automatically

Share this Product

Get Custom offer

  • 10+ Users
  • For departments or complete companies
  • Premium analytics

Language

English

Level

Beginner

Release

2021

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